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