1 public class SqlHlper 2 { 3 public static readonly string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString; 4 //执行增删改 5 public static object ExecuteNonQuery(string sql, params SqlParameter[] pms)//SqlParameter需要调用Data.SqlClient 6 { 7 using (SqlConnection con = new SqlConnection(constr)) 8 { 9 using (SqlCommand cmd = new SqlCommand(sql, con)) 10 { 11 if (pms != null) 12 { 13 cmd.Parameters.AddRange(pms); 14 } 15 con.Open(); 16 return cmd.ExecuteNonQuery(); 17 18 } 19 } 20 } 21 //获取单个数据 22 public static object ExecteScalar(string sql, params SqlParameter[] pms) 23 { 24 object obj = null; 25 using (SqlConnection conn = new SqlConnection(constr)) 26 { 27 SqlCommand cmd = new SqlCommand(sql, conn); 28 conn.Open(); 29 if (pms != null) 30 { 31 cmd.Parameters.AddRange(pms); 32 } 33 obj = cmd.ExecuteScalar(); 34 } 35 return obj; 36 } 37 //获取多个数据 38 public static SqlDataReader GetDataReader(string sql, params SqlParameter[] sps) 39 { 40 SqlConnection conn = new SqlConnection(constr); 41 using (SqlCommand cmd = new SqlCommand(sql, conn)) 42 { 43 if (sps != null) 44 { 45 cmd.Parameters.AddRange(sps); 46 } 47 conn.Open(); 48 return cmd.ExecuteReader(CommandBehavior.CloseConnection); 49 } 50 } 51 //查询多条数据 52 public static DataTable GetDataTable(string sql, params SqlParameter[] sps) 53 { 54 DataTable dt = new DataTable(); 55 using (SqlDataAdapter da = new SqlDataAdapter(sql, constr)) 56 { 57 if (sps != null) 58 { 59 da.SelectCommand.Parameters.AddRange(sps); 60 } 61 da.Fill(dt); 62 } 63 return dt; 64 } 65 }
1 /// <summary> 2 /// 把对象序列化 JSON 字符串 3 /// </summary> 4 /// <typeparam name="T">对象类型</typeparam> 5 /// <param name="obj">对象实体</param> 6 /// <returns>JSON字符串</returns> 7 public static string GetJson<T>(T obj) 8 { 9 DataContractJsonSerializer json = new DataContractJsonSerializer(typeof(T)); 10 using (MemoryStream ms = new MemoryStream()) 11 { 12 json.WriteObject(ms, obj); 13 string szJson = Encoding.UTF8.GetString(ms.ToArray()); 14 return szJson; 15 } 16 } 17 /// <summary> 18 /// 256位AES加密 19 /// </summary> 20 /// <param name="toEncrypt"></param> 21 /// <returns></returns> 22 public static string Encrypt(string toEncrypt, string skey, string IV) 23 { 24 //256-AES key 25 //byte[] keyArray = UTF8Encoding.UTF8.GetBytes("12345678123456781234567812345678"); 26 byte[] keyArray = UTF8Encoding.UTF8.GetBytes(skey); 27 byte[] toEncryptArray = UTF8Encoding.UTF8.GetBytes(toEncrypt); 28 byte[] ivArray = UTF8Encoding.UTF8.GetBytes(IV);//1234567812345678 29 30 RijndaelManaged rDel = new RijndaelManaged(); 31 rDel.Key = keyArray; 32 rDel.Mode = CipherMode.CBC; 33 rDel.Padding = PaddingMode.PKCS7; 34 rDel.IV = ivArray; 35 36 ICryptoTransform cTransform = rDel.CreateEncryptor(); 37 byte[] resultArray = cTransform.TransformFinalBlock(toEncryptArray, 0, toEncryptArray.Length); 38 39 return Convert.ToBase64String(resultArray, 0, resultArray.Length); 40 } 41 ///保留小数 42 public static double Change(double data, int num) 43 { 44 string str1 = ""; 45 if (num == 2) 46 { 47 str1 = String.Format("{0:F2}", data);//默认为保留两位 48 } 49 else if (num == 8) 50 { 51 str1 = String.Format("{0:F8}", data);//默认为保留8位 52 53 } 54 return Convert.ToDouble(str1); 55 }
1 /// <summary> 2 /// 随机产生10位数 3 /// </summary> 4 /// <returns></returns> 5 public static string GenerateRandomCode() 6 { 7 string chars = "0123456789abcdefghijklmnopqrstuvwxyz"; 8 Random randrom = new Random((int)DateTime.Now.Ticks); 9 string str = ""; 10 for (int i = 0; i < 10; i++) 11 { 12 str += chars[randrom.Next(chars.Length)]; 13 } 14 return str; 15 }