/// <summary> /// 加载页面 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { btnClose.OnClientClick = ActiveWindow.GetHideReference(); this.CostManageId = Request.Params["CostManageId"]; this.CostManageItemId = Request.Params["CostManageItemId"]; this.drpInvestCostProject.DataTextField = "Text"; this.drpInvestCostProject.DataValueField = "Value"; this.drpInvestCostProject.DataSource = BLL.CostManageItemService.GetInvestCostProjectList(); this.drpInvestCostProject.DataBind(); if (!string.IsNullOrEmpty(this.CostManageItemId)) { Model.CostGoods_CostManageItem costManageItem = BLL.CostManageItemService.GetCostManageItemById(this.CostManageItemId); if (costManageItem != null) { this.CostManageId = costManageItem.CostManageId; this.drpInvestCostProject.SelectedValue = costManageItem.InvestCostProject; this.txtUseReason.Text = costManageItem.UseReason; if (costManageItem.Counts != null) { this.txtCount.Text = Convert.ToString(costManageItem.Counts); } if (costManageItem.PriceMoney != null) { this.txtPriceMoney.Text = Convert.ToString(costManageItem.PriceMoney); } this.txtTotalMoney.Text = Convert.ToString(costManageItem.Counts * costManageItem.PriceMoney); } } } }
/// <summary> /// 根据主键删除费用管理信息 /// </summary> /// <param name="costManageItemId"></param> public static void DeleteCostManageItemById(string costManageItemId) { Model.SUBHSSEDB db = Funs.DB; Model.CostGoods_CostManageItem costManageItem = db.CostGoods_CostManageItem.FirstOrDefault(e => e.CostManageItemId == costManageItemId); if (costManageItem != null) { db.CostGoods_CostManageItem.DeleteOnSubmit(costManageItem); db.SubmitChanges(); } }
/// <summary> /// 修改费用管理明细 /// </summary> /// <param name="costManageItem"></param> public static void UpdateCostManageItem(Model.CostGoods_CostManageItem costManageItem) { Model.SUBHSSEDB db = Funs.DB; Model.CostGoods_CostManageItem newCostManageItem = db.CostGoods_CostManageItem.FirstOrDefault(e => e.CostManageItemId == costManageItem.CostManageItemId); if (newCostManageItem != null) { newCostManageItem.CostManageId = costManageItem.CostManageId; newCostManageItem.InvestCostProject = costManageItem.InvestCostProject; newCostManageItem.UseReason = costManageItem.UseReason; newCostManageItem.Counts = costManageItem.Counts; newCostManageItem.PriceMoney = costManageItem.PriceMoney; newCostManageItem.AuditCounts = costManageItem.AuditCounts; newCostManageItem.AuditPriceMoney = costManageItem.AuditPriceMoney; newCostManageItem.Remark = costManageItem.Remark; db.SubmitChanges(); } }
/// <summary> /// 新增费用申请情况 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnNew_Click(object sender, EventArgs e) { //if (this.drpUnitId.SelectedValue == BLL.Const._Null) //{ // Alert.ShowInTop("请选择分包商!", MessageBoxIcon.Warning); // return; //} jerqueSaveMonthPlanList(); Model.CostGoods_CostManageItem costManageItem = new Model.CostGoods_CostManageItem { CostManageItemId = SQLHelper.GetNewID(typeof(Model.CostGoods_CostManageItem)) }; costManageItems.Add(costManageItem); this.Grid1.DataSource = costManageItems; this.Grid1.DataBind(); OutputSummaryData(); }
/// <summary> /// 添加费用管理明细 /// </summary> /// <param name="costManageItem"></param> public static void AddCostManageItem(Model.CostGoods_CostManageItem costManageItem) { Model.SUBHSSEDB db = Funs.DB; Model.CostGoods_CostManageItem newCostManageItem = new Model.CostGoods_CostManageItem { CostManageItemId = costManageItem.CostManageItemId, CostManageId = costManageItem.CostManageId, InvestCostProject = costManageItem.InvestCostProject, UseReason = costManageItem.UseReason, Counts = costManageItem.Counts, PriceMoney = costManageItem.PriceMoney, AuditCounts = costManageItem.AuditCounts, AuditPriceMoney = costManageItem.AuditPriceMoney, Remark = costManageItem.Remark }; db.CostGoods_CostManageItem.InsertOnSubmit(newCostManageItem); db.SubmitChanges(); }
/// <summary> /// 保存按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { Model.CostGoods_CostManageItem costManageItem = new Model.CostGoods_CostManageItem { CostManageId = this.CostManageId, InvestCostProject = this.drpInvestCostProject.SelectedValue, UseReason = this.txtUseReason.Text.Trim(), Counts = Funs.GetNewInt(this.txtCount.Text.Trim()), PriceMoney = Funs.GetNewDecimalOrZero(this.txtPriceMoney.Text.Trim()), }; if (!string.IsNullOrEmpty(this.CostManageItemId)) { costManageItem.CostManageItemId = this.CostManageItemId; BLL.CostManageItemService.UpdateCostManageItem(costManageItem); } else { this.CostManageItemId = SQLHelper.GetNewID(typeof(Model.CostGoods_CostManageItem)); costManageItem.CostManageItemId = this.CostManageItemId; BLL.CostManageItemService.AddCostManageItem(costManageItem); } PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); }
/// <summary> /// 检查并保存其他HSE管理活动集合 /// </summary> private void jerqueSaveMonthPlanList() { costManageItems.Clear(); JArray mergedData = Grid1.GetMergedData(); foreach (JObject mergedRow in mergedData) { string status = mergedRow.Value <string>("status"); JObject values = mergedRow.Value <JObject>("values"); int i = mergedRow.Value <int>("index"); Model.CostGoods_CostManageItem costManageItem = new Model.CostGoods_CostManageItem { CostManageItemId = this.Grid1.Rows[i].DataKeys[0].ToString(), InvestCostProject = values.Value <string>("InvestCostProject").ToString(), UseReason = values.Value <string>("UseReason").ToString(), Counts = Funs.GetNewIntOrZero(values.Value <string>("Counts").ToString()), PriceMoney = Funs.GetNewDecimalOrZero(values.Value <string>("PriceMoney").ToString()), AuditCounts = !string.IsNullOrEmpty(values.Value <string>("AuditCounts").ToString()) ? Funs.GetNewInt(values.Value <string>("AuditCounts").ToString()) : null, AuditPriceMoney = !string.IsNullOrEmpty(values.Value <string>("AuditPriceMoney").ToString()) ? Funs.GetNewDecimal(values.Value <string>("AuditPriceMoney").ToString()) : null }; costManageItems.Add(costManageItem); } }