protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
DataTable dataTable = new DataTable();
if (string.Compare(this.action, "Add", true) == 0)
{
this.InintAddState();
this.modifyStockAction = "add";
dataTable = this.purchaseStock.GetPurchaseStockByContractId(this.contractId, false);
DataColumn dataColumn = new DataColumn("ModifyStockId", typeof(string));
dataColumn.DefaultValue = string.Empty;
dataTable.Columns.Add(dataColumn);
this.hfldBudModifyId.Value = Guid.NewGuid().ToString();
}
else
{
this.InitUpdateState();
this.modifyStockAction = "edit";
dataTable = this.purchaseStock.GetModifyStockByContractId(this.contractId, this.modifyId);
ConPayoutModifyService conPayoutModifyService = new ConPayoutModifyService();
ConPayoutModify byId = conPayoutModifyService.GetById(this.modifyId);
if (byId != null && !string.IsNullOrEmpty(byId.BudModifyId))
{
this.hfldBudModifyId.Value = byId.BudModifyId;
}
else
{
this.hfldBudModifyId.Value = Guid.NewGuid().ToString();
}
this.InitBudTask();
}
this.ViewState["modifyStockAction"] = this.modifyStockAction;
this.ViewState["resource"] = dataTable;
this.DataBindPurchaseplanStock();
string conPurchasePcode = this.purchase.GetConPurchasePcode(this.contractId);
if (string.IsNullOrEmpty(conPurchasePcode))
{
this.divPurchase.Style.Add("display", "none");
}
this.FileLink1.MID = 1902;
this.FileLink1.FID = this.hfldModifyId.Value;
this.FileLink1.Type = 1;
this.hfldIsWBSRelevance.Value = ConfigurationManager.AppSettings["IsWBSRelevance"];
List <BudModifyTask> list = (
from mt in this.modifyTaskSer
where mt.ModifyId == this.hfldBudModifyId.Value
select mt).ToList <BudModifyTask>();
if (this.hfldIsWBSRelevance.Value == "1")
{
foreach (BudModifyTask current in list)
{
this.BindModifyTaskRes(current.ModifyTaskId);
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (string.Compare(this.action, "Add", true) == 0)
{
this.AddContractModify();
ConPayoutModifyService conPayoutModifyService = new ConPayoutModifyService();
ConPayoutModify byId = conPayoutModifyService.GetById(this.hfldModifyId.Value);
byId.BudModifyId = this.hfldBudModifyId.Value;
conPayoutModifyService.Update(byId);
}
else
{
if (string.Compare(this.action, "Update", true) == 0)
{
this.UpdateContractModify();
}
}
this.UpdateModifyTask();
}
public void CommitEvent(object key)
{
BudModifyService service = new BudModifyService();
BudTaskService service2 = new BudTaskService();
BudModifyTaskService service3 = new BudModifyTaskService();
BudTaskResourceService service4 = new BudTaskResourceService();
ConPayoutModifyService service5 = new ConPayoutModifyService();
string modifyId = key.ToString();
BudModify budmodify = (from r in service
where r.ModifyId == modifyId
select r).FirstOrDefault <BudModify>();
ConPayoutModify item = (from r in service5
where r.BudModifyId == modifyId
select r).FirstOrDefault <ConPayoutModify>();
if (item != null)
{
item.FlowState = 1;
service5.Update(item);
}
using (List <BudModifyTask> .Enumerator enumerator = (from p in service3
where p.ModifyId == budmodify.ModifyId
select p).ToList <BudModifyTask>().GetEnumerator())
{
BudModifyTask taskx;
while (enumerator.MoveNext())
{
taskx = enumerator.Current;
cn.justwin.Domain.Entities.BudTask task = (from p in service2
where p.TaskId == taskx.TaskId
select p).FirstOrDefault <cn.justwin.Domain.Entities.BudTask>();
if ((task != null) && (budmodify.Flowstate == 1))
{
if (taskx.ModifyType == 0)
{
task.IsValid = true;
service2.Update(task);
service3.UpdateTotal2(taskx.ModifyTaskId);
}
if ((task.ModifyId != task.ModifyId) || (taskx.ModifyType == 1))
{
task.ModifyId = task.ModifyId;
if (!task.Total2.HasValue)
{
task.Total2 = 0;
}
if (!task.Quantity.HasValue)
{
task.Quantity = 0;
}
task.Total2 = new decimal?(Convert.ToDecimal(task.Total2) + Convert.ToDecimal(task.Total2));
task.Quantity = new decimal?(Convert.ToDecimal(task.Quantity) + Convert.ToDecimal(task.Quantity));
if (task.Quantity != 0M)
{
task.UnitPrice = task.Total2 / task.Quantity;
}
service2.Update(task);
service3.UpdateTotal2(taskx.ModifyTaskId);
}
}
}
}
if (ConfigHelper.Get("BudgetRequireDiff") != "0")
{
string str2 = ConfigHelper.Get("IsWBSRelevance");
BudModify byId = service.GetById(key.ToString());
service2.DeleteYearMonthByPrj(byId.PrjId);
IList <cn.justwin.Domain.Entities.BudTask> byProject = service2.GetByProject(byId.PrjId, 0x3e7);
IList <int> years = service2.GetYears(byId.PrjId);
if (years != null)
{
foreach (int num in years)
{
IList <cn.justwin.Domain.Entities.BudTask> yearTask = service2.GetYearTask(byProject, num);
foreach (cn.justwin.Domain.Entities.BudTask task2 in yearTask)
{
service2.Add(task2);
}
foreach (int num2 in service2.GetMonths(yearTask, num))
{
foreach (cn.justwin.Domain.Entities.BudTask task3 in service2.GetMonthTasks(yearTask, num, num2))
{
service2.Add(task3);
}
}
}
if (str2 == "1")
{
service4.AddTaskResource(byId.PrjId);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
this.hfldIsWBSRelevance.Value = this.isWBSRelevance;
List <BudModifyTask> list = new List <BudModifyTask>();
DataTable dataTable = new DataTable();
if (string.Compare(this.action, "Add", true) == 0)
{
this.InintAddState();
this.modifyStockAction = "add";
dataTable = this.purchaseStock.GetPurchaseStockByContractId(this.contractId, false);
DataColumn dataColumn = new DataColumn("ModifyStockId", typeof(string));
dataColumn.DefaultValue = string.Empty;
dataTable.Columns.Add(dataColumn);
this.hfldBudModifyId.Value = Guid.NewGuid().ToString();
}
else
{
this.InitUpdateState();
this.modifyStockAction = "edit";
dataTable = this.purchaseStock.GetModifyStockByContractId(this.contractId, this.modifyId);
ConPayoutModifyService conPayoutModifyService = new ConPayoutModifyService();
ConPayoutModify byId = conPayoutModifyService.GetById(this.modifyId);
if (byId != null && !string.IsNullOrEmpty(byId.BudModifyId))
{
this.hfldBudModifyId.Value = byId.BudModifyId;
}
else
{
this.hfldBudModifyId.Value = Guid.NewGuid().ToString();
}
this.hfldModifyId.Value = this.modifyId;
list = (
from mt in this.modifyTaskSer
where mt.ModifyId == this.hfldBudModifyId.Value
select mt).ToList <BudModifyTask>();
this.hfldAllModifyTaskJson.Value = JsonNetWrap.SerializeObject(list);
}
this.ViewState["modifyStockAction"] = this.modifyStockAction;
this.ViewState["resource"] = dataTable;
this.DataBindPurchaseplanStock();
string conPurchasePcode = this.purchase.GetConPurchasePcode(this.contractId);
if (string.IsNullOrEmpty(conPurchasePcode))
{
this.divPurchase.Style.Add("display", "none");
}
this.FileLink1.MID = 1902;
this.FileLink1.FID = this.hfldModifyId.Value;
this.FileLink1.Type = 1;
this.BindGv(list);
if (this.hfldIsWBSRelevance.Value == "1")
{
using (List <BudModifyTask> .Enumerator enumerator = list.GetEnumerator())
{
while (enumerator.MoveNext())
{
BudModifyTask current = enumerator.Current;
this.BindModifyTaskRes(current.ModifyTaskId);
}
return;
}
}
base.Request.Cookies.Remove(this.hfldModifyId.Value);
List <BudModifyTaskRes> t = (
from mtss in this.modifyTaskResSer
where mtss.ModifyId == this.hfldModifyId.Value
select mtss).ToList <BudModifyTaskRes>();
string value = JsonHelper.JsonSerializer <List <BudModifyTaskRes> >(t);
HttpCookie httpCookie = new HttpCookie(this.hfldModifyId.Value);
httpCookie.Value = value;
base.Response.Cookies.Add(httpCookie);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
int count = (
from modify in this.modifySer
where modify.PrjId == this.hdnProjectCode.Value.Trim() && modify.ModifyCode == this.txtModifyCode.Text.Trim()
select modify).ToList <BudModify>().Count;
if (string.Compare(this.action, "Add", true) == 0)
{
if (count > 0)
{
base.RegisterScript("top.ui.show('此编码已经存在!');");
return;
}
this.AddContractModify();
ConPayoutModifyService conPayoutModifyService = new ConPayoutModifyService();
ConPayoutModify byId = conPayoutModifyService.GetById(this.hfldModifyId.Value);
byId.BudModifyId = this.hfldBudModifyId.Value;
conPayoutModifyService.Update(byId);
try
{
BudModify model = this.GetModel(null);
this.modifySer.Add(model);
this.SaveModifyTask();
this.SaveTask();
if (this.hfldIsWBSRelevance.Value == "0")
{
this.SaveModifyTaskResByModifyId(this.hfldModifyId.Value);
}
base.RegisterScript("top.ui.tabSuccess({ parentName: 'ModifyEdit' });");
return;
}
catch
{
base.RegisterScript("top.ui.show('添加失败!');");
return;
}
}
if (string.Compare(this.action, "Update", true) == 0)
{
this.UpdateContractModify();
BudModify byId2 = this.modifySer.GetById(this.hfldBudModifyId.Value);
if (byId2 != null && byId2.ModifyCode != this.txtModifyCode.Text.Trim() && count > 0)
{
base.RegisterScript("top.ui.show('此编码已经存在!');");
return;
}
try
{
this.modifySer.Update(this.GetModel(byId2));
this.modifyTaskSer.DelModifyTask(this.hfldBudModifyId.Value);
this.SaveModifyTask();
this.SaveTask();
if (this.hfldIsWBSRelevance.Value == "0")
{
this.SaveModifyTaskResByModifyId(this.hfldBudModifyId.Value);
}
base.RegisterScript("top.ui.tabSuccess({ parentName: 'ModifyEdit'});");
}
catch
{
base.RegisterScript("top.ui.show('编辑失败!');");
}
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
List <string> listFromJson = JsonHelper.GetListFromJson(this.hfldModifyId.Value);
foreach (string modifyId in listFromJson)
{
ConPayoutModify payOutModify = (
from r in this.payOutSer
where r.ModifyID == modifyId
select r).FirstOrDefault <ConPayoutModify>();
BudModify budModify = (
from r in this.modifySer
where r.ModifyId == payOutModify.BudModifyId
select r).FirstOrDefault <BudModify>();
if (budModify != null)
{
List <BudTask> list = (
from r in this.budTaskSer
where r.ModifyId == budModify.ModifyId
select r).ToList <BudTask>();
foreach (BudTask model in list)
{
BudModifyTask budModifyTask = (
from r in this.budModifyTaskSer
where r.TaskId == model.TaskId
select r).FirstOrDefault <BudModifyTask>();
if (budModifyTask.ModifyType == 0)
{
this.budTaskSer.Delete(model);
this.budModifyTaskSer.UpdateTotal2(budModifyTask.ModifyTaskId);
this.budModifyTaskSer.Delete(budModifyTask);
}
else
{
model.ModifyId = budModifyTask.ModifyId;
model.Total2 -= budModifyTask.Total2;
model.Quantity -= budModifyTask.Quantity;
if (model.Quantity != 0m)
{
model.UnitPrice = model.Total2 / model.Quantity;
}
this.budTaskSer.Update(model);
this.budModifyTaskSer.UpdateTotal2(budModifyTask.ModifyTaskId);
this.budModifyTaskSer.Delete(budModifyTask);
}
}
this.modifySer.Delete(budModify);
}
}
try
{
//foreach (string current in listFromJson)
//{
// SelfEventAction.SuperDelete(current, "Con_Payout_Modify", "FlowState");
//}
this.payoutModify.Delete(listFromJson);
base.RegisterScript("window.location = window.location;");
}
catch (Exception)
{
base.RegisterScript("alert('系统提示：\\n\\n删除失败！');");
}
}
public void CommitEvent(object key)
{
string primarykey = key.ToString();
ConPayoutModify payOutModify = (from r in this.payOutSer
where r.ModifyID == primarykey
select r).FirstOrDefault <ConPayoutModify>();
BudModify budModify = (from r in this.modifySer
where r.ModifyId == payOutModify.BudModifyId
select r).FirstOrDefault <BudModify>();
budModify.Flowstate = 1;
this.modifySer.Update(budModify);
using (List <BudModifyTask> .Enumerator enumerator = (from p in this.budModifyTaskSer
where p.ModifyId == budModify.ModifyId
select p).ToList <BudModifyTask>().GetEnumerator())
{
BudModifyTask task;
while (enumerator.MoveNext())
{
task = enumerator.Current;
BudTask item = (from p in this.budTaskSer
where p.TaskId == task.TaskId
select p).FirstOrDefault <BudTask>();
if ((item != null) && (budModify.Flowstate == 1))
{
if (task.ModifyType == 0)
{
item.IsValid = true;
this.budTaskSer.Update(item);
this.budModifyTaskSer.UpdateTotal2(task.ModifyTaskId);
}
if (item.ModifyId != task.ModifyId)
{
item.ModifyId = task.ModifyId;
item.Total2 += task.Total2;
decimal?quantity = item.Quantity;
decimal num = task.Quantity;
item.Quantity = quantity.HasValue ? new decimal?(quantity.GetValueOrDefault() + num) : null;
if (item.Quantity != 0M)
{
item.UnitPrice = item.Total2 / item.Quantity;
}
this.budTaskSer.Update(item);
this.budModifyTaskSer.UpdateTotal2(task.ModifyTaskId);
}
}
}
}
string cmdText = string.Format(" SELECT * FROM Con_Modify_Stock where ModifyId='{0}' ", primarykey);
if (SqlHelper.ExecuteQuery(CommandType.Text, cmdText, null).Rows.Count != 0)
{
string str2 = string.Format("SELECT ModifyStock.*FROM Con_Modify_Stock ModifyStock\r\n INNER JOIN Sm_Purchase_Stock purchaseStock ON ModifyStock.purchaseId=purchaseStock.psid\r\n WHERE ModifyId='{0}'", primarykey);
DataTable table2 = SqlHelper.ExecuteQuery(CommandType.Text, str2, null);
string str3 = string.Format("SELECT purchaseStock.* FROM Sm_Purchase_Stock purchaseStock \r\n LEFT JOIN (SELECT *FROM Con_Modify_Stock where ModifyId='{0}') ModifyStock\r\n ON purchaseStock.psid=ModifyStock.purchaseId\r\n WHERE purchaseStock.pscode in (SELECT DISTINCT Pscode FROM Con_Modify_Stock WHERE ModifyId='{0}')\r\n AND ModifyStockId IS NULL", primarykey);
DataTable table3 = SqlHelper.ExecuteQuery(CommandType.Text, str3, null);
string str4 = string.Format("SELECT ModifyStock.* FROM Con_Modify_Stock ModifyStock\r\n LEFT JOIN Sm_Purchase_Stock purchaseStock ON ModifyStock.purchaseId=purchaseStock.psid\r\n WHERE ModifyId='{0}'AND psid IS NULL", primarykey);
DataTable table4 = SqlHelper.ExecuteQuery(CommandType.Text, str4, null);
using (SqlConnection connection = new SqlConnection(SqlHelper.ConnectionString))
{
connection.Open();
SqlTransaction trans = connection.BeginTransaction();
foreach (DataRow row in table2.Rows)
{
PurchaseStockModel model = new PurchaseStockModel {
psid = row["PurchaseId"].ToString(),
sprice = DBHelper.GetDecimal(row["Sprice"]),
number = DBHelper.GetDecimal(row["Quantity"]),
corp = DBHelper.GetString(row["Corp"])
};
if (row["ArrivalDate"] != null)
{
model.ArrivalDate = row["ArrivalDate"].ToString();
}
else
{
model.ArrivalDate = null;
}
model.pscode = row["Pscode"].ToString();
model.scode = row["Scode"].ToString();
this.purchaseSotck.Update(trans, model);
}
foreach (DataRow row2 in table3.Rows)
{
this.purchaseSotck.Delete(trans, row2["psid"].ToString());
}
foreach (DataRow row3 in table4.Rows)
{
PurchaseStockModel model2 = new PurchaseStockModel {
psid = row3["PurchaseId"].ToString(),
sprice = DBHelper.GetDecimal(row3["Sprice"]),
number = DBHelper.GetDecimal(row3["Quantity"]),
corp = DBHelper.GetString(row3["Corp"])
};
if (row3["ArrivalDate"] != null)
{
model2.ArrivalDate = row3["ArrivalDate"].ToString();
}
else
{
model2.ArrivalDate = null;
}
model2.pscode = row3["Pscode"].ToString();
model2.scode = row3["Scode"].ToString();
this.purchaseSotck.Add(trans, model2);
}
trans.Commit();
return;
}
}
string str5 = string.Format("\r\n\t\t\t\t\t\t\t\t\tSELECT PCode FROM Sm_Purchase purchase\r\n\t\t\t\t\t\t\t\t\tINNER JOIN Con_Payout_Modify payoutModify ON purchase.Contract=payoutModify.ContractId\r\n\t\t\t\t\t\t\t\t\tWHERE ModifyId='{0}' AND purchase.FlowState=1", primarykey);
DataTable table5 = SqlHelper.ExecuteQuery(CommandType.Text, str5, null);
if (table5.Rows.Count > 0)
{
using (SqlConnection connection2 = new SqlConnection(SqlHelper.ConnectionString))
{
connection2.Open();
SqlTransaction transaction2 = connection2.BeginTransaction();
foreach (DataRow row4 in table5.Rows)
{
this.purchaseSotck.DeleteByPscode(transaction2, row4["PCode"].ToString());
}
transaction2.Commit();
}
}
}
