public void Execute(IJobExecutionContext context)
{
logger.Info("Start job Hangyezhishu");
string sqlstring = @"select * from hangyezhishu where record_date ='" + DateTime.Today.ToString("yyyy-MM-dd") + "' and business_type='行业资金'";
DataSet ds = Dbhelper.ExecuteDataset(Dbhelper.Conn, CommandType.Text, sqlstring, null);
DataTable data = ds.Tables[0];
if (data.Rows.Count == 0)
{
var hangye1 = "http://q.10jqka.com.cn/thshy/index/field/199112/order/desc/page/1/ajax/1/";
var hangye2 = "http://q.10jqka.com.cn/thshy/index/field/199112/order/desc/page/2/ajax/1/";
SaveData(hangye1, "行业资金");
SaveData(hangye2, "行业资金");
}
//string sqlstring2 = @"select * from hangyezhishu where record_date ='" + DateTime.Today.ToString("yyyy-MM-dd") + "' and business_type='概念资金'";
//DataSet ds2 = Dbhelper.ExecuteDataset(Dbhelper.Conn, CommandType.Text, sqlstring2, null);
//DataTable data2 = ds2.Tables[0];
//if (data2.Rows.Count == 0)
//{
// var ganlian1 = "http://data.10jqka.com.cn/funds/gnzjl/field/tradezdf/order/desc/page/1/ajax/1/";
// var ganlian2 = "http://data.10jqka.com.cn/funds/gnzjl/field/tradezdf/order/desc/page/2/ajax/1/";
// var ganlian3 = "http://data.10jqka.com.cn/funds/gnzjl/field/tradezdf/order/desc/page/3/ajax/1/";
// SaveData(ganlian1, "概念资金");
// SaveData(ganlian2, "概念资金");
// SaveData(ganlian3, "概念资金");
//}
logger.Info("End job Hangyezhishu");
}
public App(string dbpath)
{
InitializeComponent();
Dbhelper = new Dbhelper(dbpath);
MainPage = new NavigationPage(new MainPage());
}
private void timer1_Tick(object sender, EventArgs e)
{
this.labload.Width += 3;
if (labload.Width >= label1.Width)
{
this.timer1.Enabled = false;
Form_log f = new Form_log(this);
f.ShowInTaskbar = false;
f.Show();
this.Visible = false;
}
if (labload.Width > label1.Width / 2 && labload.Width < label1.Width / 3 * 2)
{
OleDbConnection conn = null;
try
{
conn = Dbhelper.GetOleDbConnection();
conn.Open();
}
catch
{
this.timer1.Enabled = false;
MessageBox.Show("数据加载失败....");
this.Close();
}
finally
{
conn.Close();
}
}
}
public static int ChangeCardStatus(string CardNum, SentCardInfo.CardStatus status)
{
string sql = string.Format("update SentCardInfo set CardStatus='{0}' where CardNumber='{1}' ", status.ToString(), CardNum);
int val = Dbhelper.ExecuteNonQuery(sql);
return(val);
}
public static int EditObj(string cmd, ObjInfo obj)//编辑价格
{
if (cmd == "DEL")
{
string sql = string.Format("delete * from PriceInfo where 序号={0}", obj.Index);
int val = Dbhelper.ExecuteNonQuery(sql);
return(val);
}
else if (cmd == "ADD")
{
string sql = string.Format("insert into PriceInfo (物品名称,参数1,参数2,参数3,价格1,价格2,价格3,备注) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", obj.Name, obj.Parameter1, obj.Parameter2,
obj.Parameter3, obj.BasePrice1, obj.BasePrice2, obj.BasePrice3, obj.Comments);
int val = Dbhelper.ExecuteNonQuery(sql);
return(val);
}
else if (cmd == "CHANGE")//传进来的是带原ID的修改后obj
{
string sql = string.Format("update PriceInfo set 物品名称='{1}' , 参数1='{2}' , 参数2='{3}' , 参数3='{4}' , 价格1='{5}' , 价格2='{6}' , 价格3='{7}' where 序号={0}"
, obj.Index, obj.Name, obj.Parameter1, obj.Parameter2,
obj.Parameter3, obj.BasePrice1, obj.BasePrice2, obj.BasePrice3);
int val = Dbhelper.ExecuteNonQuery(sql);
return(val);
}
ControCenter.ObjInfoData.Clear();
ControCenter.ObjInfoData = GetALLObjInfo();//刷新控制中心的价格数据缓存。
return(0);
}
public static SentCardInfo GetCardInfoAct(string CardNum) //查找已发卡表中是否有在使用中的卡，有返回卡的信息，没有返回null
{
string sql = string.Format("SELECT * from SentCardInfo where CardNumber = '{0}' and CardStatus = '{1}'", CardNum, SentCardInfo.CardStatus.活动);
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
SentCardInfo cardinfo = new SentCardInfo();
if (dr.Read())
{
cardinfo.CarNumber = dr[1].ToString();
cardinfo.SentTime = DateTime.Parse(dr[2].ToString());
try//没有关联会员的卡
{
cardinfo.ConnectVipId = uint.Parse(dr[3].ToString());
}
catch
{
}
cardinfo.Status = dr[4].ToString();
cardinfo.Balance = uint.Parse(dr[5].ToString());
return(cardinfo);
}
else
{
return(null);
}
}
public static bool Consume(string CardNum, uint ConsBalance)
{
string sql = string.Format("select * from SentCardInfo where CardNumber = '{0}' and CardStatus = '{1}' ", CardNum, "活动");
int val = Dbhelper.ExecuteNonQuery(sql);
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
if (dr.Read())
{
if (int.Parse(dr[5].ToString()) - ConsBalance >= 0)
{
string UpdataBalance = string.Format("update SentCardInfo set Balance='{0}' where CardNumber='{1}' ", uint.Parse(dr[5].ToString()) - ConsBalance, CardNum);
val = Dbhelper.ExecuteNonQuery(UpdataBalance);
if (val > 0 && val < 2)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
else
{
return(false);
}
}
public static List <ObjInfo> GetALLObjInfo()//获取所有物品信息
{
string sql = "select * from PriceInfo";
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
List <ObjInfo> list = new List <ObjInfo>();
while (dr.Read())
{
ObjInfo Obj = new ObjInfo();
Obj.Index = int.Parse(dr[0].ToString());
Obj.Name = dr[1].ToString();
Obj.Parameter1 = dr[2].ToString();
Obj.Parameter2 = dr[3].ToString();
Obj.Parameter3 = dr[4].ToString();
Obj.BasePrice1 = dr[5].ToString();
Obj.BasePrice2 = dr[6].ToString();
Obj.BasePrice3 = dr[7].ToString();
Obj.Comments = dr[8].ToString();
//使用控件显示所有数据
list.Add(Obj);
}
dr.Close();
return(list);
}
public void SaveData(string URLAddress)
{
WebClient client = new WebClient();
try
{
string html = client.DownloadString(URLAddress);
int ind1 = html.IndexOf("(\"");
html = html.Substring(ind1 + 2);
html = html.Substring(0, html.Length - 3);
string[] arr1 = html.Split(new char[] { ',' });
Parallel.For(0, arr1.Length, i =>
{
string[] valarr = arr1[i].Split(new char[] { '|' });
string code = valarr[6].Substring(2, 6);
string sqlstring = string.Format(@"Insert into shichangzijinliu(code,name,indexs,index_change,net_inflow,record_date,record_time) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')",
code, valarr[3], valarr[4], valarr[5], valarr[1], DateTime.Today.ToString("yyyy-MM-dd"), DateTime.Now.ToString("HH:mm:ss"));
try
{
Dbhelper.ExecuteNonQuery(Dbhelper.Conn, CommandType.Text, sqlstring);
}
catch (Exception ex)
{
logger.Info(sqlstring);
throw new Exception(ex.Message);
}
});
}
catch (Exception ex)
{
logger.Info("Shichangzijinliu," + URLAddress);
logger.Info(ex.Message);
}
}
public void Execute(IJobExecutionContext context)
{
logger.Info("Start job Xuanguzuhe");
try
{
string sqlstring = string.Format(@"SELECT stock_code,stock_name,count(1) FROM tonghuashunxuangu2
WHERE record_date = '{0}' GROUP BY stock_code,stock_name ORDER BY count(1) DESC", DateTime.Today.ToString("yyyy-MM-dd"));
DataSet ds = Dbhelper.ExecuteDataset(Dbhelper.Conn, CommandType.Text, sqlstring, null);
DataTable data = ds.Tables[0];
List <string> zuheList = new List <string>();
string sqlstring3 = string.Format(@"SELECT * from xuanguzuhe");
DataSet ds3 = Dbhelper.ExecuteDataset(Dbhelper.Conn, CommandType.Text, sqlstring3, null);
DataTable data3 = ds3.Tables[0];
for (int i = 0; i < data3.Rows.Count; i++)
{
zuheList.Add(data3.Rows[i]["ids"].ToString());
}
sqlstring = string.Format(@"SELECT stock_code,stock_name,typeid FROM tonghuashunxuangu2
WHERE record_date = '{0}' order by typeid", DateTime.Today.ToString("yyyy-MM-dd"));
DataSet ds2 = Dbhelper.ExecuteDataset(Dbhelper.Conn, CommandType.Text, sqlstring, null);
DataTable data2 = ds2.Tables[0];
Parallel.For(0, data.Rows.Count, (i, loopState) =>
{
var code = data.Rows[i]["stock_code"].ToString();
DataRow[] drs = data2.Select("stock_code='" + code + "'");
List <int> typeidList = new List <int>();
for (int j = 0; j < drs.Length; j++)
{
int typeid = int.Parse(drs[j]["typeid"].ToString());
if (!typeidList.Contains(typeid))
{
typeidList.Add(typeid);
}
}
string zuheids = string.Join(",", typeidList.ToArray());
if (!zuheList.Contains(zuheids))
{
zuheList.Add(zuheids);
string sqlstring2 = string.Format(@"Insert into xuanguzuhe(name,ids,number)values('选股组合','{0}',{1})", zuheids, typeidList.Count);
Dbhelper.ExecuteNonQuery(Dbhelper.Conn, CommandType.Text, sqlstring2);
}
string sqlstring4 = string.Format(@"Insert into xuanguzuhegu(zuheids,stock_code,stock_name,record_date,record_time)values('{0}','{1}','{2}','{3}','{4}')",
zuheids, drs[0]["stock_code"].ToString(), drs[0]["stock_name"].ToString(),
DateTime.Today.ToString("yyyy-MM-dd"), DateTime.Now.ToString("HH:mm:ss"));
Dbhelper.ExecuteNonQuery(Dbhelper.Conn, CommandType.Text, sqlstring4);
});
}
catch (Exception ex)
{
logger.Info("发生错误：" + ex.Message);
}
logger.Info("End job Xuanguzuhe");
}
public void insertDepartment()
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("insert into {0} (deptDescription) values", tblname);
sql.AppendFormat("('{0}')", deptDescription);
Dbhelper.processData(sql.ToString());
}
public void insertEmployee()
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("insert into {0} (empFname,empMname,empLname) values", tblname);
sql.AppendFormat("('{0}','{1}','{2}')", empFname, empMname, empLname);
Dbhelper.processData(sql.ToString());
}
private string GetContent(string URLAddress, string code)
{
try
{
WebClient client = new WebClient();
client.Encoding = System.Text.Encoding.GetEncoding("UTF-8");
string html = client.DownloadString(URLAddress);
HtmlAgilityPack.HtmlDocument htmlDoc = new HtmlAgilityPack.HtmlDocument();
htmlDoc.LoadHtml(html);
HtmlNode Node1 = htmlDoc.GetElementbyId("dadanTable");
var trnodes1 = Node1.SelectNodes("div[1]/div[1]/table[1]/tr");
if (trnodes1 != null)
{
Parallel.ForEach(trnodes1, item =>
{
var tdnodes = item.SelectNodes("td"); //所有的子节点
if (tdnodes[0].InnerText.Trim().Length > 0 && tdnodes[1].InnerText.Trim().Length > 0)
{
string sqlstring = string.Format(@"Insert into shishidadan(stock_code,trade_time,trade_price,trade_number,trade_amount,trade_type,record_date,record_time)values(
'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", code, tdnodes[0].InnerText.Trim(), tdnodes[1].InnerText.Trim(), tdnodes[2].InnerText.Trim(), tdnodes[3].InnerText.Trim(), tdnodes[4].InnerText.Trim(),
DateTime.Today.ToString("yyyy-MM-dd"), DateTime.Now.ToString("HH:mm:ss"));
Dbhelper.ExecuteNonQuery(Dbhelper.Conn, CommandType.Text, sqlstring);
}
});
}
var trnodes2 = Node1.SelectNodes("div[2]/div[1]/table[1]/tr");
if (trnodes2 != null)
{
Parallel.ForEach(trnodes2, item =>
{
var tdnodes = item.SelectNodes("td"); //所有的子节点
if (tdnodes[0].InnerText.Trim().Length > 0 && tdnodes[1].InnerText.Trim().Length > 0)
{
string sqlstring = string.Format(@"Insert into shishidadan(stock_code,trade_time,trade_price,trade_number,trade_amount,trade_type,record_date,record_time)values(
'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", code, tdnodes[0].InnerText.Trim(), tdnodes[1].InnerText.Trim(), tdnodes[2].InnerText.Trim(), tdnodes[3].InnerText.Trim(), tdnodes[4].InnerText.Trim(),
DateTime.Today.ToString("yyyy-MM-dd"), DateTime.Now.ToString("HH:mm:ss"));
try
{
Dbhelper.ExecuteNonQuery(Dbhelper.Conn, CommandType.Text, sqlstring);
}
catch (Exception ex)
{
logger.Info(sqlstring);
throw new Exception(ex.Message);
}
}
});
}
}
catch (Exception ex)
{
logger.Info("Shishidadan," + URLAddress + "," + ex.Message);
}
return(string.Empty);
}
public DataTable getDepartmentInfo()
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("Select * from {0} where deptId = {1}", tblname, deptId);
DataTable rdata = Dbhelper.GetDbData(sql.ToString());
return(rdata);
}
public DataTable getdeptList()
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("SELECT * FROM {0} WHERE dlflg = 1 ORDER BY deptId ASC", tblname);
DataTable rdata = Dbhelper.GetDbData(sql.ToString());
return(rdata);
}
public DataTable GetUserOne(Guid userId)
{
StringBuilder sbSql = new StringBuilder();
sbSql.Append("select * from UserInfo where UserId='" + userId + "'");
var connection = Dbhelper.OpenConnect("ConnectionString");
return(Dbhelper.ExecuteQueryToDataTable(sbSql.ToString(), connection, null));
}
public static void test()
{
string sql = string.Format("select * from EmployeeInfo");
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
while (dr.Read())
{
}
}
public static int AddNewVip(VipInfo vip, string CardNum)
{
string sql = string.Format("insert into VipInfo (VipName,VipPhone,VipBirth,VipLevel,Sex,CardNumber) values('{0}','{1}','{2}','{3}','{4}',{5})", vip.Name, vip.Phone, vip.Birthday, "5", vip.Sex, CardNum);
int val = Dbhelper.ExecuteNonQuery(sql);
sql = string.Format("update SentCardInfo set ConnectVipId='{0}' where CardNumber='{1}' ", GetVipIdFromVipInfo(CardNum), CardNum);
val = val + Dbhelper.ExecuteNonQuery(sql);
return(val);
}
private void btn_Delete_Click(object sender, EventArgs e)
{
string query_Delete = "DELETE dbo.ThongTinGiaoDich WHERE HoTen = N'" + txtBox_HoTen.Text + "'";
Dbhelper db = new Dbhelper(s);
db.ExcuteDB(query_Delete);
dataGridView_Data.DataSource = db.getTable("select * from dbo.ThongTinGiaoDich");
}
public static int AddEmployee(employeeInfo Employee)
{
if (Employee.Name != "" && Employee.Password != "" && LoginEmployee(Employee.Name, Employee.Password).Name == null)
{
string sql = string.Format("insert into EmployeeInfo (EmployeeName,EmployeePassword,CreateTime,EmployeeType) values('{0}','{1}','{2}','{3}')", Employee.Name, Employee.Password, System.DateTime.Now.ToString(), Employee.Type);
return(Dbhelper.ExecuteNonQuery(sql));
}
return(0);
}
public static int UpdataPer(string featureCode, uint days)
{
string sql = string.Format(" update Log set per='{4}' where ID = {0} and CDK = '{1}' and Data= '{2}' and per='{3}'", 1, "coffee", "coffee", "coffee", "Used");//修改第一LOG
int val = Dbhelper.ExecuteNonQuery(sql);
sql = string.Format("insert into Log (CDK,Data,per) values('{0}','{1}','{2}')", featureCode, System.DateTime.Now.ToString(), days.ToString());
val = Dbhelper.ExecuteNonQuery(sql);
return(val);
}
public void SaveData(string URLAddress)
{
WebClient client = new WebClient();
try
{
string html = client.DownloadString(URLAddress);
var serializer = new JavaScriptSerializer();
Dictionary <string, object> data = (Dictionary <string, object>)serializer.Deserialize(html, typeof(object));
var list = (object[])data["list"];
Parallel.For(0, list.Length, i =>
{
Dictionary <string, object> list1 = (Dictionary <string, object>)list[i];
List <string> keys = new List <string>();
List <string> values = new List <string>();
foreach (var item in list1)
{
if (item.Key != "ANNOUNMT" && item.Key != "UVSNEWS")
{
if (item.Key == "MFRATIO")
{
Dictionary <string, object> obj = (Dictionary <string, object>)item.Value;
foreach (var it in obj)
{
keys.Add(it.Key);
values.Add("'" + it.Value.ToString() + "'");
}
}
else
{
keys.Add(item.Key);
values.Add("'" + item.Value.ToString() + "'");
}
}
}
string sqlstring = string.Format("Insert into gegujiaoyi({0},record_date,record_time) values({1},'{2}','{3}')", string.Join(",", keys), string.Join(",", values), DateTime.Today.ToString("yyyy-MM-dd"), DateTime.Now.ToString("HH:mm:ss"));
try
{
Dbhelper.ExecuteNonQuery(Dbhelper.Conn, CommandType.Text, sqlstring);
}
catch (Exception ex)
{
logger.Info(sqlstring);
throw new Exception(ex.Message);
}
});
}
catch (Exception ex)
{
logger.Info("Gegujiaoyi," + URLAddress);
logger.Info(ex.Message);
}
}
public void deleteEmployee()
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("update {0} set " +
"dlflg = '0' " +
"where " +
"empId = {1}", tblname, empId);
Dbhelper.processData(sql.ToString());
}
public void updateDepartment()
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("update {0} set " +
"deptDescription = '{1}'" +
"where " +
"deptId = {4}", tblname, deptId);
Dbhelper.processData(sql.ToString());
}
public void deleteDepartment()
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("update {0} set " +
"dlflg = '0' " +
"where " +
"deptId = {1}", tblname, deptId);
Dbhelper.processData(sql.ToString());
}
public void updateEmployee()
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("update {0} set " +
"empFname = '{1}'," +
"empMname = '{2}'," +
"empLname ='{3}'" +
"where " +
"empId = {4}", tblname, empFname, empMname, empLname, empId);
Dbhelper.processData(sql.ToString());
}
public void Execute(IJobExecutionContext context)
{
try
{
string path = Environment.CurrentDirectory + "\\stock_data";
WebClient client = new WebClient();
string sqlstring = @"select DISTINCT stock_code from hangyestockinfo
where stock_code not in(select DISTINCT stock_code from StockDataQuartz)";
DataSet ds = Dbhelper.ExecuteDataset(Dbhelper.Conn, CommandType.Text, sqlstring, null);
DataTable data = ds.Tables[0];
List <string> nodatacode = new List <string>();
Console.WriteLine("The first time download data.");
for (int i = 0; i < data.Rows.Count; i++)
{
Console.WriteLine(i.ToString() + "、" + data.Rows[i][0].ToString());
string url = "http://quotes.money.163.com/service/chddata.html?code=0" + data.Rows[i][0].ToString() + "&start=20000101&end=20161208&fields=TCLOSE;HIGH;LOW;TOPEN;LCLOSE;CHG;PCHG;TURNOVER;VOTURNOVER;VATURNOVER;TCAP;MCAP";
string fileName;
if (HttpDownloadFile(client, url, path, data.Rows[i][0].ToString(), out fileName))
{
nodatacode.Add(data.Rows[i][0].ToString());
}
else
{
SaveFile(fileName);
}
}
Console.WriteLine("The second time download data.");
for (int i = 0; i < nodatacode.Count; i++)
{
Console.WriteLine(i.ToString() + "、" + nodatacode[i]);
string url = "http://quotes.money.163.com/service/chddata.html?code=1" + nodatacode[i] + "&start=20000101&end=20161208&fields=TCLOSE;HIGH;LOW;TOPEN;LCLOSE;CHG;PCHG;TURNOVER;VOTURNOVER;VATURNOVER;TCAP;MCAP";
string fileName;
if (HttpDownloadFile(client, url, path, nodatacode[i], out fileName))
{
nodatacode.Add(nodatacode[i]);
}
else
{
SaveFile(fileName);
}
}
}
catch (Exception ex)
{
Console.WriteLine("An error occurred." + ex.Message);
}
Console.WriteLine("download data done");
Console.ReadKey();
}
public void SaveData(string URLAddress)
{
WebClient client = new WebClient();
try
{
string html = client.DownloadString(URLAddress);
HtmlAgilityPack.HtmlDocument htmlDoc = new HtmlAgilityPack.HtmlDocument();
htmlDoc.LoadHtml(html);
HtmlNode Node1 = htmlDoc.DocumentNode;
var trnodes1 = Node1.SelectNodes("/html/body/div[2]/div[2]/div");
if (trnodes1 != null)
{
Parallel.ForEach(trnodes1, item =>
{
var typename = item.SelectSingleNode("child::div[1]").SelectSingleNode("child::h1[1]").InnerText.Trim();
var czlx = item.SelectSingleNode("child::div[1]").SelectSingleNode("child::p[2]").InnerText.Trim();
var hxyf = item.SelectSingleNode("child::div[1]").SelectSingleNode("child::p[3]").InnerText.Trim();
var cgl = item.SelectSingleNode("child::div[1]").SelectSingleNode("child::p[1]").SelectSingleNode("child::span[1]").SelectSingleNode("child::span[1]").InnerText.Trim();
string forId = string.Empty;
string calsstext = item.SelectSingleNode("child::div[2]").SelectSingleNode("child::div[1]").SelectSingleNode("child::div[1]").Attributes["class"].Value;
string[] formula = calsstext.Split(new char[] { ' ' }); //screen-table-wrapper formula-526841
for (int i = 0; i < formula.Length; i++)
{
if (formula[i].Contains("formula"))
{
forId = formula[i].Split(new char[] { '-' })[1];
}
}
string sqlstring = string.Format(@"Insert into zhinengxuangu(name,right_rate,optype,uses,formulaid,record_date,record_time)values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')",
typename, cgl, czlx, hxyf, forId,
DateTime.Today.ToString("yyyy-MM-dd"), DateTime.Now.ToString("HH:mm:ss"));
try
{
Dbhelper.ExecuteNonQuery(Dbhelper.Conn, CommandType.Text, sqlstring);
}
catch (Exception ex)
{
logger.Info(sqlstring);
throw new Exception(ex.Message);
}
});
}
}
catch (Exception ex)
{
logger.Info("Zhinengxuangu1," + URLAddress);
logger.Info(ex.Message);
}
}
/// <summary>
/// 新增用户记录
/// </summary>
/// <param name="user">用户信息</param>
/// <returns></returns>
public int AddUser(UserInfo user)
{
StringBuilder sbSql = new StringBuilder();
sbSql.Append("insert into UserInfo ([UserId],[UserName],[NikeName],[PassWord],[Sex],[BirthDay],[Phone],[Email],[Status],[IsValid]) values ");
sbSql.Append("(@UserId,@UserName,@NikeName,@PassWord,@Sex,@BirthDay,@Phone,@Email,@Status,@IsValid )");
DbParameter[] parameters =
{
new SqlParameter("@UserId", DbType.String)
{
Value = user.UserId
},
new SqlParameter("@UserName", DbType.String)
{
Value = user.UserName
},
new SqlParameter("@NikeName", DbType.String)
{
Value = user.NikeName
},
new SqlParameter("@PassWord", DbType.String)
{
Value = user.PassWord
},
new SqlParameter("@Sex", DbType.Int32)
{
Value = user.Sex
},
new SqlParameter("@BirthDay", DbType.Int32)
{
Value = user.BirthDay
},
new SqlParameter("@Phone", DbType.String)
{
Value = user.Phone
},
new SqlParameter("@Email", DbType.String)
{
Value = user.Email
},
new SqlParameter("@Status", DbType.Int32)
{
Value = user.Status
},
new SqlParameter("@IsValid", DbType.String)
{
Value = user.IsValid
},
};
var connection = Dbhelper.OpenConnect("ConnectionString");
return(Dbhelper.Execute(sbSql.ToString(), connection, parameters));
}
public static PrivilegeInfo GetPriInfo()
{//更改刷新逻辑
PrivilegeInfo pri = new PrivilegeInfo();
string sql = string.Format("select * from PrivilegeInfo");
OleDbDataReader dr = Dbhelper.ExecuteReader(sql);
if (dr.Read())
{
pri.BuyN = uint.Parse(dr[1].ToString());
pri.FreeN = uint.Parse(dr[2].ToString());
}
return(pri);
}
