private ArrayList TaskBookInfo()
{
ArrayList arrayList = new ArrayList();
if (this.DGrdOverWOrk.Items.Count > 0)
{
foreach (DataGridItem dataGridItem in this.DGrdOverWOrk.Items)
{
string arg_5F_0 = ((TextBox)dataGridItem.Cells[3].Controls[1]).Text;
ConstructTaskBook constructTaskBook = new ConstructTaskBook();
constructTaskBook.TaskBookCode = this.ViewState["TaskBookCode"].ToString();
constructTaskBook.TaskCode = dataGridItem.Cells[6].Text;
constructTaskBook.ProjectCode = this.ProjectCode;
constructTaskBook.ConstructDate = Convert.ToDateTime(this.DbConstructDate.Text);
constructTaskBook.ConstructUnit = 0;
constructTaskBook.RecordPerson = this.TxtRecordPerson.Text;
constructTaskBook.QualityAndSafety = this.TxtQualityAndSafety.Text;
try
{
constructTaskBook.TodayComplete = ((((TextBox)dataGridItem.Cells[3].Controls[1]).Text == "") ? 0m : Convert.ToDecimal(((TextBox)dataGridItem.Cells[3].Controls[1]).Text));
}
catch
{
}
constructTaskBook.WorkContent = ((TextBox)dataGridItem.Cells[4].Controls[1]).Text;
constructTaskBook.TodayWorkRemark = ((TextBox)dataGridItem.Cells[5].Controls[1]).Text;
arrayList.Add(constructTaskBook);
}
}
return(arrayList);
}
private void DoAlertMsg(ArrayList TaskInfos)
{
string[] strArray = new string[] { ConfigurationSettings.AppSettings["Artificial consumption"], ConfigurationSettings.AppSettings["Material consumption"], ConfigurationSettings.AppSettings["Equipment consumption"] };
UserInfo currentUserInfo = userManageDb.GetCurrentUserInfo();
for (int i = 0; i < TaskInfos.Count; i++)
{
ConstructTaskBook book = (ConstructTaskBook)TaskInfos[i];
for (int j = 0; j < strArray.Length; j++)
{
AlertPoint point = new AlertPoint(strArray[j]);
if (point.Options[2].IsSelected)
{
SchedulePlanAction action = new SchedulePlanAction();
new ResourceItemAction();
AlertMessage message = new AlertMessage();
if (currentUserInfo != null)
{
message.ManInput = currentUserInfo.UserCode;
}
message.MenAlertTo = point.YHDMsOfPeopleAlertTo;
message.TimeInput = DateTime.Now;
message.TimeOutput = DateTime.Now;
message.TimeOver = DateTime.Now.AddDays(point.ValidTimeLong);
message.PresentimentID = point.pkID;
message.PrjCode = this.ProjectCode.ToString();
DataTable table = TaskBookAction.DoAlert(this.ProjectCode, book.TaskCode, j + 1, book.TaskBookCode);
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
decimal num3 = (decimal.Parse(row["ResBudget"].ToString()) == 0M) ? 0M : (decimal.Parse(row["ResConsum"].ToString()) / decimal.Parse(row["ResBudget"].ToString()));
decimal num4 = (decimal.Parse(row["Quantity"].ToString()) == 0M) ? 0M : (decimal.Parse(row["Complete"].ToString()) / decimal.Parse(row["Quantity"].ToString()));
if (num3 > num4)
{
message.Message = string.Concat(new object[] { PrjInfoAction.GetProjectNameOfCode(this.ProjectCode.ToString()), " ", action.GetTaskName(this.ProjectCode, book.TaskCode), " ", row["ResourceName"].ToString(), "消耗比例超过工程完成比例(", decimal.Round(num3 * 100M, 2), "%/", decimal.Round(num4 * 100M, 2), "%)." });
message.Send();
}
}
}
}
}
}
}
public int TaskBookIns(ConstructTaskBook ctb, ArrayList RationList, ArrayList ResourceList)
{
string str = "begin";
object obj2 = str + " insert into EPM_Book_ConstructTask (TaskBookCode,ProjectCode,TaskCode,ConstructUnit,ConstructDate,RecordPerson,QualityAndSafety,TodayComplete,WorkContent,TodayWorkRemark)";
object obj3 = string.Concat(new object[] {
obj2, " values('", ctb.TaskBookCode, "','", ctb.ProjectCode, "','", ctb.TaskCode, "','", ctb.ConstructUnit, "','", ctb.ConstructDate, "','", ctb.RecordPerson, "','", ctb.QualityAndSafety, "','",
ctb.TodayComplete, "','", ctb.WorkContent, "','", ctb.TodayWorkRemark, "')"
});
str = string.Concat(new object[] { obj3, " update EPM_Task_TaskList set CompleteCount=case when isnull(Quantity,0)= 0 then 0 else (isnull(dbo.f_Construct_GetOverQuantity(ProjectCode,TaskCode),0)/isnull(Quantity,0))*100 end where ProjectCode='", ctb.ProjectCode, "' and TaskCode='", ctb.TaskCode, "' " });
for (int i = 0; i < ResourceList.Count; i++)
{
object obj4 = ((str + " insert into EPM_Book_Resource (TaskBookCode,ResourceCode,Quantity,UnitPrice,ResourceStyle,FactQuantity)") + " values ('" + ((TaskBookResource)ResourceList[i]).TaskBookCode + "',") + " '" + ((TaskBookResource)ResourceList[i]).ResourceCode + "',";
object obj5 = string.Concat(new object[] { obj4, " '", ((TaskBookResource)ResourceList[i]).Quantity, "'," });
object obj6 = string.Concat(new object[] { obj5, " '", ((TaskBookResource)ResourceList[i]).UnitPrice, "'," });
object obj7 = string.Concat(new object[] { obj6, " '", ((TaskBookResource)ResourceList[i]).ResourceStyle, "'," });
str = string.Concat(new object[] { obj7, " '", ((TaskBookResource)ResourceList[i]).FactQuantity, "')" });
}
return(publicDbOpClass.ExecSqlString(str + " end"));
}
