public DataSet GetNewTask()
{
Sql2KDataAccess access = new Sql2KDataAccess();
DataSet dataset = new DataSet();
Hashtable hT = new Hashtable();
access.RunProcedure(ref dataset, hT, "P_GetNewMbTask");
return dataset;
}
public DataSet GetNpByTaskId(string TaskId)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
DataSet dataset = new DataSet();
hT.Add("@TaskId", TaskId);
access.RunProcedure(ref dataset, hT, "P_GetNpByTaskId");
return dataset;
}
public DataSet GetToDoNp(string PlanId)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
DataSet dataset = new DataSet();
hT.Add("@PlanId", PlanId.Trim());
access.RunProcedure(ref dataset, hT, "P_GetToDoNp");
return dataset;
}
public DataSet GetToDoPan(string MbType, string WProcedure)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
DataSet dataset = new DataSet();
hT.Add("@MbType", MbType);
hT.Add("@CurrentProcedure", WProcedure);
access.RunProcedure(ref dataset, hT, "P_GetToDoPan");
return dataset;
}
public DataSet GetUnApprPlan(bool IsInner, bool IsRemark)
{
object obj2 = new object();
lock (obj2)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
DataSet dataset = new DataSet();
hT.Add("@Result", 0);
hT.Add("@IsInner", IsInner ? 1 : 0);
if (IsRemark)
{
access.RunProcedure(ref dataset, hT, "P_GetReMakePlanforAppr");
}
else
{
access.RunProcedure(ref dataset, hT, "P_GetPlanByState");
}
return dataset;
}
}
public DataSet GetAuditedPlan(bool IsInner, bool IsRemark)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
DataSet dataset = new DataSet();
hT.Add("@Result", 1);
hT.Add("@IsInner", IsInner ? 1 : 0);
if (IsRemark)
{
access.RunProcedure(ref dataset, hT, "P_GetReMakePlanforAppr");
return dataset;
}
access.RunProcedure(ref dataset, hT, "P_GetPlanByState");
return dataset;
}
public DataSet GetUserAllAuthority(string UserName)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
DataSet dataset = new DataSet();
hT.Add("@UserName", UserName);
access.RunProcedure(ref dataset, hT, "P_GetUserAuthority");
return dataset;
}
public DataSet GetAllAuthority()
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
DataSet dataset = new DataSet();
access.RunProcedure(ref dataset, hT, "P_GetAllAuthority");
return dataset;
}