public void BindGv()
{
DataTable allTask = BudContractTask.GetAllTask(this.prjId, string.Empty, string.Empty, string.Empty);
this.gvBudget.DataSource = allTask;
this.gvBudget.DataBind();
}
protected void bindContractBudget(string prjID, string contractId)
{
BudContractTask.GetTaskInfoByPrjIdAndConIdAndOrderNum(prjID, contractId, "", "", "", "");
DataTable conByParent = BudContractTask.GetConByParent(prjID, contractId, "", "", "", "", 0);
this.gvBudget.DataSource = conByParent;
this.gvBudget.DataBind();
}
protected void BindgvBudget()
{
if (!string.IsNullOrEmpty(ContractManage_IncometContract_IncometContractQuery.contractID))
{
IncometContractModel model = this.incometContractBll.GetModel(ContractManage_IncometContract_IncometContractQuery.contractID);
this.lblTitalbudContract.Text = "合同预算";
DataTable taskInfoByPrjIdAndConId = BudContractTask.GetTaskInfoByPrjIdAndConId(model.Project.PrjGuid.ToString(), ContractManage_IncometContract_IncometContractQuery.contractID, "", "", "");
this.gvBudget.DataSource = taskInfoByPrjIdAndConId;
this.gvBudget.DataBind();
}
}
private void DataBindBudget()
{
string text = base.Request["prjId"];
if (!string.IsNullOrEmpty(text))
{
DataTable taskInfo = BudContractTask.GetTaskInfo(text, string.Empty, string.Empty, string.Empty);
this.gvBudget.DataSource = taskInfo;
this.gvBudget.DataBind();
}
}
private string GetParentId(string taskId)
{
BudContractTaskService budContractTaskService = new BudContractTaskService();
BudContractTask byId = budContractTaskService.GetById(taskId);
if (byId != null)
{
return(byId.ParentId);
}
return(string.Empty);
}
public void BindGv()
{
BudContractTaskAudit modelById = BudContractTaskAudit.GetModelById(this.ContractTaskAuditId);
if (modelById != null)
{
DataTable taskInfo = BudContractTask.GetTaskInfo(modelById.PrjId, string.Empty, string.Empty, string.Empty);
this.gvBudget.DataSource = taskInfo;
this.gvBudget.DataBind();
this.hfldPrjId.Value = modelById.PrjId;
}
}
public void BindGv()
{
if (this.month.Length == 1)
{
this.month = this.month.PadLeft(2, '0');
}
BudContractTask.GetTaskInfo(this.prjId, this.type, this.year, this.month);
DataTable allTask = BudContractTask.GetAllTask(this.prjId, this.type, this.year, this.month);
this.gvBudget.DataSource = allTask;
this.gvBudget.DataBind();
}
private void DataBindBudget()
{
string text = base.Request["prjId"];
string contractID = base.Request["ContractId"];
if (!string.IsNullOrEmpty(text))
{
DataTable conByParent = BudContractTask.GetConByParent(text, contractID, string.Empty, string.Empty, string.Empty, string.Empty, 0);
this.gvBudget.DataSource = conByParent;
this.gvBudget.DataBind();
}
}
public void UpdateDetail()
{
BudConModify conModify = this.budModifySev.GetByConInModifyID(this.hfldconModifyID.Value);
List <BudConModifyTask> list = (
from r in this.conModifyTaskSer
where r.ModifyId == conModify.ModifyId
select r).ToList <BudConModifyTask>();
foreach (BudConModifyTask modifyTask in list)
{
BudContractTask budContractTask = (
from r in this.conTaskSev
where r.TaskId == modifyTask.TaskId
select r).FirstOrDefault <BudContractTask>();
if (budContractTask.ModifyType == "0")
{
this.conTaskSev.Delete(budContractTask);
}
else
{
budContractTask.EndDate = modifyTask.EndDate;
budContractTask.StartDate = modifyTask.StartDate;
budContractTask.TaskCode = modifyTask.ModifyTaskCode;
budContractTask.TaskName = modifyTask.ModifyTaskContent;
budContractTask.Unit = modifyTask.Unit;
budContractTask.Total = new decimal?(Convert.ToDecimal(budContractTask.Total) - modifyTask.Total);
budContractTask.InputDate = DateTime.Now;
budContractTask.IsValid = new bool?(false);
budContractTask.Note = modifyTask.Note;
budContractTask.OrderNumber = modifyTask.OrderNumber;
budContractTask.ParentId = modifyTask.ParentId;
budContractTask.PrjId = modifyTask.PrjId2;
budContractTask.Quantity = Convert.ToDecimal(budContractTask.Quantity) - modifyTask.Quantity;
budContractTask.TaskId = modifyTask.TaskId;
budContractTask.ModifyId = null;
budContractTask.ModifyType = "1";
if (budContractTask.Quantity != 0m)
{
budContractTask.UnitPrice = budContractTask.Total / budContractTask.Quantity;
}
budContractTask.TaskType = string.Empty;
budContractTask.InputUser = PageHelper.QueryUser(this, base.UserCode);
budContractTask.FeatureDescription = modifyTask.FeatureDescription;
budContractTask.ConstructionPeriod = modifyTask.ConstructionPeriod;
budContractTask.MainMaterial = new decimal?(Convert.ToDecimal(budContractTask.MainMaterial) - Convert.ToDecimal(modifyTask.MainMaterial));
budContractTask.Labor = new decimal?(Convert.ToDecimal(budContractTask.Labor) - Convert.ToDecimal(modifyTask.Labor));
budContractTask.SubMaterial = new decimal?(Convert.ToDecimal(budContractTask.SubMaterial) - Convert.ToDecimal(modifyTask.SubMaterial));
this.conTaskSev.Update(budContractTask);
}
}
}
protected string GetTaskCode(string taskId)
{
string result = string.Empty;
BudContractTaskService budContractTaskService = new BudContractTaskService();
BudContractTask byId = budContractTaskService.GetById(taskId);
if (byId != null)
{
result = byId.TaskCode;
}
else
{
BudConModifyTask byId2 = this.conModifyTaskSer.GetById(taskId);
if (byId2 != null)
{
result = byId2.ModifyTaskCode;
}
}
return(result);
}
protected void SaveTask()
{
List <BudConModifyTask> list = (
from r in this.conModifyTaskSer
where r.ModifyId == this.hfldconBudModifyID.Value
select r).ToList <BudConModifyTask>();
for (int i = 0; i < list.Count; i++)
{
BudConModifyTask entity = list[i];
BudContractTask budContractTask = (
from r in this.conTaskSev
where r.TaskId == entity.TaskId
select r).FirstOrDefault <BudContractTask>();
if (budContractTask != null && entity.ModifyType == 0)
{
BudContractTask budContractTask2 = new BudContractTask();
budContractTask2.EndDate = entity.EndDate;
budContractTask2.StartDate = entity.StartDate;
budContractTask2.TaskCode = entity.ModifyTaskCode;
budContractTask2.TaskName = entity.ModifyTaskContent;
budContractTask2.Unit = entity.Unit;
budContractTask2.Total = new decimal?(entity.Total);
budContractTask2.InputDate = DateTime.Now;
budContractTask2.IsValid = new bool?(false);
budContractTask2.Note = entity.Note;
budContractTask2.OrderNumber = entity.OrderNumber;
budContractTask2.ParentId = entity.ParentId;
budContractTask2.PrjId = entity.PrjId2;
budContractTask2.Quantity = entity.Quantity;
budContractTask2.TaskId = entity.TaskId;
budContractTask2.ModifyId = entity.ModifyId;
budContractTask2.ModifyType = entity.ModifyType.ToString();
if (budContractTask2.Quantity != 0m)
{
budContractTask2.UnitPrice = budContractTask2.Total / budContractTask2.Quantity;
}
budContractTask2.TaskType = string.Empty;
budContractTask2.InputUser = PageHelper.QueryUser(this, base.UserCode);
budContractTask2.FeatureDescription = entity.FeatureDescription;
budContractTask2.ConstructionPeriod = entity.ConstructionPeriod;
budContractTask2.SubMaterial = entity.SubMaterial;
budContractTask2.MainMaterial = entity.MainMaterial;
budContractTask2.Labor = entity.Labor;
this.conTaskSev.Delete(budContractTask);
this.conTaskSev.Add(budContractTask2);
}
if (budContractTask == null && entity.ModifyType == 0)
{
BudContractTask budContractTask3 = new BudContractTask();
budContractTask3.EndDate = entity.EndDate;
budContractTask3.StartDate = entity.StartDate;
budContractTask3.TaskCode = entity.ModifyTaskCode;
budContractTask3.TaskName = entity.ModifyTaskContent;
budContractTask3.Unit = entity.Unit;
budContractTask3.Total = new decimal?(entity.Total);
budContractTask3.InputDate = DateTime.Now;
budContractTask3.IsValid = new bool?(false);
budContractTask3.Note = entity.Note;
budContractTask3.OrderNumber = this.GetModifyOrderNumber(entity.OrderNumber, entity.ParentId);
budContractTask3.ParentId = entity.ParentId;
budContractTask3.PrjId = entity.PrjId2;
budContractTask3.Quantity = entity.Quantity;
budContractTask3.TaskId = entity.TaskId;
budContractTask3.ModifyId = entity.ModifyId;
budContractTask3.ModifyType = entity.ModifyType.ToString();
if (budContractTask3.Quantity != 0m)
{
budContractTask3.UnitPrice = budContractTask3.Total / budContractTask3.Quantity;
}
budContractTask3.TaskType = string.Empty;
budContractTask3.InputUser = PageHelper.QueryUser(this, base.UserCode);
budContractTask3.FeatureDescription = entity.FeatureDescription;
budContractTask3.ConstructionPeriod = entity.ConstructionPeriod;
budContractTask3.SubMaterial = entity.SubMaterial;
budContractTask3.MainMaterial = entity.MainMaterial;
budContractTask3.Labor = entity.Labor;
this.conTaskSev.Add(budContractTask3);
}
if (entity.ModifyType == 1)
{
budContractTask.EndDate = entity.EndDate;
budContractTask.StartDate = entity.StartDate;
budContractTask.Total = new decimal?(Convert.ToDecimal(budContractTask.Total) + entity.Total);
budContractTask.InputDate = DateTime.Now;
budContractTask.IsValid = new bool?(false);
budContractTask.Note = entity.Note;
budContractTask.OrderNumber = entity.OrderNumber;
budContractTask.ParentId = entity.ParentId;
budContractTask.PrjId = entity.PrjId2;
budContractTask.Quantity = Convert.ToDecimal(budContractTask.Quantity) + entity.Quantity;
budContractTask.TaskId = entity.TaskId;
budContractTask.ModifyId = entity.ModifyId;
budContractTask.ModifyType = entity.ModifyType.ToString();
if (budContractTask.Quantity != 0m)
{
budContractTask.UnitPrice = budContractTask.Total / budContractTask.Quantity;
}
budContractTask.TaskType = string.Empty;
budContractTask.InputUser = PageHelper.QueryUser(this, base.UserCode);
budContractTask.FeatureDescription = entity.FeatureDescription;
budContractTask.ConstructionPeriod = entity.ConstructionPeriod;
budContractTask.MainMaterial = new decimal?(Convert.ToDecimal(budContractTask.MainMaterial) + Convert.ToDecimal(entity.MainMaterial));
budContractTask.Labor = new decimal?(Convert.ToDecimal(budContractTask.Labor) + Convert.ToDecimal(entity.Labor));
budContractTask.SubMaterial = new decimal?(Convert.ToDecimal(budContractTask.SubMaterial) + Convert.ToDecimal(entity.SubMaterial));
this.conTaskSev.Update(budContractTask);
}
}
}
public void GvbudModify_RowDataBound(object sender, GridViewRowEventArgs e)
{
BudContractTask budContractTask = new BudContractTask();
if (e.Row.RowType == DataControlRowType.DataRow)
{
string value = this.GvbudModify.DataKeys[e.Row.RowIndex]["ModifyTaskId"].ToString();
e.Row.Attributes["id"] = value;
e.Row.Attributes["guid"] = value;
string TaskID = this.GvbudModify.DataKeys[e.Row.RowIndex]["TaskId"].ToString();
e.Row.Attributes["TaskId"] = TaskID;
string text = this.GvbudModify.DataKeys[e.Row.RowIndex]["ModifyType"].ToString();
string text2 = this.GvbudModify.DataKeys[e.Row.RowIndex]["Quantity"].ToString();
string text3 = this.GvbudModify.DataKeys[e.Row.RowIndex]["Total"].ToString();
e.Row.Attributes["ModifyType"] = text;
if (text == "1")
{
BudConModify conModify = this.budModifySev.GetByConInModifyID(this.hfldconModifyID.Value);
BudConModifyTask budConModifyTask = null;
if (conModify != null)
{
budConModifyTask = (
from r in this.conModifyTaskSer
where r.ModifyId == conModify.ModifyId && r.TaskId == TaskID
select r).FirstOrDefault <BudConModifyTask>();
}
budContractTask = (
from r in this.conTaskSev
where r.TaskId == TaskID
select r).FirstOrDefault <BudContractTask>();
if (budContractTask != null)
{
e.Row.Cells[2].Text = budContractTask.TaskCode;
e.Row.Cells[10].Text = budContractTask.UnitPrice.ToString();
if (!string.IsNullOrEmpty(text2) && Convert.ToDecimal(text2) != 0m)
{
e.Row.Cells[9].Style.Add("color", "red");
e.Row.Cells[11].Style.Add("color", "red");
}
if (!string.IsNullOrEmpty(text2))
{
if (budConModifyTask != null)
{
e.Row.Cells[12].Text = (budContractTask.Quantity - budConModifyTask.Quantity + Convert.ToDecimal(text2)).ToString();
}
else
{
e.Row.Cells[12].Text = (budContractTask.Quantity + Convert.ToDecimal(text2)).ToString();
}
}
else
{
e.Row.Cells[12].Text = budContractTask.Quantity.ToString();
}
if (string.IsNullOrEmpty(text3))
{
e.Row.Cells[13].Text = budContractTask.Total.ToString();
return;
}
if (budConModifyTask != null)
{
e.Row.Cells[13].Text = (budContractTask.Total - budConModifyTask.Total + Convert.ToDecimal(text3)).ToString();
return;
}
e.Row.Cells[13].Text = (budContractTask.Total + Convert.ToDecimal(text3)).ToString();
return;
}
}
else
{
e.Row.Style.Add("color", "red");
e.Row.Cells[12].Text = text2;
e.Row.Cells[13].Text = text3;
}
}
}
protected void btnImport_Click(object sender, System.EventArgs e)
{
this.taskArray = this.hfldExcelColumns.Value.Split(new char[]
{
','
});
this.resourceArray = this.hfldResource.Value.Split(new char[]
{
','
});
this.hfldExcelColumns.Value = string.Empty;
this.hfldResource.Value = string.Empty;
if (this.ViewState["ExcelName"] != null && !string.IsNullOrEmpty(this.ViewState["ExcelName"].ToString()))
{
bool flag = true;
if (string.IsNullOrEmpty(this.taskId))
{
this.dtWBS = (this.ViewState["dtwbs"] as DataTable);
if (this.dtWBS.Rows.Count > 0)
{
BudContractTask.ClearByPrjId(this.prjId);
}
}
else
{
flag = (BudContractTask.GetById(this.taskId) != null);
}
if (flag)
{
this.dtWBS = (this.ViewState["dtwbs"] as DataTable);
BudTaskServices budTaskServices = new BudTaskServices(this.taskId, this.prjId, this.version, this.dtWBS);
bool flag2 = false;
System.Collections.Generic.IDictionary <string, int> relation = ExcelUtility.GetRelation(this.taskArray);
int num = -1;
int num2 = -1;
string str = string.Empty;
foreach (System.Collections.Generic.KeyValuePair <string, int> current in relation)
{
string key;
if ((key = current.Key) != null)
{
if (!(key == "TaskCode"))
{
if (key == "SerialNo")
{
num = current.Value;
}
}
else
{
num2 = current.Value;
}
}
}
if (num != -1)
{
str = this.dtWBS.Columns[num].ColumnName;
this.dtWBS.DefaultView.Sort = str + " DESC";
for (int i = 1; i < this.dtWBS.Rows.Count; i++)
{
if (this.dtWBS.Rows[i][num].ToString().Trim() == this.dtWBS.Rows[i - 1][num].ToString().Trim())
{
flag2 = true;
break;
}
}
}
else
{
if (num2 != -1)
{
str = this.dtWBS.Columns[num2].ColumnName;
this.dtWBS.DefaultView.Sort = str + " DESC";
for (int j = 1; j < this.dtWBS.Rows.Count; j++)
{
if (this.dtWBS.Rows[j][num2].ToString().Trim() == this.dtWBS.Rows[j - 1][num2].ToString().Trim())
{
flag2 = true;
break;
}
}
}
}
if (flag2)
{
base.RegisterScript("top.ui.alert('导入失败!\\n导入的Excel中有节点的序号出现重复，请修改！');");
return;
}
if (num == -1 && num2 != -1)
{
foreach (DataRow dataRow in this.dtWBS.Rows)
{
string code = (dataRow[num2] == null) ? "" : dataRow[num2].ToString();
flag2 = BudContractTask.CheckCode(code, this.prjId);
if (flag2)
{
break;
}
}
}
if (!flag2)
{
this.inputUser = PageHelper.QueryUser(this, base.UserCode);
int num3 = budTaskServices.ConverConTaskList(this.taskArray, this.inputUser, this.errors);
this.AddResource();
string text = "成功";
if (num3 == 0)
{
text = "失败";
}
string text2 = string.Empty;
if (this.errors.Count > 0)
{
this.ViewState["errors"] = this.errors;
this.ShowErrors();
text2 = "\\n部分节点导入失败,详见“警告信息”！";
}
else
{
this.CloseSkip();
}
base.RegisterScript(string.Concat(new string[]
{
"top.ui.alert('Excel导入",
text,
"！",
text2,
"');"
}));
base.RegisterScript("top.ui._contractTask.location.href = top.ui._contractTask.location.href;");
return;
}
base.RegisterScript("top.ui.alert('导入失败!\\n导入的Excel中有节点的任务编码与已有的节点出现重复，请修改！');");
base.RegisterScript("top.ui._contractTask.location.href = top.ui._contractTask.location.href;");
return;
}
else
{
base.RegisterScript("top.ui.alert('Excel导入失败！\\n你选择要导入的上级节点已不存在！');");
base.RegisterScript("top.ui._contractTask.location.href = top.ui._contractTask.location.href;");
}
}
}
protected void btnDel_Click(object sender, EventArgs e)
{
BudConModifyService budConModifyService = new BudConModifyService();
BudConModifyTaskService budConModifyTaskService = new BudConModifyTaskService();
BudContractTaskService budContractTaskService = new BudContractTaskService();
List <string> list = new List <string>();
using (SqlConnection sqlConnection = new SqlConnection(SqlHelper.ConnectionString))
{
sqlConnection.Open();
SqlTransaction sqlTransaction = sqlConnection.BeginTransaction();
try
{
foreach (GridViewRow gridViewRow in this.gvConract.Rows)
{
CheckBox checkBox = gridViewRow.FindControl("cbBox") as CheckBox;
if (checkBox != null && checkBox.Checked)
{
int num = this.incometModifyBll.Delete(sqlTransaction, checkBox.ToolTip);
if (num > 0)
{
BudConModify budConModify = budConModifyService.GetByConInModifyID(checkBox.ToolTip);
if (budConModify != null)
{
this.DeleteInModifyTaskAndMeasure(budConModify.ModifyId);
List <string> list2 = (
from r in budConModifyTaskService
where r.ModifyId == budConModify.ModifyId
select r.TaskId).ToList <string>();
foreach (string taskId in list2)
{
BudContractTask budContractTask = (
from r in budContractTaskService
where r.TaskId == taskId
select r).FirstOrDefault <BudContractTask>();
BudConModifyTask budConModifyTask = (
from r in budConModifyTaskService
where r.TaskId == taskId && r.ModifyId == budConModify.ModifyId
select r).FirstOrDefault <BudConModifyTask>();
if (budContractTask != null)
{
if (budContractTask.ModifyType == "0")
{
budContractTaskService.Delete(budContractTask);
}
else
{
budContractTask.EndDate = budConModifyTask.EndDate;
budContractTask.StartDate = budConModifyTask.StartDate;
budContractTask.TaskCode = budConModifyTask.ModifyTaskCode;
budContractTask.TaskName = budConModifyTask.ModifyTaskContent;
budContractTask.Unit = budConModifyTask.Unit;
budContractTask.Total = new decimal?(Convert.ToDecimal(budContractTask.Total) - budConModifyTask.Total);
budContractTask.InputDate = DateTime.Now;
budContractTask.IsValid = new bool?(false);
budContractTask.Note = budConModifyTask.Note;
budContractTask.OrderNumber = budConModifyTask.OrderNumber;
budContractTask.ParentId = budConModifyTask.ParentId;
budContractTask.PrjId = budConModifyTask.PrjId2;
budContractTask.Quantity = Convert.ToDecimal(budContractTask.Quantity) - budConModifyTask.Quantity;
budContractTask.TaskId = budConModifyTask.TaskId;
budContractTask.ModifyId = null;
budContractTask.ModifyType = "1";
if (budContractTask.Quantity != 0m)
{
budContractTask.UnitPrice = budContractTask.Total / budContractTask.Quantity;
}
budContractTask.TaskType = string.Empty;
budContractTask.InputUser = PageHelper.QueryUser(this, base.UserCode);
budContractTask.FeatureDescription = budConModifyTask.FeatureDescription;
budContractTask.ConstructionPeriod = budConModifyTask.ConstructionPeriod;
budContractTask.MainMaterial = new decimal?(Convert.ToDecimal(budContractTask.MainMaterial) - Convert.ToDecimal(budConModifyTask.MainMaterial));
budContractTask.Labor = new decimal?(Convert.ToDecimal(budContractTask.Labor) - Convert.ToDecimal(budConModifyTask.Labor));
budContractTask.SubMaterial = new decimal?(Convert.ToDecimal(budContractTask.SubMaterial) - Convert.ToDecimal(budConModifyTask.SubMaterial));
budContractTaskService.Update(budContractTask);
}
}
}
budConModifyTaskService.DelModifyTask(budConModify.ModifyId);
list.Add(budConModify.ModifyId);
budConModifyService.Delete(list);
}
base.RegisterScript("top.ui.show('数据删除成功！');");
base.RegisterScript("window.location = window.location");
}
}
}
sqlTransaction.Commit();
this.BindGv();
}
catch (Exception)
{
sqlTransaction.Rollback();
base.RegisterScript("alert('系统提示：\\n\\n对不起添加失败！');");
}
}
}
