public bool NewSend(string TaskStr) { Sql2KDataAccess access = new Sql2KDataAccess(); Hashtable hT = new Hashtable(); hT.Add("@TaskIDStr", TaskStr.Trim()); hT.Add("@UserName", User.UserName); return access.RunProcedureNoReturn(hT, "P_CreateNewSend"); }
public bool NewSendList(string TaskId) { Sql2KDataAccess access = new Sql2KDataAccess(); Hashtable hT = new Hashtable(); hT.Add("@TaskId", TaskId.Trim()); hT.Add("@UserName", User.UserName); return access.RunProcedureNoReturn(hT, "P_OutStorage"); }
public bool PlanToTask(string PlanId) { Sql2KDataAccess access = new Sql2KDataAccess(); Hashtable hT = new Hashtable(); hT.Add("@PlanId", PlanId); hT.Add("@UserName", User.UserName); return access.RunProcedureNoReturn(hT, "P_PlanToTask"); }
public bool NpToTask(string TaskId, string NpId) { Sql2KDataAccess access = new Sql2KDataAccess(); Hashtable hT = new Hashtable(); hT.Add("@TaskId", TaskId); hT.Add("@NpId", NpId); return access.RunProcedureNoReturn(hT, "P_NpToTask"); }
public bool SaveBoxCapability(int Capability) { Sql2KDataAccess access = new Sql2KDataAccess(); Hashtable hT = new Hashtable(); hT.Add("@SetKey", "MbBoxCapability"); hT.Add("@SetValue", Capability); hT.Add("@UserName", User.UserName); return access.RunProcedureNoReturn(hT, "P_SaveSet"); }
public static bool SaveSendPrinter(string SendPrinter) { Sql2KDataAccess access = new Sql2KDataAccess(); Hashtable hT = new Hashtable(); hT.Add("@SetKey", "SendPrinter"); hT.Add("@SetValue", SendPrinter); hT.Add("@UserName", User.UserName); return access.RunProcedureNoReturn(hT, "P_SaveSet"); }
public bool SignInSendList(string SendId, string ReceivePerson) { Sql2KDataAccess access = new Sql2KDataAccess(); Hashtable hT = new Hashtable(); hT.Add("@SendId", SendId.Trim()); hT.Add("@ReceivePerson", ReceivePerson.Trim()); return access.RunProcedureNoReturn(hT, "P_SignInSendList"); }
public bool SmtAudiResult(string PlanId, bool IsPass) { Sql2KDataAccess access = new Sql2KDataAccess(); Hashtable hT = new Hashtable(); hT.Add("@PlanId", PlanId); hT.Add("@UserName", User.UserName); hT.Add("@IsPass", IsPass ? "1" : "0"); return access.RunProcedureNoReturn(hT, "P_AudiResult"); }
public static bool UpdateReceiveMonyState(string PlanId, bool Received) { Sql2KDataAccess access = new Sql2KDataAccess(); Hashtable hT = new Hashtable(); hT.Add("@PlanId", PlanId); hT.Add("@ReceiveMoney", Received ? "1" : "0"); return access.RunProcedureNoReturn(hT, "P_ReceiveMoney "); }
public bool UpdateUserAuthority(string UserName, string AuthorityCode, bool IsDelete) { Sql2KDataAccess access = new Sql2KDataAccess(); Hashtable hT = new Hashtable(); hT.Add("@UserName", UserName); hT.Add("@Code", AuthorityCode.Trim()); hT.Add("@IsDelete", IsDelete ? 1 : 0); return access.RunProcedureNoReturn(hT, "P_UpdateUserAuthority"); }
public bool ModiUser(string UserName, string Pwd, string TrueName, string Duty, string BarCode) { Sql2KDataAccess access = new Sql2KDataAccess(); Hashtable hT = new Hashtable(); hT.Add("@UserName", UserName); hT.Add("@truename", TrueName); hT.Add("@Pwd", this.GetPwdHashCode(Pwd)); hT.Add("@duty", Duty); hT.Add("@BarCode", BarCode); return access.RunProcedureNoReturn(hT, "P_ModiUser"); }
public bool ModiPwd(string NewPwd) { Sql2KDataAccess access = new Sql2KDataAccess(); Hashtable hT = new Hashtable(); hT.Add("@UserName", UserName); hT.Add("@NewPwd", this.GetPwdHashCode(NewPwd)); return access.RunProcedureNoReturn(hT, "P_ModiPwd"); }
public bool DeleteUser(string UserName) { Sql2KDataAccess access = new Sql2KDataAccess(); Hashtable hT = new Hashtable(); hT.Add("@UserName", UserName); return access.RunProcedureNoReturn(hT, "P_DeleteUser"); }