C# 常用公共方法

1.后台调用weburl

string hostUrl = "http://www.a.com?id=123" ;
HttpWebRequest myReq = (HttpWebRequest)WebRequest.Create(hostUrl);
myReq.Method = "GET";

HttpWebResponse HttpWResp = (HttpWebResponse)myReq.GetResponse();
Stream myStream = HttpWResp.GetResponseStream();
StreamReader sr = new StreamReader(myStream, Encoding.UTF8);
StringBuilder strBuilder = new StringBuilder();
while (-1 != sr.Peek())
{
strBuilder.Append(sr.ReadLine());
}
sr.Close();
myStream.Close();
HttpWResp.Close();

Newtonsoft.Json.Linq.JObject jo = (Newtonsoft.Json.Linq.JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(strBuilder.ToString());
string resCode = jo["ReturnCode"].ToString();

2.检测输入URL是否合法

/// <summary>
    /// 判断网址是否可以访问
    /// </summary>
    /// <param name="Url"></param>
    /// <returns></returns>
    protected bool ChkPageUrl(string url)
    {
        bool result = false;
        try
        {
            HttpWebRequest myHttpWebRequest = (HttpWebRequest)WebRequest.Create(url);
            myHttpWebRequest.UserAgent = "Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko";
            myHttpWebRequest.Method = "GET";
            HttpWebResponse myHttpWebResponse = (HttpWebResponse)myHttpWebRequest.GetResponse();
            if (myHttpWebResponse.StatusCode == HttpStatusCode.OK)
            {
                result = true;
            }
            myHttpWebResponse.Close();
        }
        catch
        {
            result = false;
        }

        return result;
    }

3.批量导出

/// <summary>
        /// 批量导出
        /// </summary>
        /// <returns></returns>
        public FileResult ExportStu()
        {
            //创建Excel文件的对象
            NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
            //添加一个sheet
            NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1");
            int pager_totalcount = (int)Session["pager_totalcount"];
            int totalCount = 0;
            //获取list数据
            List<ArticleEntity> infoList = new AchieveDAL.MyTestDAL().GetArticleList("", pager_totalcount, 1, out totalCount);

            //给sheet1添加第一行的头部标题
            NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0);
            //创建时间    名称    商户订单号 | 交易号    对方    金额(元)    状态
            row1.CreateCell(0).SetCellValue("编号");
            row1.CreateCell(1).SetCellValue("标题");
            row1.CreateCell(2).SetCellValue("内容");
            int Width = 256;
            sheet1.SetColumnWidth(0, 10 * Width);
            sheet1.SetColumnWidth(1, 25 * Width);
            sheet1.SetColumnWidth(2, 60 * Width);
            if (infoList != null)
            {
                var list = infoList.OrderByDescending(p => p.ID);

                if (list != null)
                {
                    int i = 0;
                    //将数据逐步写入sheet1各个行
                    foreach (var item in list)
                    {
                        i = i + 1;
                        NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(i);
                        rowtemp.CreateCell(0).SetCellValue(item.ID.ToString());
                        rowtemp.CreateCell(1).SetCellValue(item.Title == null ? "" : item.Title.ToString());
                        rowtemp.CreateCell(2).SetCellValue(item.Content == null ? "" : item.Content.ToString());
                    }
                }
            }
            // 写入到客户端 
            System.IO.MemoryStream ms = new System.IO.MemoryStream();
            book.Write(ms);
            ms.Seek(0, System.IO.SeekOrigin.Begin);
            return File(ms, "application/vnd.ms-excel", HttpUtility.UrlEncode("导出", Encoding.UTF8).ToString() + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");

        }

4.批量导入

 <input name="file" type="file" id="file" />
<input type="submit" name="Upload" value="上传" />

/// <summary>
        /// 批量导入
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        public ActionResult ImportStu()
        {
            HttpPostedFileBase file = Request.Files["file"];
            string FileName;
            string savePath;
            if (file == null || file.ContentLength <= 0)
            {
                return Content("<script>alert('上传失败,请选择上传文件!');location.href='/MyTest/MVCPager';</script>");
            }
            else
            {
                string filename = Path.GetFileName(file.FileName);
                int filesize = file.ContentLength;//获取上传文件的大小单位为字节byte
                string fileEx = System.IO.Path.GetExtension(filename);//获取上传文件的扩展名
                string NoFileName = System.IO.Path.GetFileNameWithoutExtension(filename);//获取无扩展名的文件名
                string FileType = ".xls,.xlsx";//定义上传文件的类型字符串
                if (FileType.Contains(".exe"))//EXCEL
                {
                    return Content("<script>alert('上传文件类型格式错误,不允许导入exe格式的文件!');location.href='/MyTest/MVCPager';</script>");
                }
                FileName = NoFileName + DateTime.Now.ToString("yyyyMMddhhmmss") + fileEx;
                string path = AppDomain.CurrentDomain.BaseDirectory + "uploads/";
                savePath = Path.Combine(path, FileName);
                file.SaveAs(savePath);

                if (FileType.Contains(fileEx))//EXCEL
                {
                    string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + savePath + ";" + "Extended Properties=Excel 8.0";
                    OleDbConnection conn = new OleDbConnection(strConn);
                    conn.Open();
                    OleDbDataAdapter myCommand = new OleDbDataAdapter("select * from [Sheet1$]", strConn);
                    DataSet myDataSet = new DataSet();
                    try
                    {
                        myCommand.Fill(myDataSet, "ExcelInfo");
                    }
                    catch (Exception ex)
                    {
                        return Content("<script>alert('上传失败," + ex.Message + "!');location.href='/MyTest/MVCPager';</script>");
                    }
                    //列顺序 标题 内容
                    DataTable table = myDataSet.Tables["ExcelInfo"].DefaultView.ToTable();

                    //事物 异常回滚
                    using (TransactionScope transaction = new TransactionScope())
                    {
                        for (int i = 0; i < table.Rows.Count; i++)
                        {
                            ArticleEntity model = new ArticleEntity();
                            model.Title = table.Rows[i][0].ToString();
                            model.Content = table.Rows[i][1].ToString();
                            new AchieveDAL.MyTestDAL().AddArticle(model);
                        }
                        transaction.Complete();
                    }
                }

                return RedirectToAction("MVCPager", "MyTest");
            }
        }

5.获取客户端的IP地址

/// <summary>
        /// 获取客户端的IP地址
        /// </summary>
        /// <returns>客户端IP地址</returns>
        public static string Get_ClientIP()
        {
            string result = string.Empty;
            result = HttpContext.Current.Request.Headers["X-Real-IP"]; //Nginx 为前端时获取IP地址的方法
            if (result != null)
                return result;

            if (HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"] != null)//发出请求的远程主机的IP地址
            {
                result = HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"].ToString();
            }
            else if (HttpContext.Current.Request.ServerVariables["HTTP_VIA"] != null)//判断是否设置代理，若使用了代理
            {
                if (HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"] != null)//获取代理服务器的IP
                {
                    result = HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"].ToString();
                }
                else
                {
                    result = HttpContext.Current.Request.UserHostAddress;
                }
            }
            else
            {
                result = HttpContext.Current.Request.UserHostAddress;
            }
            if (result == "::1")
                result = string.Empty;
            return result;
        }

6.AES对称加密

   /// <summary>
    /// 对称加密类
    /// </summary>
    public class AES
    {
        /// <summary>
        /// 解密
        /// </summary>
        /// <param name="strDecrypt"></param>
        /// <param name="strKey"></param>
        /// <returns></returns>
        public static string Decrypt(string strDecrypt, string strKey)
        {
            try
            {
                byte[] bytes = Encoding.UTF8.GetBytes(FormsAuthentication.HashPasswordForStoringInConfigFile(strKey, "md5"));
                byte[] inputBuffer = Convert.FromBase64String(strDecrypt);
                byte[] buffer3 = null;
                using (RijndaelManaged managed = new RijndaelManaged())
                {
                    managed.Key = bytes;
                    managed.Mode = CipherMode.ECB;
                    managed.Padding = PaddingMode.PKCS7;
                    buffer3 = managed.CreateDecryptor().TransformFinalBlock(inputBuffer, 0, inputBuffer.Length);
                }
                return Encoding.UTF8.GetString(buffer3);
            }
            catch
            {
                return null;
            }
        }

        /// <summary>
        /// 解密
        /// </summary>
        /// <param name="strDecrypt"></param>
        /// <param name="strKey"></param>
        /// <returns></returns>
        public static string Decrypt(string toDecrypt, string key, string iv)
        {
            byte[] bytes = Encoding.UTF8.GetBytes(key);
            byte[] buffer2 = Encoding.UTF8.GetBytes(iv);
            byte[] inputBuffer = Convert.FromBase64String(toDecrypt);
            RijndaelManaged managed = new RijndaelManaged
            {
                Key = bytes,
                IV = buffer2,
                Mode = CipherMode.CBC,
                Padding = PaddingMode.Zeros
            };
            byte[] buffer4 = managed.CreateDecryptor().TransformFinalBlock(inputBuffer, 0, inputBuffer.Length);
            return Encoding.UTF8.GetString(buffer4);
        }

        public static string DecryptStr(string EncryptString)
        {
            string str = "";
            if (!string.IsNullOrEmpty(EncryptString))
            {
                string sSource = Decrypt(EncryptString, "cn.solefu");
                if (Utility.Left(sSource, 3) == "gk_")
                {
                    str = sSource.Substring(3);
                }
            }
            return str;
        }

        public static string DecryptStrByCBC(string EncryptString)
        {
            string str = "";
            if (!string.IsNullOrEmpty(EncryptString))
            {
                string sSource = Decrypt(EncryptString, "cn.solefu", "cn.solefu");
                if (Utility.Left(sSource, 3) == "gk_")
                {
                    str = sSource.Substring(3);
                }
            }
            return str;
        }

        /// <summary>
        /// 加密
        /// </summary>
        /// <param name="strEncrypt"></param>
        /// <param name="strKey"></param>
        /// <returns></returns>
        public static string Encrypt(string strEncrypt, string strKey)
        {
            try
            {
                byte[] bytes = Encoding.UTF8.GetBytes(FormsAuthentication.HashPasswordForStoringInConfigFile(strKey, "md5"));
                byte[] inputBuffer = Encoding.UTF8.GetBytes(strEncrypt);
                byte[] inArray = null;
                using (RijndaelManaged managed = new RijndaelManaged())
                {
                    managed.Key = bytes;
                    managed.Mode = CipherMode.ECB;
                    managed.Padding = PaddingMode.PKCS7;
                    inArray = managed.CreateEncryptor().TransformFinalBlock(inputBuffer, 0, inputBuffer.Length);
                }
                return Convert.ToBase64String(inArray, 0, inArray.Length);
            }
            catch
            {
                return null;
            }
        }

        /// <summary>
        /// 加密
        /// </summary>
        /// <param name="strEncrypt"></param>
        /// <param name="strKey"></param>
        /// <returns></returns>
        public static string Encrypt(string toEncrypt, string key, string iv)
        {
            byte[] bytes = Encoding.UTF8.GetBytes(key);
            byte[] buffer2 = Encoding.UTF8.GetBytes(iv);
            byte[] inputBuffer = Encoding.UTF8.GetBytes(toEncrypt);
            RijndaelManaged managed = new RijndaelManaged
            {
                Key = bytes,
                IV = buffer2,
                Mode = CipherMode.CBC,
                Padding = PaddingMode.Zeros
            };
            byte[] inArray = managed.CreateEncryptor().TransformFinalBlock(inputBuffer, 0, inputBuffer.Length);
            return Convert.ToBase64String(inArray, 0, inArray.Length);
        }

        public static string EncryptStr(string SourceString)
        {
            return Encrypt("gk_" + SourceString, "cn.solefu");
        }

        public static string EncryptStr(string SourceString, bool UseInUrl)
        {
            return HttpUtility.UrlEncode(EncryptStr(SourceString));
        }

        public static string EncryptStrByCBC(string SourceString)
        {
            return Encrypt("gk_" + SourceString, "cn.solefu", "cn.solefu");
        }

        public static string EncryptStrByCBC(string SourceString, bool UseInUrl)
        {
            return HttpUtility.UrlEncode(EncryptStrByCBC(SourceString));
        }
    }

7.Cookies帮助类

public class CookiesHelper
    {
        public static void AddCookie(string cookieName, DateTime expires)
        {
            HttpCookie cookie = new HttpCookie(cookieName)
            {
                Expires = expires
            };
            AddCookie(cookie, null);
        }

        public static void AddCookie(string key, string value)
        {
            AddCookie(new HttpCookie(key, value), null);
        }

        public static void AddCookie(HttpCookie cookie, string Domain)
        {
            HttpResponse response = HttpContext.Current.Response;
            if (response != null)
            {
                cookie.HttpOnly = true;
                cookie.Path = "/";
                if (!string.IsNullOrEmpty(Domain))
                {
                    cookie.Domain = Domain;
                }
                response.AppendCookie(cookie);
            }
        }

        public static void AddCookie(string cookieName, DateTime expires, string Domain)
        {
            HttpCookie cookie = new HttpCookie(cookieName)
            {
                Expires = expires
            };
            AddCookie(cookie, Domain);
        }

        public static void AddCookie(string key, string value, DateTime expires)
        {
            HttpCookie cookie = new HttpCookie(key, value)
            {
                Expires = expires
            };
            AddCookie(cookie, null);
        }

        public static void AddCookie(string cookieName, string key, string value)
        {
            HttpCookie cookie = new HttpCookie(cookieName);
            cookie.Values.Add(key, value);
            AddCookie(cookie, null);
        }

        public static void AddCookie(string key, string value, bool withDomain, string Domain)
        {
            if (withDomain)
            {
                AddCookie(new HttpCookie(key, value), Domain);
            }
            else
            {
                AddCookie(new HttpCookie(key, value), null);
            }
        }

        public static void AddCookie(string key, string value, DateTime expires, string Domain)
        {
            HttpCookie cookie = new HttpCookie(key, value)
            {
                Expires = expires
            };
            AddCookie(cookie, Domain);
        }

        public static void AddCookie(string cookieName, string key, string value, DateTime expires)
        {
            HttpCookie cookie = new HttpCookie(cookieName)
            {
                Expires = expires
            };
            cookie.Values.Add(key, value);
            AddCookie(cookie, null);
        }

        public static void AddCookie(string cookieName, string key, string value, string Domain)
        {
            HttpCookie cookie = new HttpCookie(cookieName);
            cookie.Values.Add(key, value);
            AddCookie(cookie, Domain);
        }

        public static void AddCookie(string cookieName, string key, string value, DateTime expires, string Domain)
        {
            HttpCookie cookie = new HttpCookie(cookieName)
            {
                Expires = expires
            };
            cookie.Values.Add(key, value);
            AddCookie(cookie, Domain);
        }

        public static void AddDomainCookie(string key, string value, string Domain)
        {
            AddCookie(new HttpCookie(key, value), Domain);
        }

        public static HttpCookie GetCookie(string cookieName)
        {
            HttpRequest request = HttpContext.Current.Request;
            if (request != null)
            {
                if (request.Cookies[cookieName] != null)
                {
                    return request.Cookies[cookieName];
                }
                if (request.Cookies[", " + cookieName] != null)
                {
                    return request.Cookies[", " + cookieName];
                }
            }
            return null;
        }

        public static string GetCookieValue(string cookieName)
        {
            return GetCookieValue(cookieName, null);
        }

        public static string GetCookieValue(string cookieName, string key)
        {
            HttpRequest request = HttpContext.Current.Request;
            if (request == null)
            {
                return "";
            }
            if (request.Cookies[cookieName] != null)
            {
                if (!string.IsNullOrEmpty(key) && request.Cookies[cookieName].HasKeys)
                {
                    return request.Cookies[cookieName].Values[key];
                }
                return request.Cookies[cookieName].Value;
            }
            string str = ", " + cookieName;
            if (request.Cookies[str] == null)
            {
                return "";
            }
            if (!string.IsNullOrEmpty(key) && request.Cookies[str].HasKeys)
            {
                return request.Cookies[str].Values[key];
            }
            return request.Cookies[str].Value;
        }

        public static string GetCookieValue(HttpCookie cookie, string key)
        {
            if (cookie == null)
            {
                return "";
            }
            if (!string.IsNullOrEmpty(key) && cookie.HasKeys)
            {
                return cookie.Values[key];
            }
            return cookie.Value;
        }

        public static void RemoveCookie(string cookieName)
        {
            RemoveCookie(cookieName, null);
        }

        public static void RemoveCookie(string cookieName, string key)
        {
            HttpResponse response = HttpContext.Current.Response;
            if (response != null)
            {
                HttpCookie cookie = response.Cookies[cookieName];
                if (cookie != null)
                {
                    if (!string.IsNullOrEmpty(key) && cookie.HasKeys)
                    {
                        cookie.Values.Remove(key);
                    }
                    else
                    {
                        response.Cookies.Remove(cookieName);
                    }
                }
            }
        }

        public static void SetCookie(string cookieName, DateTime expires)
        {
            SetCookie(cookieName, null, null, new DateTime?(expires), null);
        }

        public static void SetCookie(string key, string value)
        {
            SetCookie(key, null, value, null, null);
        }

        public static void SetCookie(string cookieName, DateTime expires, string Domain)
        {
            SetCookie(cookieName, null, null, new DateTime?(expires), Domain);
        }

        public static void SetCookie(string key, string value, DateTime expires)
        {
            SetCookie(key, null, value, new DateTime?(expires), null);
        }

        public static void SetCookie(string cookieName, string key, string value)
        {
            SetCookie(cookieName, key, value, null, null);
        }

        public static void SetCookie(string key, string value, bool withDomain, string Domain)
        {
            if (withDomain)
            {
                SetCookie(key, null, value, null, Domain);
            }
            else
            {
                SetCookie(key, null, value, null, null);
            }
        }

        public static void SetCookie(string key, string value, DateTime expires, string Domain)
        {
            SetCookie(key, null, value, new DateTime?(expires), Domain);
        }

        public static void SetCookie(string cookieName, string key, string value, string Domain)
        {
            SetCookie(cookieName, key, value, null, Domain);
        }

        public static void SetCookie(string cookieName, string key, string value, DateTime? expires, string Domain)
        {
            HttpResponse response = HttpContext.Current.Response;
            if (response != null)
            {
                HttpCookie cookie = response.Cookies[cookieName];
                if (cookie != null)
                {
                    cookie.Path = "/";
                    if (!string.IsNullOrEmpty(Domain))
                    {
                        cookie.Domain = Domain;
                    }
                    if (!string.IsNullOrEmpty(key) && cookie.HasKeys)
                    {
                        cookie.Values.Set(key, value);
                    }
                    else if (!string.IsNullOrEmpty(value))
                    {
                        cookie.Value = value;
                    }
                    if (expires.HasValue)
                    {
                        cookie.Expires = expires.Value;
                    }
                    response.SetCookie(cookie);
                }
            }
        }
        /// <summary>
        /// 设置域的cookie
        /// </summary>
        /// <param name="key"></param>
        /// <param name="value"></param>
        /// <param name="Domain"></param>
        public static void SetDomainCookie(string key, string value, string Domain)
        {
            SetCookie(key, null, value, null, Domain);
        }
    }

8.DataTable转换成实体类

    /// <summary>
    ///   #region DataTable转换成实体类
    /// </summary>
    /// <typeparam name="T"></typeparam>
    public class ModelUtil<T> where T : new()
    {

        /// <summary>
        /// 填充对象列表：用DataSet的第一个表填充实体类
        /// </summary>
        /// <param name="ds">DataSet</param>
        /// <returns></returns>
        public static List<T> FillModel(DataSet ds)
        {
            if (ds == null || ds.Tables[0] == null || ds.Tables[0].Rows.Count == 0)
            {
                return null;
            }
            else
            {
                return FillModel(ds.Tables[0]);
            }
        }

        /// <summary>  
        /// 填充对象列表：用DataSet的第index个表填充实体类
        /// </summary>  
        public static List<T> FillModel(DataSet ds, int index)
        {
            if (ds == null || ds.Tables.Count <= index || ds.Tables[index].Rows.Count == 0)
            {
                return null;
            }
            else
            {
                return FillModel(ds.Tables[index]);
            }
        }

        /// <summary>  
        /// 填充对象列表：用DataTable填充实体类
        /// </summary>  
        public static List<T> FillModel(DataTable dt)
        {
            if (dt == null || dt.Rows.Count == 0)
            {
                return null;
            }
            List<T> modelList = new List<T>();
            foreach (DataRow dr in dt.Rows)
            {
                //T model = (T)Activator.CreateInstance(typeof(T));  
                T model = new T();
                for (int i = 0; i < dr.Table.Columns.Count; i++)
                {
                    List<PropertyInfo> propertyInfos = model.GetType().GetProperties().ToList();

                    PropertyInfo item = propertyInfos.FirstOrDefault(p => string.Compare(p.Name, dr.Table.Columns[i].ColumnName, true) == 0);
                    if (item != null && dr[i] != DBNull.Value)
                        try
                        {
                            item.SetValue(model, dr[i], null);
                        }
                        catch
                        {
                        }
                }

                modelList.Add(model);
            }
            return modelList;
        }

        /// <summary>  
        /// 填充对象：用DataRow填充实体类
        /// </summary>  
        public static T FillModel(DataRow dr)
        {
            if (dr == null)
            {
                return default(T);
            }

            //T model = (T)Activator.CreateInstance(typeof(T));  
            T model = new T();

            for (int i = 0; i < dr.Table.Columns.Count; i++)
            {
                List<PropertyInfo> propertyInfos = model.GetType().GetProperties().ToList();

                PropertyInfo item = propertyInfos.FirstOrDefault(p => string.Compare(p.Name, dr.Table.Columns[i].ColumnName, true) == 0);
                if (item != null && dr[i] != DBNull.Value)
                    try
                    {
                        item.SetValue(model, dr[i], null);
                    }
                    catch
                    {
                    }
            }
            return model;
        }


        /// <summary>
        /// 实体类转换成DataSet
        /// </summary>
        /// <param name="modelList">实体类列表</param>
        /// <returns></returns>
        public static DataSet FillDataSet(List<T> modelList)
        {
            if (modelList == null || modelList.Count == 0)
            {
                return null;
            }
            else
            {
                DataSet ds = new DataSet();
                ds.Tables.Add(FillDataTable(modelList));
                return ds;
            }
        }

        /// <summary>
        /// 实体类转换成DataTable
        /// </summary>
        /// <param name="modelList">实体类列表</param>
        /// <returns></returns>
        public static DataTable FillDataTable(List<T> modelList)
        {
            if (modelList == null || modelList.Count == 0)
            {
                return null;
            }
            DataTable dt = CreateData(modelList[0]);

            foreach (T model in modelList)
            {
                DataRow dataRow = dt.NewRow();
                foreach (PropertyInfo propertyInfo in typeof(T).GetProperties())
                {
                    dataRow[propertyInfo.Name] = propertyInfo.GetValue(model, null);
                }
                dt.Rows.Add(dataRow);
            }
            return dt;
        }

        /// <summary>
        /// 根据实体类得到表结构
        /// </summary>
        /// <param name="model">实体类</param>
        /// <returns></returns>
        private static DataTable CreateData(T model)
        {
            DataTable dataTable = new DataTable(typeof(T).Name);
            foreach (PropertyInfo propertyInfo in typeof(T).GetProperties())
            {
                dataTable.Columns.Add(new DataColumn(propertyInfo.Name, propertyInfo.PropertyType));
            }
            return dataTable;
        }

        /// <summary>
        /// 将DataTable以转为List与Dictionary嵌套集合保存
        /// </summary>
        /// <param name="dt"></param>
        /// <returns></returns>
        public static List<Dictionary<string, string>> ToListDictionary(DataTable dt)
        {
            List<Dictionary<string, string>> list = null;
            if (dt != null && dt.Rows.Count > 0)
            {
                list = new List<Dictionary<string, string>>();
                Dictionary<string, string> dic = null;
                foreach (DataRow dr in dt.Rows)
                {
                    dic = new Dictionary<string, string>();
                    foreach (DataColumn dc in dt.Columns)
                    {
                        dic.Add(dc.ColumnName, dr[dc.ColumnName].ToString());
                    }
                    list.Add(dic);
                }
            }
            return list;
        }

        /// <summary>
        /// 请求的request的内容转换为model
        /// cza
        /// 2016-5-30 19:06:21
        /// </summary>
        /// <param name="context"></param>
        /// <returns></returns>
        public static T ConvertToModel(HttpContext context)
        {
            T t = new T();
            PropertyInfo[] propertys = t.GetType().GetProperties();
            foreach (PropertyInfo pi in propertys)
            {
                if (!pi.CanWrite)
                    continue;
                object value = context.Request[pi.Name];
                if (value != null && value != DBNull.Value)
                {
                    try
                    {
                        if (value.ToString() != "")
                            pi.SetValue(t, Convert.ChangeType(value, pi.PropertyType), null);//这一步很重要，用于类型转换
                        else
                            pi.SetValue(t, value, null);
                    }
                    catch
                    { }
                }
            }

            return t;
        }


    }

9.SQL Server数据库访问类

    /// <summary>
    /// SQL Server数据库访问类
    /// </summary>
    public abstract class SqlHelper
    {
        //读取配置文件里的数据库连接字符串
        public static readonly string connStr = ConfigurationManager.ConnectionStrings["Conn"].ConnectionString;

        //空构造
        public SqlHelper() { }

        //Hashtable to store cached parameters
        private static Hashtable parmCache = Hashtable.Synchronized(new Hashtable());

        /// <summary>
        /// 执行增删改【常用】
        /// </summary>
        public static int ExecuteNonQuery(string connectionString, CommandType commandType, string commandText, params SqlParameter[] paras)
        {
            SqlCommand cmd = new SqlCommand();
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                PrepareCommand(cmd, conn, null, commandType, commandText, paras);
                int val = cmd.ExecuteNonQuery();
                cmd.Parameters.Clear();          //清空参数
                return val;
            }
        }

        /// <summary>
        /// 执行增删改（对现有的数据库连接）【不常用】
        /// </summary>
        public static int ExecuteNonQuery(SqlConnection connection, CommandType commandType, string commandText, params SqlParameter[] paras)
        {
            SqlCommand cmd = new SqlCommand();
            PrepareCommand(cmd, connection, null, commandType, commandText, paras);
            int val = cmd.ExecuteNonQuery();
            cmd.Parameters.Clear();
            return val;
        }

        /// <summary>
        /// 执行多条sql语句（List泛型集合）【事务】（无参数）
        /// </summary>
        /// <param name="connectionString">数据库连接字符串</param>
        /// <param name="listSql">包含多条sql语句的泛型集合</param>
        /// <returns>受影响行数</returns>
        public static int ExecuteNonQuery(string connectionString, List<string> listSql)
        {
            SqlCommand cmd = new SqlCommand();
            SqlConnection conn = new SqlConnection(connectionString);
            conn.Open();
            SqlTransaction trans = conn.BeginTransaction();
            PrepareCommand(cmd, conn, trans, CommandType.Text, null, null);
            try
            {
                int count = 0;
                for (int n = 0; n < listSql.Count; n++)
                {
                    string strSql = listSql[n];
                    if (strSql.Trim().Length > 1)
                    {
                        cmd.CommandText = strSql;
                        count += cmd.ExecuteNonQuery();
                    }
                }
                trans.Commit();
                cmd.Parameters.Clear();
                return count;
            }
            catch
            {
                trans.Rollback();
                cmd.Parameters.Clear();
                return 0;
            }
            finally
            {
                conn.Close();
            }
        }

        /// <summary>
        /// 执行多条sql语句（Hashtable）【事务】（带一组参数，一个参数也得封装成组)
        /// </summary>
        /// <param name="connectionString">数据库连接字符串</param>
        /// <param name="sqlStringList">Hashtable表，键值对形式</param>
        public static void ExecuteNonQuery(string connectionString, Hashtable sqlStringList)
        {
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                conn.Open();
                using (SqlTransaction trans = conn.BeginTransaction())
                {
                    SqlCommand cmd = new SqlCommand();
                    try
                    {
                        foreach (DictionaryEntry item in sqlStringList)
                        {
                            string cmdText = item.Key.ToString();   //要执行的sql语句
                            SqlParameter[] cmdParas = (SqlParameter[])item.Value;  //sql语句对应的参数
                            PrepareCommand(cmd, conn, trans, CommandType.Text, cmdText, cmdParas);
                            int val = cmd.ExecuteNonQuery();
                            cmd.Parameters.Clear();
                        }
                        if (sqlStringList.Count > 0)
                            trans.Commit();
                    }
                    catch
                    {
                        trans.Rollback();
                        throw;
                    }
                }
            }

        }

        /// <summary>
        /// 返回DataReader对象
        /// </summary>
        public static SqlDataReader ExecuteReader(string connectionString, CommandType commandType, string cmdText, params SqlParameter[] paras)
        {
            SqlCommand cmd = new SqlCommand();
            SqlConnection conn = new SqlConnection(connectionString);
            try
            {
                PrepareCommand(cmd, conn, null, commandType, cmdText, paras);
                SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                cmd.Parameters.Clear();
                return reader;
            }
            catch
            {
                conn.Close();
                throw;
            }
        }

        /// <summary>
        /// 返回第一行第一列信息（可能是字符串 所以返回类型是object）【常用】
        /// </summary>
        public static object ExecuteScalar(string connectionString, CommandType commandType, string commandText, params SqlParameter[] paras)
        {
            SqlCommand cmd = new SqlCommand();
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                PrepareCommand(cmd, connection, null, commandType, commandText, paras);
                object val = cmd.ExecuteScalar();
                cmd.Parameters.Clear();
                return val;
            }
        }

        /// <summary>
        /// 返回第一行第一列信息（针对现有的数据库连接）【不常用】
        /// </summary>
        public static object ExecuteScalar(SqlConnection connection, CommandType commandType, string commandText, params SqlParameter[] paras)
        {
            SqlCommand cmd = new SqlCommand();

            PrepareCommand(cmd, connection, null, commandType, commandText, paras);
            object val = cmd.ExecuteScalar();
            cmd.Parameters.Clear();
            return val;
        }

        /// <summary>
        /// 返回DataTable
        /// </summary>
        public static DataTable GetDataTable(string connectionString, CommandType commandType, string commandText, params SqlParameter[] paras)
        {
            SqlCommand cmd = new SqlCommand();
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                PrepareCommand(cmd, conn, null, commandType, commandText, paras);
                using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                {
                    DataTable dt = new DataTable();
                    da.Fill(dt);
                    return dt;
                }
            }
        }

        /// <summary>
        /// 返回DataSet
        /// </summary>
        public static DataSet GetDataset(string connectionString, CommandType commandType, string commandText, params SqlParameter[] paras)
        {
            SqlCommand cmd = new SqlCommand();
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                PrepareCommand(cmd, conn, null, commandType, commandText, paras);
                using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                {
                    DataSet ds = new DataSet();
                    da.Fill(ds);
                    return ds;
                }
            }
        }

        /// <summary>
        /// add parameter array to the cache
        /// </summary>
        /// <param name="cacheKey">Key to the parameter cache</param>
        /// <param name="cmdParms">an array of SqlParamters to be cached</param>
        public static void CacheParameters(string cacheKey, params SqlParameter[] commandParameters)
        {
            parmCache[cacheKey] = commandParameters;
        }

        /// <summary>
        /// Retrieve cached parameters
        /// </summary>
        /// <param name="cacheKey">key used to lookup parameters</param>
        /// <returns>Cached SqlParamters array</returns>
        public static SqlParameter[] GetCachedParameters(string cacheKey)
        {
            SqlParameter[] cachedParms = (SqlParameter[])parmCache[cacheKey];

            if (cachedParms == null)
                return null;

            SqlParameter[] clonedParms = new SqlParameter[cachedParms.Length];

            for (int i = 0, j = cachedParms.Length; i < j; i++)
                clonedParms[i] = (SqlParameter)((ICloneable)cachedParms[i]).Clone();

            return clonedParms;
        }

        /// <summary>
        /// 准备一个待执行的SqlCommand
        /// </summary>
        private static void PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType commandType, string commandText, params SqlParameter[] paras)
        {
            try
            {
                if (conn.State != ConnectionState.Open)
                {
                    conn.Close();
                    conn.Open();
                }
                cmd.Connection = conn;
                if (commandText != null)
                    cmd.CommandText = commandText;
                cmd.CommandType = commandType;     //这里设置执行的是T-Sql语句还是存储过程

                if (trans != null)
                    cmd.Transaction = trans;

                if (paras != null && paras.Length > 0)
                {
                    //cmd.Parameters.AddRange(paras);
                    for (int i = 0; i < paras.Length; i++)
                    {
                        if (paras[i].Value == null || paras[i].Value.ToString() == "")
                            paras[i].Value = DBNull.Value;   //插入或修改时，如果有参数是空字符串，那么以NULL的形式插入数据库
                        cmd.Parameters.Add(paras[i]);
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        /// <summary>
        /// 通用分页存储过程，有条件查询，有排序字段，按照排序字段的降序排列
        /// </summary>
        /// <param name="PageSize">每页记录数</param>
        /// <param name="CurrentCount">当前记录数量（页码*每页记录数）</param>
        /// <param name="TableName">表名称</param>
        /// <param name="Where">查询条件，例："ID>1000 AND Name like '%LiLinFeng%'" 排序条件，直接在后面加，例：" ORDER BY ID DESC,NAME ASC"</param>
        /// <param name="TotalCount">记录总数</param>
        /// <returns></returns>
        public static DataSet GetList(string connectionString, string Order, int PageSize, int CurrentCount, string TableName, string Where, out int TotalCount)
        {
            SqlParameter[] parmList =
                {
                    new SqlParameter("@PageSize",PageSize),
                    new SqlParameter("@CurrentCount",CurrentCount),
                    new SqlParameter("@TableName",TableName),
                    new SqlParameter("@Where",Where),
                    new SqlParameter("@Order",Order),
                    new SqlParameter("@TotalCount",SqlDbType.Int,4)
                };
            parmList[5].Direction = ParameterDirection.Output;
            DataSet ds = GetDataset(connectionString, CommandType.StoredProcedure, "sp_MvcPager", parmList);
            TotalCount = Convert.ToInt32(parmList[5].Value);
            return ds;
        }
    }

10.日志文件记录

    public class WriteLog
    {
        /// <summary>
        /// 
        /// </summary>
        /// <param name="fileName">文件名</param>
        /// <param name="ex"></param>
        public static void WriteErorrLog(string fileName, Exception ex)
        {
            if (ex == null) return; //ex = null 返回  
            DateTime dt = DateTime.Now; // 设置日志时间  
            string time = dt.ToString("yyyy-MM-dd HH:mm:ss"); //年-月-日 时：分：秒  
            string logName = dt.ToString("yyyy-MM-dd"); //日志名称  
            string logPath = Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, Path.Combine("log", fileName)); //日志存放路径  
            string log = Path.Combine(logPath, string.Format("{0}.log", logName)); //路径 + 名称
            try
            {
                FileInfo info = new FileInfo(log);
                if (info.Directory != null && !info.Directory.Exists)
                {
                    info.Directory.Create();
                }
                using (StreamWriter write = new StreamWriter(log, true, Encoding.GetEncoding("utf-8")))
                {
                    write.WriteLine(time);
                    write.WriteLine(ex.Message);
                    write.WriteLine("异常信息：" + ex);
                    write.WriteLine("异常堆栈：" + ex.StackTrace);
                    write.WriteLine("异常简述：" + ex.Message);
                    write.WriteLine("\r\n----------------------------------\r\n");
                    write.Flush();
                    write.Close();
                    write.Dispose();
                }
            }
            catch { }
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="fileName">文件名</param>
        /// <param name="message"></param>
        public static void WriteMessage(string fileName, string message)
        {
            //ex = null 返回  
            DateTime dt = DateTime.Now; // 设置日志时间  
            string time = dt.ToString("yyyy-MM-dd HH:mm:ss"); //年-月-日 时：分：秒  
            string logName = dt.ToString("yyyy-MM-dd"); //日志名称  
            string logPath = Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, Path.Combine("log", fileName)); //日志存放路径  
            string log = Path.Combine(logPath, string.Format("{0}.log", logName)); //路径 + 名称
            try
            {
                FileInfo info = new FileInfo(log);
                if (info.Directory != null && !info.Directory.Exists)
                {
                    info.Directory.Create();
                }
                using (StreamWriter write = new StreamWriter(log, true, Encoding.GetEncoding("utf-8")))
                {
                    write.WriteLine(time);
                    write.WriteLine("信息：" + message);
                    write.WriteLine("\r\n----------------------------------\r\n");
                    write.Flush();
                    write.Close();
                    write.Dispose();
                }
            }
            catch { }
        }


        public static void WriteErorrLog(Exception ex, string message)
        {
            if (ex == null) return; //ex = null 返回  
            DateTime dt = DateTime.Now; // 设置日志时间  
            string time = dt.ToString("yyyy-MM-dd HH:mm:ss"); //年-月-日 时：分：秒  
            string logName = dt.ToString("yyyy-MM-dd"); //日志名称  
            string logPath = System.AppDomain.CurrentDomain.BaseDirectory; //日志存放路径  
            string log = Path.Combine(Path.Combine(logPath, "log"), string.Format("{0}.log", logName)); //路径 + 名称
            try
            {
                FileInfo info = new FileInfo(log);
                if (info.Directory != null && !info.Directory.Exists)
                {
                    info.Directory.Create();
                }
                using (StreamWriter write = new StreamWriter(log, true, Encoding.GetEncoding("utf-8")))
                {
                    write.WriteLine(time);
                    write.WriteLine(ex.Message);
                    write.WriteLine("异常信息：" + ex);
                    write.WriteLine("异常堆栈：" + ex.StackTrace);
                    write.WriteLine("异常简述：" + message);
                    write.WriteLine("\r\n----------------------------------\r\n");
                    write.Flush();
                    write.Close();
                    write.Dispose();
                }
            }
            catch { }
        }

        public static void WriteMessage(string message)
        {
            //ex = null 返回  
            DateTime dt = DateTime.Now; // 设置日志时间  
            string time = dt.ToString("yyyy-MM-dd HH:mm:ss"); //年-月-日 时：分：秒  
            string logName = dt.ToString("yyyy-MM-dd"); //日志名称  
            string logPath = System.AppDomain.CurrentDomain.BaseDirectory; //日志存放路径  
            string log = Path.Combine(Path.Combine(logPath, "log"), string.Format("{0}.log", logName)); //路径 + 名称
            try
            {
                FileInfo info = new FileInfo(log);
                if (info.Directory != null && !info.Directory.Exists)
                {
                    info.Directory.Create();
                }
                using (StreamWriter write = new StreamWriter(log, true, Encoding.GetEncoding("utf-8")))
                {
                    write.WriteLine(time);
                    write.WriteLine("信息：" + message);
                    write.WriteLine("\r\n----------------------------------\r\n");
                    write.Flush();
                    write.Close();
                    write.Dispose();
                }
            }
            catch { }
        }
    }

11.JSON帮助类

    /// <summary>
    /// JSON帮助类
    /// </summary>
    public class JsonHelper
    {
        #region 通用方法
        /// <summary>
        /// 格式化字符型、日期型、布尔型
        /// </summary>
        public static string StringFormat(string str, Type type)
        {
            if (type == typeof(string))
            {
                str = StringFilter(str);
                str = "\"" + str + "\"";
            }
            else if (type == typeof(DateTime) || type == typeof(DateTime?))
            {
                str = "\"" + str + "\"";
            }
            else if (type == typeof(bool))
            {
                str = str.ToLower();
            }
            else if (type == typeof(Guid))
            {
                str = "\"" + str + "\"";
            }
            else if (type != typeof(string) && string.IsNullOrEmpty(str))
            {
                str = "\"" + str + "\"";
            }
            return str;
        }

        /// <summary>
        /// 过滤字符串
        /// </summary>
        public static string StringFilter(string str)
        {
            StringBuilder sb = new StringBuilder();
            for (int i = 0; i < str.Length; i++)
            {
                char c = str.ToCharArray()[i];
                switch (c)
                {
                    case '\"':
                        sb.Append("\\\""); break;
                    case '\\':
                        sb.Append("\\\\"); break;
                    case '/':
                        sb.Append("\\/"); break;
                    case '\b':
                        sb.Append("\\b"); break;
                    case '\f':
                        sb.Append("\\f"); break;
                    case '\n':
                        sb.Append("\\n"); break;
                    case '\r':
                        sb.Append("\\r"); break;
                    case '\t':
                        sb.Append("\\t"); break;
                    default:
                        sb.Append(c); break;
                }
            }
            return sb.ToString();
        }
        #endregion

        #region 列转json
        /// <summary>
        /// 列转json
        /// </summary>
        /// <param name="dt">表</param>
        /// <param name="r">列</param>
        public static string ColumnToJson(DataTable dt, int r)
        {
            StringBuilder strSql = new StringBuilder();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                strSql.Append(dt.Rows[i][r]);
                strSql.Append(",");
            }
            return strSql.ToString().Trim(',');
        }
        #endregion

        #region 对象转json
        /// <summary>
        /// 对象转json
        /// </summary>
        public static string ToJson(object jsonObject)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("{");
            PropertyInfo[] propertyInfo = jsonObject.GetType().GetProperties();
            for (int i = 0; i < propertyInfo.Length; i++)
            {
                object objectValue = propertyInfo[i].GetGetMethod().Invoke(jsonObject, null);
                Type type = propertyInfo[i].PropertyType;
                string strValue = objectValue.ToString();
                strValue = StringFormat(strValue, type);
                sb.Append("\"" + propertyInfo[i].Name + "\":");
                sb.Append(strValue + ",");
            }
            sb.Remove(sb.Length - 1, 1);
            sb.Append("}");
            return sb.ToString();
        }
        #endregion

        #region list转json
        /// <summary>
        /// list转json
        /// </summary>
        public static string ListToJson<T>(IList<T> list)
        {
            object obj = list[0];
            return ListToJson<T>(list, obj.GetType().Name);
        }

        private static string ListToJson<T>(IList<T> list, string JsonName)
        {
            StringBuilder Json = new StringBuilder();
            if (string.IsNullOrEmpty(JsonName))
                JsonName = list[0].GetType().Name;
            Json.Append("{\"" + JsonName + "\":[");
            if (list.Count > 0)
            {
                for (int i = 0; i < list.Count; i++)
                {
                    T obj = Activator.CreateInstance<T>();
                    PropertyInfo[] pi = obj.GetType().GetProperties();
                    Json.Append("{");
                    for (int j = 0; j < pi.Length; j++)
                    {
                        Type type = pi[j].GetValue(list[i], null).GetType();
                        Json.Append("\"" + pi[j].Name.ToString() + "\":" + StringFormat(pi[j].GetValue(list[i], null).ToString(), type));
                        if (j < pi.Length - 1)
                        {
                            Json.Append(",");
                        }
                    }
                    Json.Append("}");
                    if (i < list.Count - 1)
                    {
                        Json.Append(",");
                    }
                }
            }
            Json.Append("]}");
            return Json.ToString();
        }
        #endregion

        #region 对象集合转换为json
        /// <summary>
        /// 对象集合转换为json
        /// </summary>
        /// <param name="array">对象集合</param>
        /// <returns>json字符串</returns>
        public static string ToJson(IEnumerable array)
        {
            string jsonString = "[";
            foreach (object item in array)
            {
                jsonString += ToJson(item) + ",";
            }
            jsonString = jsonString.Substring(0, jsonString.Length - 1);
            return jsonString + "]";
        }
        #endregion

        #region 普通集合转换Json
        /// <summary>    
        /// 普通集合转换Json   
        /// </summary>   
        /// <param name="array">集合对象</param> 
        /// <returns>Json字符串</returns>  
        public static string ToArrayString(IEnumerable array)
        {
            string jsonString = "[";
            foreach (object item in array)
            {
                jsonString = ToJson(item.ToString()) + ",";
            }
            jsonString.Remove(jsonString.Length - 1, jsonString.Length);
            return jsonString + "]";
        }
        #endregion

        #region  DataSet转换为Json
        /// <summary>    
        /// DataSet转换为Json   
        /// </summary>    
        /// <param name="dataSet">DataSet对象</param>   
        /// <returns>Json字符串</returns>    
        public static string ToJson(DataSet dataSet)
        {
            string jsonString = "{";
            foreach (DataTable table in dataSet.Tables)
            {
                jsonString += "\"" + table.TableName + "\":" + ToJson(table) + ",";
            }
            jsonString = jsonString.TrimEnd(',');
            return jsonString + "}";
        }
        #endregion

        #region Datatable转换为Json
        /// <summary>     
        /// Datatable转换为Json     
        /// </summary>    
        public static string ToJson(DataTable dt)
        {
            if (dt.Rows.Count > 0)
            {
                StringBuilder jsonString = new StringBuilder();
                jsonString.Append("[");
                DataRowCollection drc = dt.Rows;
                for (int i = 0; i < drc.Count; i++)
                {
                    jsonString.Append("{");
                    for (int j = 0; j < dt.Columns.Count; j++)
                    {
                        string strKey = dt.Columns[j].ColumnName;
                        string strValue = drc[i][j].ToString();

                        Type type = dt.Columns[j].DataType;
                        jsonString.Append("\"" + strKey + "\":");
                        strValue = StringFormat(strValue, type);
                        if (j < dt.Columns.Count - 1)
                            jsonString.Append(strValue + ",");
                        else
                            jsonString.Append(strValue);
                    }
                    jsonString.Append("},");
                }
                jsonString.Remove(jsonString.Length - 1, 1);
                jsonString.Append("]");
                return jsonString.ToString();
            }
            else
                return "[]";
        }

        /// <summary>    
        /// DataTable转换为Json
        /// </summary>    
        public static string ToJson(DataTable dt, string jsonName)
        {
            StringBuilder Json = new StringBuilder();
            if (string.IsNullOrEmpty(jsonName))
                jsonName = dt.TableName;
            Json.Append("{\"" + jsonName + "\":[");
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    Json.Append("{");
                    for (int j = 0; j < dt.Columns.Count; j++)
                    {
                        Type type = dt.Rows[i][j].GetType();
                        Json.Append("\"" + dt.Columns[j].ColumnName.ToString() + "\":" + StringFormat(dt.Rows[i][j].ToString(), type));
                        if (j < dt.Columns.Count - 1)
                            Json.Append(",");
                    }
                    Json.Append("}");
                    if (i < dt.Rows.Count - 1)
                        Json.Append(",");
                }
            }
            Json.Append("]}");
            return Json.ToString();
        }
        #endregion

        #region DataReader转换为Json
        /// <summary>     
        /// DataReader转换为Json     
        /// </summary>     
        /// <param name="dataReader">DataReader对象</param>     
        /// <returns>Json字符串</returns>  
        public static string ToJson(DbDataReader dataReader)
        {
            StringBuilder jsonString = new StringBuilder();
            jsonString.Append("[");
            while (dataReader.Read())
            {
                jsonString.Append("{");
                for (int i = 0; i < dataReader.FieldCount; i++)
                {
                    Type type = dataReader.GetFieldType(i);
                    string strKey = dataReader.GetName(i);
                    string strValue = dataReader[i].ToString();
                    jsonString.Append("\"" + strKey + "\":");
                    strValue = StringFormat(strValue, type);
                    if (i < dataReader.FieldCount - 1)
                        jsonString.Append(strValue + ",");
                    else
                        jsonString.Append(strValue);
                }
                jsonString.Append("},");
            }
            dataReader.Close();
            jsonString.Remove(jsonString.Length - 1, 1);
            jsonString.Append("]");
            return jsonString.ToString();
        }
        #endregion


        #region 返回错误
        public static string error()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("error", typeof(int));
            DataRow dr = dt.NewRow();
            dr["error"] = 1;
            dt.Rows.Add(dr);
            return ToJson(dt);
        }
        #endregion

    }

