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); }