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(); //事物 異?；貪L 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("http:///""); break; case '//': sb.Append("http:////"); break; case '/': sb.Append("http:///"); break; case '/b': sb.Append("http://b"); break; case '/f': sb.Append("http://f"); break; case '/n': sb.Append("http://n"); break; case '/r': sb.Append("http://r"); break; case '/t': sb.Append("http://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); } } 以上就是本文的全部內容，希望對大家的學習有所幫助，也希望大家多多支持武林網。
新聞熱點
疑難解答