11.转换帮助类

   public class ConvertHelper
    {
        public static int DateTimeToUnixInt(DateTime time)
        {
            DateTime time2 = TimeZone.CurrentTimeZone.ToLocalTime(new DateTime(0x7b2, 1, 1));
            TimeSpan span = (TimeSpan)(time - time2);
            return (int)span.TotalSeconds;
        }

        public static decimal MoneyRound(decimal value, int decimals)
        {
            if (value < 0M)
            {
                return Math.Round((decimal)(value + (5M / ((decimal)Math.Pow(10.0, (double)(decimals + 1))))), decimals, MidpointRounding.AwayFromZero);
            }
            return Math.Round(value, decimals, MidpointRounding.AwayFromZero);
        }

        public static double MoneyRound(double value, int decimals)
        {
            if (value < 0.0)
            {
                return Math.Round((double)(value + (5.0 / Math.Pow(10.0, (double)(decimals + 1)))), decimals, MidpointRounding.AwayFromZero);
            }
            return Math.Round(value, decimals, MidpointRounding.AwayFromZero);
        }

        public static decimal MoneyToDecimal(string str)
        {
            try
            {
                str = str.Replace(",", "");
                return decimal.Parse(str);
            }
            catch
            {
                return 0M;
            }
        }

        public static decimal Round(decimal d, int i)
        {
            if (d >= 0M)
            {
                d += 5M * ((decimal)Math.Pow(10.0, (double)-(i + 1)));
            }
            else
            {
                d += -5M * ((decimal)Math.Pow(10.0, (double)-(i + 1)));
            }
            string str = d.ToString();
            string[] strArray = str.Split(new char[] { '.' });
            int index = str.IndexOf('.');
            string str2 = strArray[0];
            string str3 = strArray[1];
            if (str3.Length > i)
            {
                str3 = str.Substring(index + 1, i);
            }
            d = decimal.Parse(str2 + "." + str3);
            return d;
        }

        public static double Round(double d, int i)
        {
            if (d >= 0.0)
            {
                d += 5.0 * Math.Pow(10.0, (double)-(i + 1));
            }
            else
            {
                d += -5.0 * Math.Pow(10.0, (double)-(i + 1));
            }
            string str = d.ToString();
            string[] strArray = str.Split(new char[] { '.' });
            int index = str.IndexOf('.');
            string str2 = strArray[0];
            string str3 = strArray[1];
            if (str3.Length > i)
            {
                str3 = str.Substring(index + 1, i);
            }
            d = double.Parse(str2 + "." + str3);
            return d;
        }

        public static bool ToBool(object o)
        {
            return ToBool(o, false);
        }

        public static bool ToBool(object o, bool DefaultValue)
        {
            bool flag;
            if (bool.TryParse(ToString(o, true), out flag))
            {
                return flag;
            }
            return DefaultValue;
        }

        public static DateTime ToDateTime(object o)
        {
            return ToDateTime(o, DateTime.Now);
        }

        public static DateTime ToDateTime(object o, DateTime DefaultValue)
        {
            DateTime time;
            if (DateTime.TryParse(ToString(o, true), out time))
            {
                return time;
            }
            return DefaultValue;
        }

        public static decimal ToDecimal(object o)
        {
            return ToDecimal(o, 0M);
        }

        public static decimal ToDecimal(object o, decimal DefaultValue)
        {
            decimal num;
            if (decimal.TryParse(ToString(o, true), out num))
            {
                return num;
            }
            return DefaultValue;
        }

        public static double ToDouble(object o)
        {
            return ToDouble(o, 0.0);
        }

        public static double ToDouble(object o, double DefaultValue)
        {
            double num;
            if (double.TryParse(ToString(o, true), out num))
            {
                return num;
            }
            return DefaultValue;
        }

        public static float ToFloat(object o)
        {
            return ToFloat(o, 0f);
        }

        public static float ToFloat(object o, float DefaultValue)
        {
            float num;
            if (float.TryParse(ToString(o, true), out num))
            {
                return num;
            }
            return DefaultValue;
        }

        public static int ToInt(object o)
        {
            return ToInt(o, 0);
        }

        public static int ToInt(object o, int DefaultValue)
        {
            int num;
            if (int.TryParse(ToString(o, true), out num))
            {
                return num;
            }
            return DefaultValue;
        }

        public static long ToLong(object o)
        {
            return ToLong(o, 0L);
        }

        public static long ToLong(object o, long DefaultValue)
        {
            long num;
            if (long.TryParse(ToString(o, true), out num))
            {
                return num;
            }
            return DefaultValue;
        }

        public static string ToMoney(object o)
        {
            return ToDecimal(o).ToString("###,###,###,###,###,##0.##");
        }

        public static string ToMoney(string str)
        {
            try
            {
                return decimal.Parse(str).ToString("###,###,###,###,###,##0.##");
            }
            catch
            {
                return "0";
            }
        }

        public static string ToString(object o)
        {
            return ToString(o, "", false);
        }

        public static string ToString(object o, bool bTrim)
        {
            return ToString(o, "", bTrim);
        }

        public static string ToString(object o, string DefaultValue)
        {
            return ToString(o, DefaultValue, false);
        }

        public static string ToString(object o, string DefaultValue, bool bTrim)
        {
            if (object.Equals(o, null) || Convert.IsDBNull(o))
            {
                return DefaultValue;
            }
            if (bTrim)
            {
                return o.ToString().Trim();
            }
            return o.ToString();
        }

        public static DateTime UnixIntToDateTime(string timeStamp)
        {
            DateTime time = TimeZone.CurrentTimeZone.ToLocalTime(new DateTime(0x7b2, 1, 1));
            long ticks = long.Parse(timeStamp + "0000000");
            TimeSpan span = new TimeSpan(ticks);
            return time.Add(span);
        }
    }