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); }
private void Init_theSchedule(Guid versionCode) { this._DtSchedule.Columns.Add(new DataColumn("NoteID", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("TaskCode", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("TaskName", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("ParentTaskCode", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("Quantity", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("QuantityUnit", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("WorkLayer", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("IsHaveChild", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("SynthPrice", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("Cost", typeof(string))); WBSBidTaskCollection wBSBidTaskCollection = new WBSBidTaskCollection(); wBSBidTaskCollection = this.bta.GetAllBidScheduleList(this.ProjectCode, 1); for (int i = 0; i < wBSBidTaskCollection.Count; i++) { DataRow dataRow = this._DtSchedule.NewRow(); WBSBidTask wBSBidTask = wBSBidTaskCollection[i]; dataRow["NoteID"] = wBSBidTask.NoteID; dataRow["TaskCode"] = wBSBidTask.TaskCode; dataRow["TaskName"] = wBSBidTask.TaskName; dataRow["Quantity"] = ((wBSBidTask.Quantity == 0m) ? "" : string.Format("{0:f}", wBSBidTask.Quantity)); dataRow["QuantityUnit"] = wBSBidTask.QuantityUnit; dataRow["WorkLayer"] = Convert.ToInt32(wBSBidTask.WorkLayer); dataRow["ParentTaskCode"] = wBSBidTask.ParentTaskCode.ToString(); dataRow["IsHaveChild"] = ((wBSBidTask.ChildNum > 0) ? "true" : "false"); dataRow["SynthPrice"] = wBSBidTask.SynthPrice.ToString(); dataRow["Cost"] = wBSBidTask.Cost.ToString(); this._DtSchedule.Rows.Add(dataRow); } }
private void Init_theSchedule(Guid versionCode) { this._DtSchedule.Reset(); this._DtSchedule.Columns.Add(new DataColumn("NoteID", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("TaskCode", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("TaskName", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("ParentTaskCode", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("WorkLayer", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("IsHaveChild", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("IsHaveServerChild", typeof(string))); WBSBidTaskCollection wBSBidTaskCollection = new WBSBidTaskCollection(); wBSBidTaskCollection = this.bta.GetAllBidScheduleList(this.ProjectCode, 1); for (int i = 0; i < wBSBidTaskCollection.Count; i++) { DataRow dataRow = this._DtSchedule.NewRow(); WBSBidTask wBSBidTask = wBSBidTaskCollection[i]; dataRow["NoteID"] = wBSBidTask.NoteID; dataRow["TaskCode"] = wBSBidTask.TaskCode; dataRow["TaskName"] = wBSBidTask.TaskName; dataRow["WorkLayer"] = Convert.ToInt32(wBSBidTask.WorkLayer); dataRow["ParentTaskCode"] = wBSBidTask.ParentTaskCode.ToString(); dataRow["IsHaveChild"] = ((wBSBidTask.ChildNum > 0) ? "true" : "false"); dataRow["IsHaveServerChild"] = "false"; this._DtSchedule.Rows.Add(dataRow); } }
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); }
private void Init_theSchedule(Guid versionCode) { this._DtSchedule.Reset(); this._DtSchedule.Columns.Add(new DataColumn("NoteID", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("TaskCode", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("TaskName", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("ParentTaskCode", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("Quantity", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("QuantityUnit", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("WorkLayer", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("IsHaveChild", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("IsHaveServerChild", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("StartDate", typeof(DateTime))); this._DtSchedule.Columns.Add(new DataColumn("EndDate", typeof(DateTime))); this._DtSchedule.Columns.Add(new DataColumn("ContractPrice", typeof(decimal))); this._DtSchedule.Columns.Add(new DataColumn("GSTotalFee", typeof(decimal))); this._DtSchedule.Columns.Add(new DataColumn("IsAlter", typeof(bool))); this._DtSchedule.Columns.Add(new DataColumn("Remark", typeof(string))); WBSBidTaskCollection wBSBidTaskCollection = new WBSBidTaskCollection(); wBSBidTaskCollection = this.bta.GetAllBidScheduleList(this.ProjectCode, 1); if (wBSBidTaskCollection.Count == 0) { this.BtnConfirm.Enabled = false; } for (int i = 0; i < wBSBidTaskCollection.Count; i++) { DataRow dataRow = this._DtSchedule.NewRow(); WBSBidTask wBSBidTask = wBSBidTaskCollection[i]; dataRow["NoteID"] = wBSBidTask.NoteID; dataRow["TaskCode"] = wBSBidTask.TaskCode; dataRow["TaskName"] = wBSBidTask.TaskName; dataRow["Quantity"] = ((wBSBidTask.Quantity == 0m) ? "0.00" : string.Format("{0:f}", wBSBidTask.Quantity)); dataRow["QuantityUnit"] = wBSBidTask.QuantityUnit; dataRow["WorkLayer"] = Convert.ToInt32(wBSBidTask.WorkLayer); dataRow["ParentTaskCode"] = wBSBidTask.ParentTaskCode.ToString(); dataRow["IsHaveChild"] = ((wBSBidTask.ChildNum > 0) ? "true" : "false"); dataRow["IsHaveServerChild"] = "false"; dataRow["StartDate"] = wBSBidTask.StartDate; dataRow["EndDate"] = wBSBidTask.EndDate; dataRow["ContractPrice"] = wBSBidTask.SynthPrice; dataRow["GSTotalFee"] = wBSBidTask.sumPrice; try { dataRow["IsAlter"] = wBSBidTask.IsAlter; } catch { dataRow["IsAlter"] = false; } dataRow["Remark"] = wBSBidTask.Remark; this._DtSchedule.Rows.Add(dataRow); } }
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); }
private void Init_theSchedule(Guid versionCode) { this._DtSchedule.Columns.Add(new DataColumn("TaskCode", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("TaskName", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("ParentTaskCode", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("Quantity", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("QuantityUnit", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("WorkLayer", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("IsHaveChild", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("IsHaveServerChild", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("StartDate", typeof(DateTime))); this._DtSchedule.Columns.Add(new DataColumn("EndDate", typeof(DateTime))); this._DtSchedule.Columns.Add(new DataColumn("ContractPrice", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("CompleteCount", typeof(string))); this._DtSchedule.Columns.Add(new DataColumn("CompleteRate", typeof(string))); WBSBidTaskCollection wBSBidTaskCollection = new WBSBidTaskCollection(); if (this.Type == "N" || this.Type == "S") { wBSBidTaskCollection = this.bta.GetAllScheduleList(this.Type, this.ProjectCode, this.dtStartDate, this.dtEndDate, this.PageCode, this.Session["yhdm"].ToString(), 1); } if (this.Type == "T") { wBSBidTaskCollection = this.bta.GetAllScheduleList(this.ProjectCode, this.TxtTaskCode.Text, this.TxtTaskName.Text, int.Parse(this.DDLProjectType.SelectedValue), this.PageCode, this.Session["yhdm"].ToString(), 1); } if (this.Type == "P") { wBSBidTaskCollection = this.bta.GetAllScheduleList(this.ProjectCode, this.PageCode, this.Session["yhdm"].ToString()); } for (int i = 0; i < wBSBidTaskCollection.Count; i++) { DataRow dataRow = this._DtSchedule.NewRow(); WBSBidTask wBSBidTask = wBSBidTaskCollection[i]; dataRow["TaskCode"] = wBSBidTask.TaskCode; dataRow["TaskName"] = wBSBidTask.TaskName; dataRow["Quantity"] = ((wBSBidTask.Quantity == 0m) ? "" : string.Format("{0:F2}", wBSBidTask.Quantity)); dataRow["QuantityUnit"] = wBSBidTask.QuantityUnit; dataRow["WorkLayer"] = Convert.ToInt32(wBSBidTask.WorkLayer); dataRow["ParentTaskCode"] = wBSBidTask.ParentTaskCode.ToString(); dataRow["IsHaveChild"] = ((wBSBidTask.ChildNum > 0) ? "true" : "false"); dataRow["IsHaveServerChild"] = "false"; dataRow["StartDate"] = wBSBidTask.StartDate; dataRow["EndDate"] = wBSBidTask.EndDate; dataRow["CompleteCount"] = wBSBidTask.CompleteCount.ToString("F2"); decimal d = Convert.ToDecimal(dataRow["CompleteCount"].ToString()); dataRow["CompleteRate"] = ((wBSBidTask.Quantity == 0m) ? 0m.ToString("P2") : (d / wBSBidTask.Quantity).ToString("P2")); this._DtSchedule.Rows.Add(dataRow); } }
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); }
protected decimal GetParentCompleteCount(string taskCode, decimal quantity, WBSBidTaskCollection scheduleList) { decimal num = 0m; decimal num2 = 0m; foreach (WBSBidTask wBSBidTask in scheduleList) { if (wBSBidTask.ParentTaskCode == taskCode) { if (wBSBidTask.ChildNum == 0) { num += wBSBidTask.CompleteCount; } else { num += this.GetParentCompleteCount(wBSBidTask.TaskCode, wBSBidTask.Quantity, scheduleList); } num2 += wBSBidTask.Quantity; } } decimal d = (num == 0m) ? 0m : (quantity / num2 * num); return(decimal.Round(d, 2)); }