public bool Login()
{//登录并获取权限
string strSql = @"select * from UserManage where Username=@Username and UserPW=@PW";
OleDbCommand cmd = new OleDbCommand(strSql, Foundation.CreateInstance());
cmd.Parameters.AddWithValue("@Username", Username);
cmd.Parameters.AddWithValue("@PW", Foundation.GetMD5String(PW));
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
this.UserNO = Convert.ToInt32(ds.Tables[0].Rows[0]["UserNO"].ToString());
this.Purchas = ds.Tables[0].Rows[0]["Purchas"].ToString() == "1";
this.SellDay = Convert.ToInt32(ds.Tables[0].Rows[0]["Sell"].ToString());
this.Stock = ds.Tables[0].Rows[0]["Stock"].ToString() == "1";
this.Usermanage = ds.Tables[0].Rows[0]["Usermanage"].ToString() == "1";
this.CancelSell = ds.Tables[0].Rows[0]["cancelsell"].ToString() == "1";
this.DeleteSell = ds.Tables[0].Rows[0]["deletesell"].ToString() == "1";
this.Remarks = ds.Tables[0].Rows[0]["Remark"].ToString();
this.Providers = ds.Tables[0].Rows[0]["providers"].ToString() == "1";
this.SystemSet = ds.Tables[0].Rows[0]["systemset"].ToString() == "1";
this.Record = ds.Tables[0].Rows[0]["Record"].ToString() == "1";
this.ShowProfit = ds.Tables[0].Rows[0]["ShowProfit"].ToString() == "1";
this.SellInprice = ds.Tables[0].Rows[0]["SellInprice"].ToString() == "1";
return(true);
}
else
{
return(false);
}
}
public bool ResetPW(string OldPW, string NewPW)
{//string strSql2 = @"update Purchas set outcount=outcount+@outcount where goodsno=@goodsno";
string strSql = @"update UserManage set UserPW=@NewPW where Username=@Username and UserPW=@OldPW";
OleDbCommand cmd = new OleDbCommand(strSql, Foundation.CreateInstance());
cmd.Parameters.AddWithValue("@NewPW", Foundation.GetMD5String(NewPW));
cmd.Parameters.AddWithValue("@Username", Username);
cmd.Parameters.AddWithValue("@OldPW", Foundation.GetMD5String(OldPW));
return(cmd.ExecuteNonQuery() > 0);
}
public bool Add()
{
string strSql = @"insert into UserManage(userno,username,userpw,purchas,sell,stock,usermanage,remark,cancelsell,deletesell,providers,systemset,record,ShowProfit,SellInprice) ";
strSql += "values(@userno,@username,@userpw,@purchas,@sell,@stock,@usermanage,@remark,@cancelsell,@deletesell,@providers,@systemset,@record,@ShowProfit,@SellInprice);";
OleDbCommand cmd = new OleDbCommand(strSql, Foundation.CreateInstance());
cmd.Parameters.AddWithValue("@userno", UserNO);
cmd.Parameters.AddWithValue("@username", Username);
cmd.Parameters.AddWithValue("@userpw", Foundation.GetMD5String(PW));
cmd.Parameters.AddWithValue("@purchas", Purchas ? 1 : 0);
cmd.Parameters.AddWithValue("@sell", SellDay);
cmd.Parameters.AddWithValue("@stock", Stock ? 1 : 0);
cmd.Parameters.AddWithValue("@usermanage", Usermanage ? 1 : 0);
cmd.Parameters.AddWithValue("@remark", Remarks);
cmd.Parameters.AddWithValue("@cancelsell", CancelSell ? 1 : 0);
cmd.Parameters.AddWithValue("@deletesell", DeleteSell ? 1 : 0);
cmd.Parameters.AddWithValue("@providers", Providers ? 1 : 0);
cmd.Parameters.AddWithValue("@systemset", SystemSet ? 1 : 0);
cmd.Parameters.AddWithValue("@record", Record ? 1 : 0);
cmd.Parameters.AddWithValue("@ShowProfit", ShowProfit ? 1 : 0);
cmd.Parameters.AddWithValue("@SellInprice", SellInprice ? 1 : 0);
return(cmd.ExecuteNonQuery() > 0);
}
