C# 常用公共方法

 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(); 

 /// 
 /// 判断网址是否可以访问 /// 
 ///  ///  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; } 

 /// 
 /// 批量导出 /// 
 ///  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 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"); } 

 /// 
 /// 批量导入 /// 
 ///  [HttpPost] public ActionResult ImportStu() { HttpPostedFileBase file = Request.Files["file"]; string FileName; string savePath; if (file == null || file.ContentLength <= 0) { return Content(""); } 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(""); } 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(""); } //列顺序 标题 内容 DataTable table = myDataSet.Tables["ExcelInfo"].DefaultView.ToTable(); //事物 异常回滚 using (TransactionScope transaction = new TransactionScope()) { for (int i = 0; i 

 /// 
 /// 获取客户端的IP地址 /// 
 /// 客户端IP地址 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; } 

 /// 
 /// 对称加密类 /// 
 public class AES { /// 
 /// 解密 /// 
 ///  ///  ///  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; } } /// 
 /// 解密 /// 
 ///  ///  ///  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; } /// 
 /// 加密 /// 
 ///  ///  ///  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; } } /// 
 /// 加密 /// 
 ///  ///  ///  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)); } } 

 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); } } } /// 
 /// 设置域的cookie /// 
 ///  ///  ///  public static void SetDomainCookie(string key, string value, string Domain) { SetCookie(key, null, value, null, Domain); } } 

 /// 
 /// #region DataTable转换成实体类 /// 
 ///  public class ModelUtil where T : new() { /// 
 /// 填充对象列表：用DataSet的第一个表填充实体类 /// 
 /// DataSet ///  public static List FillModel(DataSet ds) { if (ds == null || ds.Tables[0] == null || ds.Tables[0].Rows.Count == 0) { return null; } else { return FillModel(ds.Tables[0]); } } /// 
 /// 填充对象列表：用DataSet的第index个表填充实体类 /// 
 public static List 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]); } } /// 
 /// 填充对象列表：用DataTable填充实体类 /// 
 public static List FillModel(DataTable dt) { if (dt == null || dt.Rows.Count == 0) { return null; } List modelList = new List(); foreach (DataRow dr in dt.Rows) { //T model = (T)Activator.CreateInstance(typeof(T)); T model = new T(); for (int i = 0; i  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; } /// 
 /// 填充对象：用DataRow填充实体类 /// 
 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  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; } /// 
 /// 实体类转换成DataSet /// 
 /// 实体类列表 ///  public static DataSet FillDataSet(List modelList) { if (modelList == null || modelList.Count == 0) { return null; } else { DataSet ds = new DataSet(); ds.Tables.Add(FillDataTable(modelList)); return ds; } } /// 
 /// 实体类转换成DataTable /// 
 /// 实体类列表 ///  public static DataTable FillDataTable(List 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; } /// 
 /// 根据实体类得到表结构 /// 
 /// 实体类 ///  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; } /// 
 /// 将DataTable以转为List与Dictionary嵌套集合保存 /// 
 ///  ///  public static List> ToListDictionary(DataTable dt) { List> list = null; if (dt != null && dt.Rows.Count > 0) { list = new List>(); Dictionary dic = null; foreach (DataRow dr in dt.Rows) { dic = new Dictionary(); foreach (DataColumn dc in dt.Columns) { dic.Add(dc.ColumnName, dr[dc.ColumnName].ToString()); } list.Add(dic); } } return list; } /// 
 /// 请求的request的内容转换为model /// cza /// 2016-5-30 19:06:21 /// 
 ///  ///  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; } } 

 /// 
 /// SQL Server数据库访问类 /// 
 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()); /// 
 /// 执行增删改【常用】 /// 
 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; } } /// 
 /// 执行增删改（对现有的数据库连接）【不常用】 /// 
 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; } /// 
 /// 执行多条sql语句（List泛型集合）【事务】（无参数） /// 
 /// 数据库连接字符串 /// 包含多条sql语句的泛型集合 /// 受影响行数 public static int ExecuteNonQuery(string connectionString, List 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  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(); } } /// 
 /// 执行多条sql语句（Hashtable）【事务】（带一组参数，一个参数也得封装成组) /// 
 /// 数据库连接字符串 /// Hashtable表，键值对形式 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; } } } } /// 
 /// 返回DataReader对象 /// 
 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; } } /// 
 /// 返回第一行第一列信息（可能是字符串 所以返回类型是object）【常用】 /// 
 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; } } /// 
 /// 返回第一行第一列信息（针对现有的数据库连接）【不常用】 /// 
 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; } /// 
 /// 返回DataTable /// 
 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; } } } /// 
 /// 返回DataSet /// 
 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; } } } /// 
 /// add parameter array to the cache /// 
 /// Key to the parameter cache /// an array of SqlParamters to be cached public static void CacheParameters(string cacheKey, params SqlParameter[] commandParameters) { parmCache[cacheKey] = commandParameters; } /// 
 /// Retrieve cached parameters /// 
 /// key used to lookup parameters /// Cached SqlParamters array 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  /// 准备一个待执行的SqlCommand ///  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  /// 通用分页存储过程，有条件查询，有排序字段，按照排序字段的降序排列 ///  /// 每页记录数 /// 当前记录数量（页码*每页记录数） /// 表名称 /// 查询条件，例："ID>1000 AND Name like '%LiLinFeng%'" 排序条件，直接在后面加，例：" ORDER BY ID DESC,NAME ASC" /// 记录总数 ///  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; } } 

 public class WriteLog { /// 
 /// /// 
 /// 文件名 ///  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 { } } /// 
 /// /// 
 /// 文件名 ///  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 { } } } 

 /// 
 /// JSON帮助类 /// 
 public class JsonHelper { #region 通用方法 /// 
 /// 格式化字符型、日期型、布尔型 /// 
 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; } /// 
 /// 过滤字符串 /// 
 public static string StringFilter(string str) { StringBuilder sb = new StringBuilder(); for (int i = 0; i  /// 列转json ///  /// 表 /// 列 public static string ColumnToJson(DataTable dt, int r) { StringBuilder strSql = new StringBuilder(); for (int i = 0; i  /// 对象转json ///  public static string ToJson(object jsonObject) { StringBuilder sb = new StringBuilder(); sb.Append("{"); PropertyInfo[] propertyInfo = jsonObject.GetType().GetProperties(); for (int i = 0; i  /// list转json ///  public static string ListToJson(IList list) { object obj = list[0]; return ListToJson(list, obj.GetType().Name); } private static string ListToJson(IList 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 (); PropertyInfo[] pi = obj.GetType().GetProperties(); Json.Append("{"); for (int j = 0; j  /// 对象集合转换为json ///  /// 对象集合 /// json字符串 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 /// 
 /// 普通集合转换Json /// 
 /// 集合对象 /// Json字符串 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 /// 
 /// DataSet转换为Json /// 
 /// DataSet对象 /// Json字符串 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 /// 
 /// Datatable转换为Json /// 
 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  /// DataTable转换为Json ///  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  /// DataReader转换为Json ///  /// DataReader对象 /// Json字符串 public static string ToJson(DbDataReader dataReader) { StringBuilder jsonString = new StringBuilder(); jsonString.Append("["); while (dataReader.Read()) { jsonString.Append("{"); for (int i = 0; i = 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); } }