protected void OpenForm(int formID) { FormTableAdapter taForm = new FormTableAdapter(); taForm.FillByID(this.InnerDS.Form, formID); FormDS.FormRow rowForm = this.InnerDS.Form[0]; FormMaterialTableAdapter taFormMaterial = new FormMaterialTableAdapter(); taFormMaterial.FillByID(this.InnerDS.FormMaterial, formID); FormDS.FormMaterialRow rowFormMaterial = this.InnerDS.FormMaterial[0]; //赋值 this.UCShop.ShopID = rowFormMaterial.ShopID.ToString(); this.FirstVolumeCtl.Text = rowFormMaterial.FirstVolume.ToString(); this.SecondVolumeCtl.Text = rowFormMaterial.SecondVolume.ToString(); this.ThirdVolumeCtl.Text = rowFormMaterial.ThirdVolume.ToString(); this.RemarkCtl.Text = rowFormMaterial.Remark; // 打开明细表 FormMaterialDetailTableAdapter taDetail = new FormMaterialDetailTableAdapter(); taDetail.FillByFormMaterialID(this.InnerDS.FormMaterialDetail, formID); }
public void UpdateFormMaterial(int FormID, SystemEnums.FormStatus StatusID, SystemEnums.FormType FormTypeID, int ShopID, int FirstVolume, int SecondVolume, int ThirdVolume, string Remark, string FlowTemplate) { SqlTransaction transaction = null; try { ////事务开始 transaction = TableAdapterHelper.BeginTransaction(this.TAForm); TableAdapterHelper.SetTransaction(this.TAFormMaterial, transaction); TableAdapterHelper.SetTransaction(this.TAFormMaterialDetail, transaction); FormDS.FormRow formRow = this.TAForm.GetDataByID(FormID)[0]; UtilityBLL utility = new UtilityBLL(); if (StatusID == SystemEnums.FormStatus.Awaiting) { string formTypeString = utility.GetFormTypeString((int)FormTypeID); formRow.FormNo = utility.GetFormNo(formTypeString); formRow.InTurnUserIds = "P"; //待改动 formRow.InTurnPositionIds = "P"; //待改动 } else { formRow.SetFormNoNull(); } formRow.StatusID = (int)StatusID; formRow.SubmitDate = DateTime.Now; formRow.LastModified = DateTime.Now; this.TAForm.Update(formRow); //处理申请表的内容 FormDS.FormMaterialRow formMaterialRow = this.TAFormMaterial.GetDataByID(FormID)[0]; formMaterialRow.ShopID = ShopID; formMaterialRow.FirstVolume = FirstVolume; formMaterialRow.SecondVolume = SecondVolume; formMaterialRow.ThirdVolume = ThirdVolume; formMaterialRow.Remark = Remark; this.TAFormMaterial.Update(formMaterialRow); //明细表 decimal totalAmount = 0;//计算总申请金额 foreach (FormDS.FormMaterialDetailRow detailRow in this.FormDataSet.FormMaterialDetail) { // 与父表绑定 if (detailRow.RowState != DataRowState.Deleted) { detailRow.FormMaterialID = formMaterialRow.FormMaterialID; totalAmount += detailRow.Amount; } } this.TAFormMaterialDetail.Update(this.FormDataSet.FormMaterialDetail); formMaterialRow.Amount = totalAmount; this.TAFormMaterial.Update(formMaterialRow); // 正式提交或草稿 if (StatusID == SystemEnums.FormStatus.Awaiting) { Dictionary <string, object> dic = new Dictionary <string, object>(); dic["Apply_Amount"] = totalAmount;//金额 APHelper AP = new APHelper(); new APFlowBLL().ApplyForm(AP, TAForm, null, formRow, formRow.OrganizationUnitID, FlowTemplate, StatusID, dic); } transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw new ApplicationException("Save Fail!" + ex.ToString()); } finally { transaction.Dispose(); } }
protected void Page_Load(object sender, EventArgs e) { base.Page_Load(sender, e); if (!this.IsPostBack) { PageUtility.SetContentTitle(this.Page, "广宣物资审批"); this.Page.Title = "广宣物资审批"; int formID = int.Parse(Request["ObjectId"]); this.ViewState["ObjectId"] = formID; FormDS.FormRow rowForm = this.MaterialApplyBLL.GetFormByID(formID)[0]; FormDS.FormMaterialRow rowFormMaterial = this.MaterialApplyBLL.GetFormMaterialByID(formID)[0]; if (rowForm.IsProcIDNull()) { ViewState["ProcID"] = ""; } else { ViewState["ProcID"] = rowForm.ProcID; } ViewState["OrganizationUnitID"] = rowForm.OrganizationUnitID; this.FormNoCtl.Text = rowForm.FormNo; this.ApplyDateCtl.Text = rowForm.SubmitDate.ToShortDateString(); AuthorizationDS.StuffUserRow applicant = new AuthorizationBLL().GetStuffUserById(rowForm.UserID); this.StuffNameCtl.Text = applicant.StuffName; this.PositionNameCtl.Text = new OUTreeBLL().GetPositionById(rowForm.PositionID).PositionName; if (new OUTreeBLL().GetOrganizationUnitById(rowForm.OrganizationUnitID) != null) { this.DepartmentNameCtl.Text = new OUTreeBLL().GetOrganizationUnitById(rowForm.OrganizationUnitID).OrganizationUnitName; } this.AttendDateCtl.Text = applicant.AttendDate.ToShortDateString(); ERS.ShopRow shop = new MasterDataBLL().GetShopByID(rowFormMaterial.ShopID); this.CustomerNameCtl.Text = new MasterDataBLL().GetCustomerById(shop.CustomerID).CustomerName; this.ShopNameCtl.Text = shop.ShopName; this.FirstVolumeCtl.Text = rowFormMaterial.FirstVolume.ToString("N"); this.SecondVolumeCtl.Text = rowFormMaterial.SecondVolume.ToString("N"); this.ThirdVolumeCtl.Text = rowFormMaterial.ThirdVolume.ToString("N"); this.AverageVolumeCtl.Text = rowFormMaterial.AverageVolume.ToString("N"); this.RemarkCtl.Text = rowFormMaterial.Remark; this.odsMaterialDetails.SelectParameters["FormMaterialID"].DefaultValue = rowFormMaterial.FormMaterialID.ToString(); //审批页面处理&按钮处理 AuthorizationDS.StuffUserRow stuffUser = (AuthorizationDS.StuffUserRow)Session["StuffUser"]; this.ViewState["StuffUserID"] = stuffUser.StuffUserId; if (rowForm.InTurnUserIds.Contains("P" + stuffUser.StuffUserId + "P")) { this.SubmitBtn.Visible = true; this.cwfAppCheck.IsView = false; this.ViewState["IsView"] = false; } else { this.SubmitBtn.Visible = false; this.cwfAppCheck.IsView = true; this.ViewState["IsView"] = true; } if (rowForm.StatusID == (int)SystemEnums.FormStatus.Rejected && ((AuthorizationDS.StuffUserRow)Session["StuffUser"]).StuffUserId == rowForm.UserID) { this.EditBtn.Visible = true; this.ScrapBtn.Visible = true; } else { this.EditBtn.Visible = false; this.ScrapBtn.Visible = false; } //如果是弹出,取消按钮不可见 if (this.Request["ShowDialog"] != null) { if (this.Request["ShowDialog"].ToString() == "1") { this.upButton.Visible = false; this.Master.FindControl("divMenu").Visible = false; this.Master.FindControl("tbCurrentPage").Visible = false; } } } this.cwfAppCheck.FormID = (int)this.ViewState["ObjectId"]; this.cwfAppCheck.ProcID = this.ViewState["ProcID"].ToString(); this.cwfAppCheck.IsView = (bool)this.ViewState["IsView"]; }
public void AddFormMaterial(int?RejectedFormID, int UserID, int?ProxyUserID, int?ProxyPositionID, int OrganizationUnitID, int PositionID, SystemEnums.FormType FormTypeID, SystemEnums.FormStatus StatusID, int ShopID, int FirstVolume, int SecondVolume, int ThirdVolume, string Remark, string FlowTemplate) { SqlTransaction transaction = null; try { transaction = TableAdapterHelper.BeginTransaction(this.TAForm); TableAdapterHelper.SetTransaction(this.TAFormMaterial, transaction); TableAdapterHelper.SetTransaction(this.TAFormMaterialDetail, transaction); FormDS.FormRow formRow = this.FormDataSet.Form.NewFormRow(); if (RejectedFormID != null) { formRow.RejectedFormID = RejectedFormID.GetValueOrDefault(); } formRow.UserID = UserID; UtilityBLL utility = new UtilityBLL(); if (StatusID == SystemEnums.FormStatus.Awaiting) { string formTypeString = utility.GetFormTypeString((int)FormTypeID); formRow.FormNo = utility.GetFormNo(formTypeString); } else { formRow.SetFormNoNull(); } if (ProxyUserID != null) { formRow.ProxyUserID = ProxyUserID.GetValueOrDefault(); } if (ProxyPositionID != null) { formRow.ProxyPositionID = ProxyPositionID.GetValueOrDefault(); } formRow.OrganizationUnitID = OrganizationUnitID; formRow.PositionID = PositionID; formRow.FormTypeID = (int)FormTypeID; formRow.StatusID = (int)StatusID; formRow.SubmitDate = DateTime.Now; formRow.LastModified = DateTime.Now; formRow.InTurnUserIds = "P"; //待改动 formRow.InTurnPositionIds = "P"; //待改动 formRow.PageType = (int)SystemEnums.PageType.MaterialApply; this.FormDataSet.Form.AddFormRow(formRow); this.TAForm.Update(formRow); //处理申请表的内容 FormDS.FormMaterialRow formMaterialRow = this.FormDataSet.FormMaterial.NewFormMaterialRow(); formMaterialRow.FormMaterialID = formRow.FormID; formMaterialRow.ShopID = ShopID; formMaterialRow.FirstVolume = FirstVolume; formMaterialRow.SecondVolume = SecondVolume; formMaterialRow.ThirdVolume = ThirdVolume; formMaterialRow.Amount = 0;//默认值 formMaterialRow.Remark = Remark; this.FormDataSet.FormMaterial.AddFormMaterialRow(formMaterialRow); this.TAFormMaterial.Update(formMaterialRow); //明细表 decimal totalAmount = 0;//计算总申请金额 if (RejectedFormID != null) { FormDS.FormMaterialDetailDataTable newDetailTable = new FormDS.FormMaterialDetailDataTable(); foreach (FormDS.FormMaterialDetailRow detailRow in this.FormDataSet.FormMaterialDetail) { if (detailRow.RowState != System.Data.DataRowState.Deleted) { FormDS.FormMaterialDetailRow newDetailRow = newDetailTable.NewFormMaterialDetailRow(); newDetailRow.FormMaterialID = formMaterialRow.FormMaterialID; newDetailRow.MaterialID = detailRow.MaterialID; ERS.MaterialRow material = new MasterDataBLL().GetMaterialById(detailRow.MaterialID); newDetailRow.MaterialName = material.MaterialName; newDetailRow.UOM = material.UOM; newDetailRow.Description = material.Description; newDetailRow.MaterialPrice = material.MaterialPrice; newDetailRow.Quantity = detailRow.Quantity; newDetailRow.Amount = newDetailRow.MaterialPrice * detailRow.Quantity; if (!detailRow.IsRemarkNull()) { newDetailRow.Remark = detailRow.Remark; } totalAmount += newDetailRow.Amount; newDetailTable.AddFormMaterialDetailRow(newDetailRow); } } this.TAFormMaterialDetail.Update(newDetailTable); } else { foreach (FormDS.FormMaterialDetailRow detailRow in this.FormDataSet.FormMaterialDetail) { // 与父表绑定 if (detailRow.RowState != DataRowState.Deleted) { detailRow.FormMaterialID = formMaterialRow.FormMaterialID; totalAmount += detailRow.Amount; } } this.TAFormMaterialDetail.Update(this.FormDataSet.FormMaterialDetail); } formMaterialRow.Amount = totalAmount; this.TAFormMaterial.Update(formMaterialRow); // 正式提交或草稿 Dictionary <string, object> dic = new Dictionary <string, object>(); dic["Apply_Amount"] = totalAmount; //金额 APHelper AP = new APHelper(); new APFlowBLL().ApplyForm(AP, TAForm, RejectedFormID, formRow, OrganizationUnitID, FlowTemplate, StatusID, dic); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw new ApplicationException("Save Fail!" + ex.ToString()); } finally { transaction.Dispose(); } }