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