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