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 }
View Code
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 }
随机产生10位数
转载于:https://www.cnblogs.com/ZkbFighting/p/7595580.html
相关资源：SqlHelper 完整 含源码及使用实例
