public WBSBidTaskCollection GetAllScheduleList(string type, Guid projectCode, DateTime dtStartDate, DateTime dtEndDate, Guid pageCode, string userCode, int wbsType)
{
WBSBidTaskCollection tasks = new WBSBidTaskCollection();
string sqlString = "";
if (type == "N")
{
object obj2 = (sqlString + " if exists(select * from EPM_Task_TaskList where ProjectCode='" + projectCode.ToString() + "' and IsValid = 1) ") + " insert into EPM_Sch_TempSchedule(PageCode,UserCode,ProjectCode,TaskCode,ParentTaskCode,TaskName,Quantity,QuantityUnit,WorkLayer,ChildNum,IsValid,Cost,SynthPrice,StartDate,EndDate,Remark,ContractPrice,Safety,Quality,TaskState,Pivotal,WorkDay,CompleteCount) ";
string str2 = string.Concat(new object[] { obj2, " select '", pageCode, "','", userCode, "',ProjectCode,TaskCode,ParentTaskCode,TaskName,isnull(Quantity,0) as Quantity,QuantityUnit,isnull(WorkLayer,0) as WorkLayer,isnull(ChildNum,0) as ChildNum,IsValid,isnull(Cost,0) as Cost,isnull(SynthPrice,0) as SynthPrice, " }) + " StartDate,EndDate,Remark,isnull(ContractPrice,0) as ContractPrice,Safety,Quality,isnull(TaskState,0) as TaskState,Pivotal,WorkDay,isnull(CompleteCount,0) as CompleteCount ";
object obj3 = str2 + " from EPM_Task_TaskList where ProjectCode='" + projectCode.ToString() + "' and IsValid = 1 and WbsType=" + wbsType.ToString() + " order by TaskCode asc ";
sqlString = string.Concat(new object[] { obj3, " select * from EPM_Sch_TempSchedule where ProjectCode='", projectCode, "' and PageCode='", pageCode, "' and UserCode='", userCode, "' order by TaskCode asc " });
}
if (type == "S")
{
object obj4 = sqlString;
object obj5 = string.Concat(new object[] { obj4, " if exists(select * from EPM_Task_TaskList where ProjectCode='", projectCode.ToString(), "' and StartDate>='", dtStartDate, "' and StartDate<='", dtEndDate, "' and WorkLayer='3' and IsValid = 1) " }) + " insert into EPM_Sch_TempSchedule(PageCode,UserCode,ProjectCode,TaskCode,ParentTaskCode,TaskName,Quantity,QuantityUnit,WorkLayer,ChildNum,IsValid,Cost,SynthPrice,StartDate,EndDate,Remark,ContractPrice,Safety,Quality,TaskState,Pivotal,WorkDay,CompleteCount) ";
object obj6 = string.Concat(new object[] { obj5, " select '", pageCode, "','", userCode, "',ProjectCode,TaskCode,ParentTaskCode,TaskName,isnull(Quantity,0) as Quantity,QuantityUnit,isnull(WorkLayer,0) as WorkLayer,isnull(ChildNum,0) as ChildNum,IsValid,isnull(Cost,0) as Cost,isnull(SynthPrice,0) as SynthPrice, " }) + " StartDate,EndDate,Remark,isnull(ContractPrice,0) as ContractPrice,Safety,Quality,isnull(TaskState,0) as TaskState,Pivotal,WorkDay,isnull(CompleteCount,0) as CompleteCount ";
object obj7 = string.Concat(new object[] { obj6, " from EPM_Task_TaskList where ProjectCode='", projectCode.ToString(), "' and StartDate>='", dtStartDate, "' and StartDate<='", dtEndDate, "' and WorkLayer='3' and IsValid = 1 and WbsType=1 order by TaskCode asc " });
sqlString = string.Concat(new object[] { obj7, " select PageCode,UserCode,ProjectCode,TaskCode,'' as ParentTaskCode,TaskName,Quantity,QuantityUnit,WorkLayer,ChildNum,IsValid,Cost,SynthPrice,StartDate,EndDate,Remark,ContractPrice,Safety,Quality,TaskState,Pivotal,WorkDay,CompleteCount from EPM_Sch_TempSchedule where ProjectCode='", projectCode, "' and PageCode='", pageCode, "' and UserCode='", userCode, "' order by TaskCode asc " });
}
DataTable table = publicDbOpClass.DataTableQuary(sqlString);
for (int i = 0; i < table.Rows.Count; i++)
{
tasks.Add(this.GetFromDataRow(table.Rows[i]));
}
return(tasks);
}
public WBSBidTaskCollection GetContUpdateScheduleList(Guid projectCode, int wbsType, string ContractCode, string ContRecordID)
{
WBSBidTaskCollection tasks = new WBSBidTaskCollection();
DataTable table = publicDbOpClass.DataTableQuary("select * from EPM_Con_UpdateTaskList where ProjectCode='" + projectCode.ToString() + "' and ContractCode='" + ContractCode + "' and IsValid = 1 and WbsType=" + wbsType.ToString() + " and ContractUpdateID = '" + ContRecordID + "' order by TaskCode asc");
for (int i = 0; i < table.Rows.Count; i++)
{
tasks.Add(this.GetFromDataRowOfNew(table.Rows[i]));
}
return(tasks);
}
public WBSBidTaskCollection GetAllBidScheduleList(Guid projectCode, int wbsType, int workLayer)
{
WBSBidTaskCollection tasks = new WBSBidTaskCollection();
DataTable table = publicDbOpClass.DataTableQuary(string.Concat(new object[] { "select * from EPM_Task_TaskList where workLayer<=", workLayer, " and ProjectCode='", projectCode.ToString(), "' and IsValid = 1 and WbsType=", wbsType.ToString(), " order by TaskCode asc" }));
for (int i = 0; i < table.Rows.Count; i++)
{
tasks.Add(this.GetFromDataRowOfNew(table.Rows[i]));
}
return(tasks);
}
public WBSBidTaskCollection GetContractTaskList(Guid projectCode, string contractCode)
{
WBSBidTaskCollection tasks = new WBSBidTaskCollection();
DataTable table = publicDbOpClass.DataTableQuary("SELECT * FROM EPM_Contract_CountSelTask where ProjectCode='" + projectCode.ToString() + "' and ContractCode = '" + contractCode + "'");
for (int i = 0; i < table.Rows.Count; i++)
{
tasks.Add(this.GetFromDataRowOfNew(table.Rows[i]));
}
return(tasks);
}
public WBSBidTaskCollection GetAllScheduleList(Guid projectCode, Guid pageCode, string userCode)
{
WBSBidTaskCollection tasks = new WBSBidTaskCollection();
string str = "";
object obj2 = str;
DataTable table = publicDbOpClass.DataTableQuary(string.Concat(new object[] { obj2, " select * from EPM_Sch_TempSchedule where ProjectCode='", projectCode, "' and PageCode='", pageCode, "' and UserCode='", userCode, "' order by TaskCode asc " }));
for (int i = 0; i < table.Rows.Count; i++)
{
tasks.Add(this.GetFromDataRow(table.Rows[i]));
}
return(tasks);
}
public WBSBidTaskCollection GetAllBidScheduleList(Guid projectCode, int wbsType)
{
WBSBidTaskCollection tasks = new WBSBidTaskCollection();
string str = WebConfigurationManager.AppSettings["IsNewProject"].ToString();
string sqlString = "";
if (str == "1")
{
StringBuilder builder = new StringBuilder();
builder.AppendFormat("\r\n WITH ctetasks \r\n AS (SELECT TaskId, \r\n TaskName, \r\n ParentId, \r\n OrderNumber \r\n FROM Bud_Task \r\n WHERE PrjId = '{0}' \r\n AND Version = (SELECT CurVersion \r\n FROM vGetCurBudVersion \r\n WHERE PrjId = \r\n '{0}') \r\n ), \r\n cteformattasks \r\n AS (SELECT TaskId AS TaskCode, \r\n TaskName, \r\n ParentId AS ParentTaskCode, \r\n OrderNumber, \r\n (SELECT Count(*) \r\n FROM ctetasks \r\n WHERE T.TaskId = cteTasks.ParentId) AS ChildNum \r\n FROM ctetasks AS T) \r\n SELECT TaskCode, \r\n TaskName, \r\n ChildNum,\r\n ParentTaskCode\r\n FROM cteformattasks \r\n ORDER BY OrderNumber ASC ", projectCode);
sqlString = builder.ToString();
}
else
{
sqlString = "select * from EPM_Task_TaskList where ProjectCode='" + projectCode.ToString() + "' and IsValid = 1 and WbsType=" + wbsType.ToString() + " order by TaskCode asc";
}
DataTable table = publicDbOpClass.DataTableQuary(sqlString);
for (int i = 0; i < table.Rows.Count; i++)
{
tasks.Add(this.GetFromDataRowOfNew(table.Rows[i]));
}
return(tasks);
}
