public string NewTask()
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
new DataSet();
hT.Add("@UserName", User.UserName);
return access.RunProcedureNoRecord("@TaskId", SqlDbType.VarChar, hT, "P_NewTask");
}
public static string CreateWorkPlanID()
{
Hashtable hT = new Hashtable();
Sql2KDataAccess access = new Sql2KDataAccess();
m_IntWorkPlanID = Convert.ToInt32(access.RunProcedureNoRecord("@NewWorkPlanID", SqlDbType.Char, hT, "P_CreateWorkPlanID").Trim());
m_StrWorkPlanID = "W" + DateTime.Now.ToString("yyyyMMdd") + m_IntWorkPlanID.ToString("D3");
return m_StrWorkPlanID;
}
public int GetBoxCapability()
{
Sql2KDataAccess access = new Sql2KDataAccess();
new DataSet();
Hashtable hT = new Hashtable();
hT.Add("@SetKey", "MbBoxCapability");
hT.Add("@UserName", User.UserName);
return int.Parse(access.RunProcedureNoRecord("@SetValue", SqlDbType.VarChar, hT, "P_GetSet"));
}
public static string GetSendPrinter()
{
Sql2KDataAccess access = new Sql2KDataAccess();
new DataSet();
Hashtable hT = new Hashtable();
hT.Add("@SetKey", "SendPrinter");
hT.Add("@UserName", User.UserName);
return access.RunProcedureNoRecord("@SetValue", SqlDbType.VarChar, hT, "P_GetSet");
}
public string NewTask(string MbType, long MbAmount, string WProcedure)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
hT.Add("@UserName", User.UserName);
hT.Add("@MbType", MbType);
hT.Add("@MbAmount", MbAmount);
hT.Add("@WProcedure", WProcedure);
return access.RunProcedureNoRecord("@MbTaskId", SqlDbType.VarChar, hT, "P_NewMbTask");
}
public string GetPlanRemark(string PlanId)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
hT.Add("@PlanId", PlanId);
return access.RunProcedureNoRecord("@Remark", SqlDbType.VarChar, hT, "P_GetPlanRemark");
}
public int UserLogin(string UserName, string Pwd)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
hT.Add("@UserName", UserName);
hT.Add("@Pwd", this.GetPwdHashCode(Pwd));
string s = access.RunProcedureNoRecord("result", SqlDbType.VarChar, hT, "P_UserLogin");
if (s == "1")
{
m_UserName = UserName.Trim();
}
return int.Parse(s);
}
public bool AddUser(string UserName, string Pwd, string TrueName, string Duty, string BarCode)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
hT.Add("@UserName", UserName);
hT.Add("@Pwd", this.GetPwdHashCode(Pwd));
hT.Add("@truename", TrueName);
hT.Add("@duty", Duty);
hT.Add("@BarCode", BarCode);
if (!(access.RunProcedureNoRecord("@IsSuccess", SqlDbType.Int, hT, "P_AddUser") == "0"))
{
return false;
}
return true;
}
public static bool IsHaveAuthority(string AuthorityName)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
hT.Add("@UserName ", m_UserName);
hT.Add("@AutorityName ", AuthorityName);
if (!(access.RunProcedureNoRecord("@IsHave", SqlDbType.Int, hT, "P_CheckAuthority") == "1"))
{
return false;
}
return true;
}