//启动流程 public void ApplyForm(APHelper AP, FormTableAdapter FormTA, int?RejectedFormID, FormDS.FormRow formRow, int OrganizationUnitID, string ProcessTemplateName, SystemEnums.FormStatus StatusID, Dictionary <string, object> map) { string email = string.Empty; if (StatusID == SystemEnums.FormStatus.Awaiting) { string ProcID = AP.createProcess(formRow.FormNo + ":" + DateTime.Now.ToString(), ProcessTemplateName, map); formRow.ProcID = ProcID; String inTurnStr = AP.startProcess(ProcID, OrganizationUnitID, ref email, formRow.UserID.ToString(), new AuthorizationBLL().GetStuffUserById(formRow.UserID).StuffName); string[] InTurn = inTurnStr.Split('&');//不同流程角色下的人员和职位 string ids = ""; string pids = ""; for (int a = 0; a < InTurn.Length; a++) { ids += InTurn[a].Split('$')[0].ToString(); ///人员 pids += InTurn[a].Split('$')[1].ToString(); //职位 } formRow.InTurnUserIds = ids; //下一步的人员 formRow.InTurnPositionIds = pids; //下一步的人员职位 formRow.StatusID = (int)SystemEnums.FormStatus.Awaiting; FormTA.Update(formRow); } //作废之前的单据 if (RejectedFormID != null) { FormDS.FormRow oldRow = FormTA.GetDataByID(RejectedFormID.GetValueOrDefault())[0]; if (oldRow.StatusID == (int)SystemEnums.FormStatus.Rejected) { ScrapForm(oldRow.FormID); } } }
protected void OpenForm(int formID) { FormTableAdapter taForm = new FormTableAdapter(); taForm.FillByID(this.InnerDS.Form, formID); FormDS.FormRow rowForm = this.InnerDS.Form[0]; FormBudgetAllocationTableAdapter taFormBudgetAllocation = new FormBudgetAllocationTableAdapter(); taFormBudgetAllocation.FillByID(this.InnerDS.FormBudgetAllocation, formID); FormDS.FormBudgetAllocationRow rowFormBudgetAllocation = this.InnerDS.FormBudgetAllocation[0]; //赋值 if (!rowFormBudgetAllocation.IsRemarkNull()) { this.RemarkCtl.Text = rowFormBudgetAllocation.Remark; } if (!rowFormBudgetAllocation.IsAttachFileNameNull()) { this.UCFileUpload.AttachmentFileName = rowFormBudgetAllocation.AttachFileName; } if (!rowFormBudgetAllocation.IsRealAttachFileNameNull()) { this.UCFileUpload.RealAttachmentFileName = rowFormBudgetAllocation.RealAttachFileName; } // 打开明细表 FormBudgetAllocationDetailTableAdapter taDetail = new FormBudgetAllocationDetailTableAdapter(); taDetail.FillByFormID(this.InnerDS.FormBudgetAllocationDetail, formID); }
//启动流程 public void ApplyForm(APHelper AP, FormTableAdapter FormTA, int? RejectedFormID, FormDS.FormRow formRow, int OrganizationUnitID, string ProcessTemplateName, SystemEnums.FormStatus StatusID, Dictionary<string, object> map) { string email = string.Empty; if (StatusID == SystemEnums.FormStatus.Awaiting) { string ProcID = AP.createProcess(formRow.FormNo + ":" + DateTime.Now.ToString(), ProcessTemplateName, map); formRow.ProcID = ProcID; String inTurnStr = AP.startProcess(ProcID, OrganizationUnitID, ref email, formRow.UserID.ToString(), new AuthorizationBLL().GetStuffUserById(formRow.UserID).StuffName); string[] InTurn = inTurnStr.Split('&');//不同流程角色下的人员和职位 string ids = ""; string pids = ""; for (int a = 0; a < InTurn.Length; a++) { ids += InTurn[a].Split('$')[0].ToString();///人员 pids += InTurn[a].Split('$')[1].ToString();//职位 } formRow.InTurnUserIds = ids;//下一步的人员 formRow.InTurnPositionIds = pids;//下一步的人员职位 formRow.StatusID = (int)SystemEnums.FormStatus.Awaiting; FormTA.Update(formRow); } //作废之前的单据 if (RejectedFormID != null) { FormDS.FormRow oldRow = FormTA.GetDataByID(RejectedFormID.GetValueOrDefault())[0]; if (oldRow.StatusID == (int)SystemEnums.FormStatus.Rejected) { ScrapForm(oldRow.FormID); } } }
public void GenerateRebateReimburse(int FormApplyID) { FormDS.FormRow form = new FormTableAdapter().GetDataByID(FormApplyID)[0]; UtilityBLL utility = new UtilityBLL(); string formTypeString = utility.GetFormTypeString((int)SystemEnums.FormType.ReimburseApply); new FormApplyTableAdapter().GenerateRebateReimburse(FormApplyID, form.FormNo, utility.GetFormNo(formTypeString)); }
protected void OpenForm(int formID) { FormTableAdapter taForm = new FormTableAdapter(); FormDS.FormRow rowForm = taForm.GetDataByID(formID)[0]; FormContractTableAdapter taFormContract = new FormContractTableAdapter(); FormDS.FormContractRow rowFormContract = taFormContract.GetDataById(formID)[0]; //赋值 TextBox txtBeginDate = (TextBox)(this.UCPeriodBegin.FindControl("txtDate")); TextBox txtEndDate = (TextBox)(this.UCPeriodEnd.FindControl("txtDate")); this.txtFirstCompany.Text = rowFormContract.FirstCompany; if (!rowFormContract.IsSecondCompanyNull()) { this.txtSecondCompany.Text = rowFormContract.SecondCompany; } if (!rowFormContract.IsThirdCompanyNull()) { this.txtThirdCompany.Text = rowFormContract.ThirdCompany; } this.txtContractName.Text = rowFormContract.ContractName; this.txtContractAmount.Text = rowFormContract.ContractAmount.ToString(); this.txtPageNumber.Text = rowFormContract.PageNumber.ToString(); this.dplContractType.SelectedValue = rowFormContract.ContractTypeID.ToString(); if (!rowFormContract.IsPaymentTypeNull()) { this.txtPaymentType.Text = rowFormContract.PaymentType; } if (!rowFormContract.IsBeginDateNull()) { txtBeginDate.Text = rowFormContract.BeginDate.ToShortDateString(); } if (!rowFormContract.IsEndDateNull()) { txtEndDate.Text = rowFormContract.EndDate.ToShortDateString(); } if (!rowFormContract.IsMainContentNull()) { this.txtMainContent.Text = rowFormContract.MainContent; } if (!rowFormContract.IsChangePartNull()) { this.txtChangePart.Text = rowFormContract.ChangePart; } if (!rowFormContract.IsAttachedFileNameNull()) { this.UCFileUpload.AttachmentFileName = rowFormContract.AttachedFileName; } if (!rowFormContract.IsRealAttachedFileNameNull()) { this.UCFileUpload.RealAttachmentFileName = rowFormContract.RealAttachedFileName; } }
protected void OpenForm(int formID) { FormTableAdapter taForm = new FormTableAdapter(); taForm.FillByID(this.InnerDS.Form, formID); FormDS.FormRow rowForm = this.InnerDS.Form[0]; FormApplyTableAdapter taFormApply = new FormApplyTableAdapter(); taFormApply.FillByID(this.InnerDS.FormApply, formID); FormDS.FormApplyRow rowFormApply = this.InnerDS.FormApply[0]; //赋值 this.ViewState["BeginPeriod"] = rowFormApply.BeginPeriod.ToShortDateString(); this.ViewState["EndPeriod"] = rowFormApply.EndPeriod.ToShortDateString(); this.BeginPeriodCtl.Text = rowFormApply.BeginPeriod.ToString("yyyy-MM"); this.EndPeriodCtl.Text = rowFormApply.EndPeriod.ToString("yyyy-MM"); this.ViewState["ExpenseSubCategoryID"] = rowFormApply.ExpenseSubCategoryID.ToString(); this.ExpenseSubCategoryCtl.Text = new MasterDataBLL().GetExpenseSubCateNameById(rowFormApply.ExpenseSubCategoryID); this.ViewState["CustomerID"] = rowFormApply.CustomerID.ToString(); ERS.CustomerRow customer = new MasterDataBLL().GetCustomerById(rowFormApply.CustomerID); this.CustomerNameCtl.Text = customer.CustomerName; //this.CustomerTypeCtl.Text = new MasterDataBLL().GetCustomerTypeById(customer.CustomerTypeID).CustomerTypeName; this.odsShop.SelectParameters["CustomerID"].DefaultValue = customer.CustomerID.ToString(); this.ShopDDL.SelectedValue = rowFormApply.ShopID.ToString(); this.PaymentTypeDDL.SelectedValue = rowFormApply.PaymentTypeID.ToString(); if (!rowFormApply.IsContractNoNull()) { this.ContractNoCtl.Text = rowFormApply.ContractNo; } if (!rowFormApply.IsRemarkNull()) { this.RemarkCtl.Text = rowFormApply.Remark; } if (!rowFormApply.IsAttachedFileNameNull()) { this.UCFileUpload.AttachmentFileName = rowFormApply.AttachedFileName; } if (!rowFormApply.IsRealAttachedFileNameNull()) { this.UCFileUpload.RealAttachmentFileName = rowFormApply.RealAttachedFileName; } if (!rowFormApply.IsFormApplyNameNull()) { this.txtFormApplyName.Text = rowFormApply.FormApplyName.ToString(); } }
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); }
protected void OpenForm(int formID) { FormTableAdapter taForm = new FormTableAdapter(); taForm.FillByID(this.InnerDS.Form, formID); FormDS.FormRow rowForm = this.InnerDS.Form[0]; FormPersonalReimburseTableAdapter taFormTravelReimburse = new FormPersonalReimburseTableAdapter(); taFormTravelReimburse.FillByID(this.InnerDS.FormPersonalReimburse, formID); FormDS.FormPersonalReimburseRow rowFormTravelReimburse = this.InnerDS.FormPersonalReimburse[0]; this.ViewState["FormTravelApplyID"] = rowFormTravelReimburse.FormTravelApplyID; //赋值 this.PeriodDDL.DataSourceID = "odsPeriod"; this.PeriodDDL.DataBind(); ListItem item = this.PeriodDDL.Items.FindByText(rowFormTravelReimburse.Period.ToString("yyyy-MM")); if (item != null) { this.PeriodDDL.SelectedValue = item.Value; } if (!rowFormTravelReimburse.IsRemarkNull()) { this.RemarkCtl.Text = rowFormTravelReimburse.Remark; } if (!rowFormTravelReimburse.IsAttachedFileNameNull()) { this.UCFileUpload.AttachmentFileName = rowFormTravelReimburse.AttachedFileName; } if (!rowFormTravelReimburse.IsRealAttachedFileNameNull()) { this.UCFileUpload.RealAttachmentFileName = rowFormTravelReimburse.RealAttachedFileName; } OpenTravelApplyForm(rowFormTravelReimburse.FormTravelApplyID); // 打开明细表 FormPersonalReimburseDetailTableAdapter taDetail = new FormPersonalReimburseDetailTableAdapter(); taDetail.FillByFormID(this.InnerDS.FormPersonalReimburseDetail, formID); }
//审批方法 public void ApproveForm(int formID, int stuffUserId, string stuffName, bool pass, string comment, string ProxyStuffName,bool CheckPeriod = false) { string email = string.Empty; SqlTransaction transaction = null; try { string l_strtitle = ""; StringBuilder l_strbody = new StringBuilder(); FormTableAdapter TAMainForm = new FormTableAdapter(); transaction = TableAdapterHelper.BeginTransaction(TAMainForm); FormDS.FormRow formRow = TAMainForm.GetDataByID(formID)[0]; string returnValue = AP.approve(pass, comment, stuffUserId.ToString(), stuffName, formRow.ProcID, ProxyStuffName, formRow.OrganizationUnitID, ref email,CheckPeriod); // UtilityBLL ubll = new UtilityBLL(); string[] approveinfo = AP.GetProcessApproveUser(formRow.ProcID); if (AP.GetProcessIsEnd(formRow.ProcID)) { formRow.LastApprover = stuffUserId; formRow.Comment = comment; formRow.ApprovedDate = Convert.ToDateTime(approveinfo[0]); } formRow.ApproverIds = approveinfo[3]; if (returnValue == null) { formRow.InTurnUserIds = "P"; formRow.InTurnPositionIds = "P"; formRow.ApprovedDate = DateTime.Now; if (pass) { //如果审批通过且返回值为空则该流程结束 formRow.StatusID = (int)SystemEnums.FormStatus.ApproveCompleted; } else { //如果不通过则为驳回 formRow.StatusID = (int)SystemEnums.FormStatus.Rejected; } } else { string[] InTurn = returnValue.Split('&');//不同流程角色下的人员和职位 string ids = ""; string pids = ""; for (int a = 0; a < InTurn.Length; a++) { ids += InTurn[a].Split('$')[0].ToString();///人员 pids += InTurn[a].Split('$')[1].ToString();//职位 } formRow.InTurnUserIds = ids;//下一步的人员 formRow.InTurnPositionIds = pids;//下一步的人员职位 } TAMainForm.Update(formRow); transaction.Commit(); #region 发送邮件 try { QueryDS.FormViewRow l_drformView = new FormQueryBLL().GetFormViewByID(formID); if (pass) { if (!string.IsNullOrEmpty(returnValue)) { l_strtitle = "有一份" + l_drformView.FormTypeName + "单据,编号为:" + l_drformView.FormNo + ",等待您的审批!"; l_strbody.Append("您好,<br>"); l_strbody.Append(" 有一份" + l_drformView.StuffName + "提交的" + l_drformView.FormTypeName + "单据,编号:" + l_drformView.FormNo + ",等待您的审批!"); l_strbody.Append("<br>此邮件请勿回复!"); mailBody = string.Format(mailBody, l_strbody.ToString()); sendMail(email, "", l_strtitle, mailBody); //AP.sendMail(emailTo, "", l_strtitle, mailBody); } else { l_strtitle = "您的" + l_drformView.FormTypeName + "单据,编号为:" + l_drformView.FormNo + ",已审批完成!"; l_strbody.Append("您好,<br>"); l_strbody.Append(" 您于" + l_drformView.SubmitDate.ToString("yyyy-MM-dd") + "提交的" + l_drformView.FormTypeName + "单据,编号:" + l_drformView.FormNo + ",已经审批通过!"); l_strbody.Append("<br>此邮件请勿回复!"); mailBody = string.Format(mailBody, l_strbody.ToString()); sendMail(AuthorizationBLL.GetStuffUserById(formRow.UserID).EMail, "", l_strtitle, mailBody); //AP.sendMail(emailTo, "", l_strtitle, mailBody); } } else { l_strtitle = "您的" + l_drformView.FormTypeName + "单据,编号为:" + l_drformView.FormNo + ",被驳回!"; l_strbody.Append("您好,<br>"); l_strbody.Append(" 您于" + l_drformView.SubmitDate.ToString("yyyy-MM-dd") + "提交的" + l_drformView.FormTypeName + "单据,编号:" + l_drformView.FormNo + ",被" + stuffName + "驳回!"); l_strbody.Append("<br>此邮件请勿回复!"); mailBody = string.Format(mailBody, l_strbody.ToString()); sendMail(AuthorizationBLL.GetStuffUserById(formRow.UserID).EMail, "", l_strtitle, mailBody); //AP.sendMail(emailTo, "", l_strtitle, mailBody); } } catch (Exception e1) { } #endregion } catch (Exception ex) { if (transaction != null) { transaction.Rollback(); } throw ex; } finally { if (transaction != null) { transaction.Dispose(); } } }
public void ScrapForm(int FormID) { FormDS.FormRow formRow = new FormTableAdapter().GetDataByID(FormID)[0]; formRow.StatusID = (int)SystemEnums.FormStatus.Scrap; new FormTableAdapter().Update(formRow); }
public APResult ApproveForm(APParameter app, int formID, int stuffUserId, string stuffName, bool pass, string comment, string ProxyStuffName, string proctID) { APResult result = new APResult(); string email = string.Empty; try { string l_strtitle = ""; StringBuilder l_strbody = new StringBuilder(); FormTableAdapter TAMainForm = new FormTableAdapter(); //FormDS.FormRow formRow = TAMainForm.GetDataByID(formID)[0]; string returnValue = AP.approve(pass, comment, stuffUserId.ToString(), stuffName, proctID, ProxyStuffName, app.OrganizationUnitID, ref email,false); // UtilityBLL ubll = new UtilityBLL(); string[] approveinfo = AP.GetProcessApproveUser(proctID); if (returnValue != null) { string[] InTurn = returnValue.Split('&');//不同流程角色下的人员和职位 string ids = ""; string pids = ""; for (int a = 0; a < InTurn.Length; a++) { ids += InTurn[a].Split('$')[0].ToString();///人员 pids += InTurn[a].Split('$')[1].ToString();//职位 } result.InTurnUserIds = ids;//下一步的人员 result.InTurnPositionIds = pids;//下一步的人员职位 } #region 发送邮件 try { QueryDS.FormViewRow l_drformView = new FormQueryBLL().GetFormViewByID(formID); if (pass) { if (!string.IsNullOrEmpty(returnValue)) { l_strtitle = "有一份" + l_drformView.FormTypeName + "单据,编号为:" + l_drformView.FormNo + ",等待您的审批!"; l_strbody.Append("您好,<br>"); l_strbody.Append(" 有一份" + l_drformView.StuffName + "提交的" + l_drformView.FormTypeName + "单据,编号:" + l_drformView.FormNo + ",等待您的审批!"); l_strbody.Append("<br>此邮件请勿回复!"); mailBody = string.Format(mailBody, l_strbody.ToString()); sendMail(email, "", l_strtitle, mailBody); //AP.sendMail(emailTo, "", l_strtitle, mailBody); } else { l_strtitle = "您的" + l_drformView.FormTypeName + "单据,编号为:" + l_drformView.FormNo + ",已审批完成!"; l_strbody.Append("您好,<br>"); l_strbody.Append(" 您于" + l_drformView.SubmitDate.ToString("yyyy-MM-dd") + "提交的" + l_drformView.FormTypeName + "单据,编号:" + l_drformView.FormNo + ",已经审批通过!"); l_strbody.Append("<br>此邮件请勿回复!"); mailBody = string.Format(mailBody, l_strbody.ToString()); sendMail(AuthorizationBLL.GetStuffUserById(app.UserID).EMail, "", l_strtitle, mailBody); //AP.sendMail(emailTo, "", l_strtitle, mailBody); } } else { l_strtitle = "您的" + l_drformView.FormTypeName + "单据,编号为:" + l_drformView.FormNo + ",被驳回!"; l_strbody.Append("您好,<br>"); l_strbody.Append(" 您于" + l_drformView.SubmitDate.ToString("yyyy-MM-dd") + "提交的" + l_drformView.FormTypeName + "单据,编号:" + l_drformView.FormNo + ",被" + stuffName + "驳回!"); l_strbody.Append("<br>此邮件请勿回复!"); mailBody = string.Format(mailBody, l_strbody.ToString()); sendMail(AuthorizationBLL.GetStuffUserById(app.UserID).EMail, "", l_strtitle, mailBody); //AP.sendMail(emailTo, "", l_strtitle, mailBody); } } catch { } #endregion return result; } catch (Exception ex) { throw ex; } }
//审批方法 public void ApproveForm(APHelper AP, int formID, int stuffUserId, string stuffName, bool pass, string comment, string ProxyStuffName, int OrganizationUnitID) { string email = string.Empty; SqlTransaction transaction = null; try { FormTableAdapter TAMainForm = new FormTableAdapter(); transaction = TableAdapterHelper.BeginTransaction(TAMainForm); FormDS.FormRow formRow = TAMainForm.GetDataByID(formID)[0]; string returnValue = AP.approve(pass, comment, stuffUserId.ToString(), stuffName, formRow.ProcID, ProxyStuffName, formRow.OrganizationUnitID, ref email); string[] approveinfo = AP.GetProcessApproveUser(formRow.ProcID); if (AP.GetProcessIsEnd(formRow.ProcID)) { formRow.LastApprover = stuffUserId.ToString(); formRow.Comment = comment; formRow.ApprovedDate = Convert.ToDateTime(approveinfo[0]); } formRow.ApproverIds = approveinfo[3]; if (returnValue == null) { formRow.InTurnUserIds = "P"; formRow.InTurnPositionIds = "P"; //formRow.SubmitDate = DateTime.Now; if (pass) { //如果审批通过且返回值为空则该流程结束 formRow.StatusID = (int)SystemEnums.FormStatus.ApproveCompleted; //mailTitle = string.Format("您申请的编号为{0}的单据已经通过审批", formRow.FormNo); //mailBody = string.Format(mailBody, formRow.FormNo); //email = AP.getUserEmailByID(formRow.UserID); //AP.sendMail(email, "", mailTitle, mailBody); } else { //如果不通过则为驳回 formRow.StatusID = (int)SystemEnums.FormStatus.Rejected; //mailTitle = string.Format("您有单据申请被{0}退回", stuffName); //mailBody = string.Format(mailBody, formRow.FormNo); //email = AP.getUserEmailByID(formRow.UserID); //AP.sendMail(email, "", mailTitle, mailBody); } } else { string[] InTurn = returnValue.Split('&');//不同流程角色下的人员和职位 string ids = ""; string pids = ""; for (int a = 0; a < InTurn.Length; a++) { ids += InTurn[a].Split('$')[0].ToString();///人员 pids += InTurn[a].Split('$')[1].ToString();//职位 } formRow.InTurnUserIds = ids;//下一步的人员 formRow.InTurnPositionIds = pids;//下一步的人员职位 //mailTitle = string.Format(mailTitle, stuffName, formRow.FormNo); //mailBody = string.Format(mailBody, formRow.FormNo); //AP.sendMail(email, "", mailTitle,mailBody); } TAMainForm.Update(formRow); transaction.Commit(); } catch (Exception ex) { if (transaction != null) transaction.Rollback(); throw ex; } finally { if (transaction != null) transaction.Dispose(); } //System.Threading.Thread.Sleep(3000); }
protected void OpenForm(int formID) { FormTableAdapter taForm = new FormTableAdapter(); taForm.FillByID(this.InnerDS.Form, formID); FormDS.FormRow rowForm = this.InnerDS.Form[0]; FormPersonalReimburseTableAdapter taFormTravelReimburse = new FormPersonalReimburseTableAdapter(); taFormTravelReimburse.FillByID(this.InnerDS.FormPersonalReimburse, formID); FormDS.FormPersonalReimburseRow rowFormTravelReimburse = this.InnerDS.FormPersonalReimburse[0]; this.ViewState["FormTravelApplyID"] = rowFormTravelReimburse.FormTravelApplyID; //��ֵ this.PeriodDDL.DataSourceID = "odsPeriod"; this.PeriodDDL.DataBind(); ListItem item = this.PeriodDDL.Items.FindByText(rowFormTravelReimburse.Period.ToString("yyyy-MM")); if (item != null) { this.PeriodDDL.SelectedValue = item.Value; } if (!rowFormTravelReimburse.IsRemarkNull()) { this.RemarkCtl.Text = rowFormTravelReimburse.Remark; } if (!rowFormTravelReimburse.IsAttachedFileNameNull()) { this.UCFileUpload.AttachmentFileName = rowFormTravelReimburse.AttachedFileName; } if (!rowFormTravelReimburse.IsRealAttachedFileNameNull()) { this.UCFileUpload.RealAttachmentFileName = rowFormTravelReimburse.RealAttachedFileName; } OpenTravelApplyForm(rowFormTravelReimburse.FormTravelApplyID); // ����ϸ�� FormPersonalReimburseDetailTableAdapter taDetail = new FormPersonalReimburseDetailTableAdapter(); taDetail.FillByFormID(this.InnerDS.FormPersonalReimburseDetail, formID); }
protected void OpenForm(int formID) { FormTableAdapter taForm = new FormTableAdapter(); taForm.FillByID(this.InnerDS.Form, formID); FormDS.FormRow rowForm = this.InnerDS.Form[0]; FormApplyTableAdapter taFormApply = new FormApplyTableAdapter(); taFormApply.FillByID(this.InnerDS.FormApply, formID); FormDS.FormApplyRow rowFormApply = this.InnerDS.FormApply[0]; //赋值 this.ViewState["BeginPeriod"] = rowFormApply.BeginPeriod.ToShortDateString(); this.ViewState["EndPeriod"] = rowFormApply.EndPeriod.ToShortDateString(); this.BeginPeriodCtl.Text = rowFormApply.BeginPeriod.ToString("yyyy-MM"); this.EndPeriodCtl.Text = rowFormApply.EndPeriod.ToString("yyyy-MM"); this.ViewState["ExpenseSubCategoryID"] = rowFormApply.ExpenseSubCategoryID.ToString(); this.ExpenseSubCategoryCtl.Text = new MasterDataBLL().GetExpenseSubCateNameById(rowFormApply.ExpenseSubCategoryID); this.ViewState["CustomerID"] = rowFormApply.CustomerID.ToString(); ERS.CustomerRow customer = new MasterDataBLL().GetCustomerById(rowFormApply.CustomerID); this.CustomerNameCtl.Text = customer.CustomerName; //this.CustomerTypeCtl.Text = new MasterDataBLL().GetCustomerTypeById(customer.CustomerTypeID).CustomerTypeName; this.odsShop.SelectParameters["CustomerID"].DefaultValue = customer.CustomerID.ToString(); this.ViewState["PromotionPriceType"] = rowFormApply.PromotionPriceType.ToString(); this.ShopDDL.SelectedValue = rowFormApply.ShopID.ToString(); this.PaymentTypeDDL.SelectedValue = rowFormApply.PaymentTypeID.ToString(); if (!rowFormApply.IsContractNoNull()) { this.ContractNoCtl.Text = rowFormApply.ContractNo; } if (!rowFormApply.IsRemarkNull()) { this.RemarkCtl.Text = rowFormApply.Remark; } if (!rowFormApply.IsAttachedFileNameNull()) { this.UCFileUpload.AttachmentFileName = rowFormApply.AttachedFileName; } if (!rowFormApply.IsRealAttachedFileNameNull()) { this.UCFileUpload.RealAttachmentFileName = rowFormApply.RealAttachedFileName; } if (!rowFormApply.IsPromotionBeginDateNull()) { this.UCPromotionBegin.SelectedDate = rowFormApply.PromotionBeginDate.ToString("yyyy-MM-dd"); } if (!rowFormApply.IsPromotionEndDateNull()) { this.UCPromotionEnd.SelectedDate = rowFormApply.PromotionEndDate.ToString("yyyy-MM-dd"); } if (!rowFormApply.IsDeliveryBeginDateNull()) { this.UCDeliveryBegin.SelectedDate = rowFormApply.DeliveryBeginDate.ToString("yyyy-MM-dd"); } if (!rowFormApply.IsDeliveryEndDateNull()) { this.UCDeliveryEnd.SelectedDate = rowFormApply.DeliveryEndDate.ToString("yyyy-MM-dd"); } this.PromotionScopeDDL.SelectedValue = rowFormApply.PromotionScopeID.ToString(); this.PromotionTypeDDL.SelectedValue = rowFormApply.PromotionTypeID.ToString(); if (!rowFormApply.IsPromotionDescNull()) { this.PromotionDescCtl.Text = rowFormApply.PromotionDesc; } this.ShelfTypeDDL.SelectedValue = rowFormApply.ShelfTypeID.ToString(); if (!rowFormApply.IsFirstVolumeNull()) { this.FirstVolumeCtl.Text = rowFormApply.FirstVolume.ToString(); } if (!rowFormApply.IsSecondVolumeNull()) { this.SecondVolumeCtl.Text = rowFormApply.SecondVolume.ToString(); } if (!rowFormApply.IsThirdVolumeNull()) { this.ThirdVolumeCtl.Text = rowFormApply.ThirdVolume.ToString(); } if (!rowFormApply.IsFormApplyNameNull()) { this.txtFormApplyName.Text = rowFormApply.FormApplyName; } if (!rowFormApply.IsReimburseRequirementsNull()) { int ReimburseRequirement = rowFormApply.ReimburseRequirements; if ((ReimburseRequirement & (int)SystemEnums.ReimburseRequirements.Picture) == (int)SystemEnums.ReimburseRequirements.Picture) { chkListReimburseRequirements.Items[0].Selected = true; } if ((ReimburseRequirement & (int)SystemEnums.ReimburseRequirements.Agreement) == (int)SystemEnums.ReimburseRequirements.Agreement) { chkListReimburseRequirements.Items[1].Selected = true; } if ((ReimburseRequirement & (int)SystemEnums.ReimburseRequirements.DeliveryOrder) == (int)SystemEnums.ReimburseRequirements.DeliveryOrder) { chkListReimburseRequirements.Items[2].Selected = true; } if ((ReimburseRequirement & (int)SystemEnums.ReimburseRequirements.Contract) == (int)SystemEnums.ReimburseRequirements.Contract) { chkListReimburseRequirements.Items[3].Selected = true; } if ((ReimburseRequirement & (int)SystemEnums.ReimburseRequirements.DM) == (int)SystemEnums.ReimburseRequirements.DM) { chkListReimburseRequirements.Items[4].Selected = true; } if ((ReimburseRequirement & (int)SystemEnums.ReimburseRequirements.Other) == (int)SystemEnums.ReimburseRequirements.Other) { chkListReimburseRequirements.Items[5].Selected = true; } } this.ViewState["PromotionPriceType"] = rowFormApply.PromotionPriceType.ToString(); // 打开明细表 FormApplySKUDetailTableAdapter taSKU = new FormApplySKUDetailTableAdapter(); taSKU.FillByFormApplyID(this.InnerDS.FormApplySKUDetail, formID); FormApplyExpenseDetailTableAdapter taExpense = new FormApplyExpenseDetailTableAdapter(); taExpense.FillByFormApplyID(this.InnerDS.FormApplyExpenseDetail, formID); new FormApplySplitRateTableAdapter().FillByApplyID(InnerDS.FormApplySplitRate, formID); }
protected void OpenForm(int formID) { FormTableAdapter taForm = new FormTableAdapter(); taForm.FillByID(this.InnerDS.Form, formID); FormDS.FormRow rowForm = this.InnerDS.Form[0]; FormBudgetAllocationTableAdapter taFormBudgetAllocation = new FormBudgetAllocationTableAdapter(); taFormBudgetAllocation.FillByID(this.InnerDS.FormBudgetAllocation, formID); FormDS.FormBudgetAllocationRow rowFormBudgetAllocation = this.InnerDS.FormBudgetAllocation[0]; //��ֵ if (!rowFormBudgetAllocation.IsRemarkNull()) { this.RemarkCtl.Text = rowFormBudgetAllocation.Remark; } if (!rowFormBudgetAllocation.IsAttachFileNameNull()) { this.UCFileUpload.AttachmentFileName = rowFormBudgetAllocation.AttachFileName; } if (!rowFormBudgetAllocation.IsRealAttachFileNameNull()) { this.UCFileUpload.RealAttachmentFileName = rowFormBudgetAllocation.RealAttachFileName; } // ����ϸ�� FormBudgetAllocationDetailTableAdapter taDetail = new FormBudgetAllocationDetailTableAdapter(); taDetail.FillByFormID(this.InnerDS.FormBudgetAllocationDetail, formID); }
protected void OpenForm(int formID) { FormTableAdapter taForm = new FormTableAdapter(); taForm.FillByID(this.InnerDS.Form, formID); FormDS.FormRow rowForm = this.InnerDS.Form[0]; FormApplyTableAdapter taFormApply = new FormApplyTableAdapter(); taFormApply.FillByID(this.InnerDS.FormApply, formID); FormDS.FormApplyRow rowFormApply = this.InnerDS.FormApply[0]; //��ֵ this.ViewState["BeginPeriod"] = rowFormApply.BeginPeriod.ToShortDateString(); this.ViewState["EndPeriod"] = rowFormApply.EndPeriod.ToShortDateString(); this.BeginPeriodCtl.Text = rowFormApply.BeginPeriod.ToString("yyyy-MM"); this.EndPeriodCtl.Text = rowFormApply.EndPeriod.ToString("yyyy-MM"); this.ViewState["ExpenseSubCategoryID"] = rowFormApply.ExpenseSubCategoryID.ToString(); this.ExpenseSubCategoryCtl.Text = new MasterDataBLL().GetExpenseSubCateNameById(rowFormApply.ExpenseSubCategoryID); this.ViewState["CustomerID"] = rowFormApply.CustomerID.ToString(); ERS.CustomerRow customer = new MasterDataBLL().GetCustomerById(rowFormApply.CustomerID); this.CustomerNameCtl.Text = customer.CustomerName; //this.CustomerTypeCtl.Text = new MasterDataBLL().GetCustomerTypeById(customer.CustomerTypeID).CustomerTypeName; this.odsShop.SelectParameters["CustomerID"].DefaultValue = customer.CustomerID.ToString(); this.ShopDDL.SelectedValue = rowFormApply.ShopID.ToString(); this.PaymentTypeDDL.SelectedValue = rowFormApply.PaymentTypeID.ToString(); if (!rowFormApply.IsContractNoNull()) { this.ContractNoCtl.Text = rowFormApply.ContractNo; } if (!rowFormApply.IsRemarkNull()) { this.RemarkCtl.Text = rowFormApply.Remark; } if (!rowFormApply.IsAttachedFileNameNull()) this.UCFileUpload.AttachmentFileName = rowFormApply.AttachedFileName; if (!rowFormApply.IsRealAttachedFileNameNull()) this.UCFileUpload.RealAttachmentFileName = rowFormApply.RealAttachedFileName; if (!rowFormApply.IsPromotionBeginDateNull()) { this.UCPromotionBegin.SelectedDate = rowFormApply.PromotionBeginDate.ToString("yyyy-MM-dd"); } if (!rowFormApply.IsPromotionEndDateNull()) { this.UCPromotionEnd.SelectedDate = rowFormApply.PromotionEndDate.ToString("yyyy-MM-dd"); } this.PromotionScopeDDL.SelectedValue = rowFormApply.PromotionScopeID.ToString(); this.PromotionTypeDDL.SelectedValue = rowFormApply.PromotionTypeID.ToString(); if (!rowFormApply.IsPromotionDescNull()) { this.PromotionDescCtl.Text = rowFormApply.PromotionDesc; } this.ShelfTypeDDL.SelectedValue = rowFormApply.ShelfTypeID.ToString(); if (!rowFormApply.IsFirstVolumeNull()) { this.FirstVolumeCtl.Text = rowFormApply.FirstVolume.ToString(); } if (!rowFormApply.IsSecondVolumeNull()) { this.SecondVolumeCtl.Text = rowFormApply.SecondVolume.ToString(); } if (!rowFormApply.IsThirdVolumeNull()) { this.ThirdVolumeCtl.Text = rowFormApply.ThirdVolume.ToString(); } if (!rowFormApply.IsEstimatedSaleVolumeNull()) { this.txtEstimatedSaleVolume.Text = rowFormApply.EstimatedSaleVolume.ToString(); } if (!rowFormApply.IsPackageUnitPriceNull()) { this.txtPackageUnitPrice.Text = rowFormApply.PackageUnitPrice.ToString("N"); } if (!rowFormApply.IsFormApplyNameNull()) { this.txtFormApplyName.Text = rowFormApply.FormApplyName.ToString(); } if (!rowFormApply.IsReimburseRequirementsNull()) { int ReimburseRequirement = rowFormApply.ReimburseRequirements; if ((ReimburseRequirement & (int)SystemEnums.ReimburseRequirements.Picture) == (int)SystemEnums.ReimburseRequirements.Picture) { chkListReimburseRequirements.Items[0].Selected = true; } if ((ReimburseRequirement & (int)SystemEnums.ReimburseRequirements.Agreement) == (int)SystemEnums.ReimburseRequirements.Agreement) { chkListReimburseRequirements.Items[1].Selected = true; } if ((ReimburseRequirement & (int)SystemEnums.ReimburseRequirements.DeliveryOrder) == (int)SystemEnums.ReimburseRequirements.DeliveryOrder) { chkListReimburseRequirements.Items[2].Selected = true; } if ((ReimburseRequirement & (int)SystemEnums.ReimburseRequirements.Contract) == (int)SystemEnums.ReimburseRequirements.Contract) { chkListReimburseRequirements.Items[3].Selected = true; } if ((ReimburseRequirement & (int)SystemEnums.ReimburseRequirements.DM) == (int)SystemEnums.ReimburseRequirements.DM) { chkListReimburseRequirements.Items[4].Selected = true; } if ((ReimburseRequirement & (int)SystemEnums.ReimburseRequirements.Other) == (int)SystemEnums.ReimburseRequirements.Other) { chkListReimburseRequirements.Items[5].Selected = true; } } // ����ϸ�� FormApplyDetailViewTableAdapter taDetail = new FormApplyDetailViewTableAdapter(); taDetail.FillByFormID(this.InnerDS.FormApplyDetailView, formID); new FormApplySplitRateTableAdapter().FillByApplyID(InnerDS.FormApplySplitRate, formID); }
public void ExecuteCancel(int FormApplyID, int ConfirmCompleteUserID) { SqlTransaction transaction = null; try { //事务开始 transaction = TableAdapterHelper.BeginTransaction(this.TAForm); TableAdapterHelper.SetTransaction(this.TAFormApply, transaction); FormDS.FormRow formRow = new FormTableAdapter().GetDataByID(FormApplyID)[0]; formRow.StatusID = (int)SystemEnums.FormStatus.Scrap; this.TAForm.Update(formRow); //处理申请表的内容 FormDS.FormApplyRow formApplyRow = this.TAFormApply.GetDataByID(FormApplyID)[0]; formApplyRow.IsComplete = false; formApplyRow.ConfirmCompleteDate = DateTime.Now; formApplyRow.ConfirmCompleteUserID = ConfirmCompleteUserID; this.TAFormApply.Update(formApplyRow); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw new ApplicationException("Save Fail!" + ex.ToString()); } finally { transaction.Dispose(); } }
protected void OpenForm(int formID) { FormTableAdapter taForm = new FormTableAdapter(); FormDS.FormRow rowForm = taForm.GetDataByID(formID)[0]; FormContractTableAdapter taFormContract = new FormContractTableAdapter(); FormDS.FormContractRow rowFormContract = taFormContract.GetDataById(formID)[0]; //��ֵ TextBox txtBeginDate = (TextBox)(this.UCPeriodBegin.FindControl("txtDate")); TextBox txtEndDate = (TextBox)(this.UCPeriodEnd.FindControl("txtDate")); this.txtFirstCompany.Text = rowFormContract.FirstCompany; if (!rowFormContract.IsSecondCompanyNull()) { this.txtSecondCompany.Text = rowFormContract.SecondCompany; } if (!rowFormContract.IsThirdCompanyNull()) { this.txtThirdCompany.Text = rowFormContract.ThirdCompany; } this.txtContractName.Text = rowFormContract.ContractName; this.txtContractAmount.Text = rowFormContract.ContractAmount.ToString(); this.txtPageNumber.Text = rowFormContract.PageNumber.ToString(); this.dplContractType.SelectedValue = rowFormContract.ContractTypeID.ToString(); if (!rowFormContract.IsPaymentTypeNull()) { this.txtPaymentType.Text = rowFormContract.PaymentType; } if (!rowFormContract.IsBeginDateNull()) { txtBeginDate.Text = rowFormContract.BeginDate.ToShortDateString(); } if (!rowFormContract.IsEndDateNull()) { txtEndDate.Text = rowFormContract.EndDate.ToShortDateString(); } if (!rowFormContract.IsMainContentNull()) { this.txtMainContent.Text = rowFormContract.MainContent; } if (!rowFormContract.IsChangePartNull()) { this.txtChangePart.Text = rowFormContract.ChangePart; } if (!rowFormContract.IsAttachedFileNameNull()) { this.UCFileUpload.AttachmentFileName = rowFormContract.AttachedFileName; } if (!rowFormContract.IsRealAttachedFileNameNull()) { this.UCFileUpload.RealAttachmentFileName = rowFormContract.RealAttachedFileName; } }
protected void OpenForm(int formID) { FormTableAdapter taForm = new FormTableAdapter(); taForm.FillByID(this.InnerDS.Form, formID); FormDS.FormRow rowForm = this.InnerDS.Form[0]; FormApplyTableAdapter taFormApply = new FormApplyTableAdapter(); taFormApply.FillByID(this.InnerDS.FormApply, formID); FormDS.FormApplyRow rowFormApply = this.InnerDS.FormApply[0]; //��ֵ this.ViewState["BeginPeriod"] = rowFormApply.BeginPeriod.ToShortDateString(); this.ViewState["EndPeriod"] = rowFormApply.EndPeriod.ToShortDateString(); this.BeginPeriodCtl.Text = rowFormApply.BeginPeriod.ToString("yyyy-MM"); this.EndPeriodCtl.Text = rowFormApply.EndPeriod.ToString("yyyy-MM"); this.ViewState["ExpenseSubCategoryID"] = rowFormApply.ExpenseSubCategoryID.ToString(); this.ExpenseSubCategoryCtl.Text = new MasterDataBLL().GetExpenseSubCateNameById(rowFormApply.ExpenseSubCategoryID); this.ViewState["CustomerID"] = rowFormApply.CustomerID.ToString(); ERS.CustomerRow customer = new MasterDataBLL().GetCustomerById(rowFormApply.CustomerID); this.CustomerNameCtl.Text = customer.CustomerName; //this.CustomerTypeCtl.Text = new MasterDataBLL().GetCustomerTypeById(customer.CustomerTypeID).CustomerTypeName; this.odsShop.SelectParameters["CustomerID"].DefaultValue = customer.CustomerID.ToString(); this.ShopDDL.SelectedValue = rowFormApply.ShopID.ToString(); this.PaymentTypeDDL.SelectedValue = rowFormApply.PaymentTypeID.ToString(); if (!rowFormApply.IsContractNoNull()) { this.ContractNoCtl.Text = rowFormApply.ContractNo; } if (!rowFormApply.IsRemarkNull()) { this.RemarkCtl.Text = rowFormApply.Remark; } if (!rowFormApply.IsAttachedFileNameNull()) { this.UCFileUpload.AttachmentFileName = rowFormApply.AttachedFileName; } if (!rowFormApply.IsRealAttachedFileNameNull()) { this.UCFileUpload.RealAttachmentFileName = rowFormApply.RealAttachedFileName; } if (!rowFormApply.IsFormApplyNameNull()) { this.txtFormApplyName.Text = rowFormApply.FormApplyName.ToString(); } }
public string GenerateFormAndReturnError(int i, DataRow row, LogDS.ImportFormLogDetailRow logDetailRow) { SqlTransaction transaction = null; string errorInfor = string.Empty; try { FormTableAdapter TAForm = new FormTableAdapter(); FormSaleSettlementTableAdapter TAFormSettlement = new FormSaleSettlementTableAdapter(); FormSalePaymentTableAdapter TASalePayment = new FormSalePaymentTableAdapter(); FormSalePaymentDetailTableAdapter TASalePaymentDetail = new FormSalePaymentDetailTableAdapter(); FormSettlementExpenseDetailTableAdapter TAFormSettlementExpenseDetail = new FormSettlementExpenseDetailTableAdapter(); transaction = TableAdapterHelper.BeginTransaction(TAForm); TableAdapterHelper.SetTransaction(TASalePayment, transaction); TableAdapterHelper.SetTransaction(TASalePaymentDetail, transaction); FormDS.FormDataTable tbForm = new FormDS.FormDataTable(); FormDS.FormSalePaymentDataTable tbPayment = new FormDS.FormSalePaymentDataTable(); FormDS.FormSalePaymentDetailDataTable tbPaymentDetail = new FormDS.FormSalePaymentDetailDataTable(); FormDS.FormRow rowForm = null; FormDS.FormSalePaymentRow rowPayment = null; FormDS.FormSalePaymentDetailRow rowPaymentDetail = null; string settlementFormNo = string.Empty; DateTime SubmitDate = DateTime.Now; decimal PaymentAmount = 0; bool IsValid = true; if (CheckData(row) != null) { errorInfor = "第" + (i + 1) + "行有错:" + CheckData(row); IsValid = false; } else { settlementFormNo = row[0].ToString().Trim(); SubmitDate = DateTime.Parse(row[1].ToString()); PaymentAmount = decimal.Parse(row[2].ToString().Trim()); logDetailRow.SettlementFormNo = settlementFormNo; logDetailRow.PaymentAmount = PaymentAmount; FormDS.FormDataTable tbSettlement = TAForm.GetDataByFormNo(settlementFormNo); if (tbSettlement.Rows.Count <= 0) { errorInfor = "第" + (i + 1) + "行有错:系统中找不到结案单《" + settlementFormNo + "》"; IsValid = false; } FormDS.FormRow settlementForm = tbSettlement[0]; FormDS.FormSaleSettlementRow rowSettlement = TAFormSettlement.GetDataByID(settlementForm.FormID)[0]; if (rowSettlement.PaymentTypeID != 2 && rowSettlement.PaymentTypeID != 5) { errorInfor = "第" + (i + 1) + "行有错:该单据支付方式,不是票扣或者调整因子《" + settlementFormNo + "》"; IsValid = false; } if (rowSettlement.IsClose) { errorInfor = "第" + (i + 1) + "行有错:该单据已标记为支付完成《" + settlementFormNo + "》"; IsValid = false; } if (rowSettlement.PaymentTypeID == 2 && PaymentAmount > rowSettlement.AmountRMB) { errorInfor = "第" + (i + 1) + "行有错:支付金额超过结案金额《" + settlementFormNo + "》"; IsValid = false; } if (IsValid) { //生成单据 rowForm = tbForm.NewFormRow(); rowPayment = tbPayment.NewFormSalePaymentRow(); //生成Form rowForm.SetRejectedFormIDNull(); //申请人取结案单申请人 rowForm.UserID = settlementForm.UserID; UtilityBLL utility = new UtilityBLL(); rowForm.FormNo = utility.GetFormNo(utility.GetFormTypeString((int)SystemEnums.FormType.SalePayment)); rowForm.SetProxyUserIDNull(); rowForm.SetProxyPositionIDNull(); //申请人部门取结案单申请人所在部门 rowForm.OrganizationUnitID = settlementForm.OrganizationUnitID; rowForm.PositionID = settlementForm.PositionID; rowForm.FormTypeID = (int)SystemEnums.FormType.SalePayment; rowForm.StatusID = (int)SystemEnums.FormStatus.ApproveCompleted; rowForm.SubmitDate = SubmitDate; rowForm.LastModified = SubmitDate; rowForm.InTurnUserIds = "P";//待改动 rowForm.InTurnPositionIds = "P";//待改动 rowForm.PageType = (int)SystemEnums.PageType.PaymentCash; rowForm.CostCenterID = settlementForm.CostCenterID; rowForm.ApprovedDate = SubmitDate; //是否创建凭证? rowForm.IsCreateVoucher = false; rowForm.IsExportLock = false; rowForm.IsCompletePayment = false; rowForm.IsInvoiceReturned = false; tbForm.AddFormRow(rowForm); TAForm.Update(rowForm); //生成FormPayment rowPayment.FormSalePaymentID = rowForm.FormID; rowPayment.FormSaleSettlementID = settlementForm.FormID; //生成时,不考虑预付款 rowPayment.SetFormSaleApplyIDNull(); rowPayment.InvoiceStatusID = (int)SystemEnums.InvoiceStatus.No; rowPayment.PaymentTypeID = rowSettlement.PaymentTypeID; //报销申请单备注 rowPayment.Remark = "此单据为自动生成单据。"; rowPayment.SetAttachedFileNameNull(); rowPayment.SetRealAttachedFileNameNull(); //报销金额 rowPayment.AmountRMB = PaymentAmount; rowPayment.VatTypeID = 1; rowPayment.AmountBeforeTax = rowPayment.AmountRMB; rowPayment.TaxAmount = 0; rowPayment.IsAdvanced = false; //VendorID设置什么值 rowPayment.SetVendorIDNull(); tbPayment.AddFormSalePaymentRow(rowPayment); TASalePayment.Update(rowPayment); //生成FormPaymentDetail decimal UsedAmount = 0; FormDS.FormSettlementExpenseDetailDataTable tbSettlementExpenseDetail = TAFormSettlementExpenseDetail.GetDataByFormSaleSettlementID(rowSettlement.FormSaleSettlementID); FormDS.FormSettlementExpenseDetailRow rowSettlementExpenseDetail = null; for (int j = 0; j < tbSettlementExpenseDetail.Rows.Count; j++) { rowSettlementExpenseDetail = (FormDS.FormSettlementExpenseDetailRow)tbSettlementExpenseDetail.Rows[j]; rowPaymentDetail = tbPaymentDetail.NewFormSalePaymentDetailRow(); rowPaymentDetail.FormSalePaymentID = rowPayment.FormSalePaymentID; rowPaymentDetail.FormSaleApplyID = rowSettlementExpenseDetail.FormSaleApplyID; rowPaymentDetail.FormSaleExpenseDetailID = rowSettlementExpenseDetail.FormSaleExpenseDetailID; rowPaymentDetail.ApplyFormNo = rowSettlementExpenseDetail.ApplyFormNo; rowPaymentDetail.ApplyPeriod = rowSettlementExpenseDetail.ApplyPeriod; rowPaymentDetail.ApplyProjectName = rowSettlementExpenseDetail.ApplyProjectName; rowPaymentDetail.ExpenseItemID = rowSettlementExpenseDetail.ExpenseItemID; if (!rowSettlementExpenseDetail.IsShopNameNull()) { rowPaymentDetail.ShopName = rowSettlementExpenseDetail.ShopName; } rowPaymentDetail.SKUID = rowSettlementExpenseDetail.SKUID; rowPaymentDetail.ApplyAmount = rowSettlementExpenseDetail.ApplyAmount; rowPaymentDetail.ApplyAmountRMB = rowSettlementExpenseDetail.ApplyAmountRMB; rowPaymentDetail.SettlementAmount = rowSettlementExpenseDetail.AmountRMB; rowPaymentDetail.TaxAmount = 0; //待改动 if (j == tbSettlementExpenseDetail.Rows.Count - 1) { rowPaymentDetail.AmountRMB = PaymentAmount - UsedAmount; rowPaymentDetail.AmountBeforeTax = rowPaymentDetail.AmountRMB; rowPaymentDetail.TaxAmount = rowPaymentDetail.TaxAmount; rowPaymentDetail.PayedAmount = 0; rowPaymentDetail.RemainAmount = 0; UsedAmount += rowPaymentDetail.AmountRMB; } else { rowPaymentDetail.AmountRMB = decimal.Round((rowSettlementExpenseDetail.AmountRMB / rowSettlement.AmountRMB) * PaymentAmount, 2); rowPaymentDetail.AmountBeforeTax = rowPaymentDetail.AmountRMB; rowPaymentDetail.TaxAmount = 0; rowPaymentDetail.PayedAmount = 0; rowPaymentDetail.RemainAmount = 0; UsedAmount += rowPaymentDetail.AmountRMB; } tbPaymentDetail.AddFormSalePaymentDetailRow(rowPaymentDetail); TASalePaymentDetail.Update(tbPaymentDetail); } logDetailRow.PaymentFormNo = rowForm.FormNo; } } transaction.Commit(); } catch (Exception e) { transaction.Rollback(); errorInfor = e.Message.ToString(); } finally { transaction.Dispose(); } return errorInfor; }
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); }
static void Main(string[] args) { //FormReimburseInvoiceTableAdapter taInvoice = new FormReimburseInvoiceTableAdapter(); //FormTableAdapter taForm = new FormTableAdapter(); //FormDS.FormReimburseInvoiceDataTable tbInvoice = taInvoice.GetData(); //foreach (FormDS.FormReimburseInvoiceRow item in tbInvoice) { // if (!item.IsSystemInfoNull()) { // string SystemInfo = item.SystemInfo; // string[] FormNos = SystemInfo.Split(','); // string RepeatFormStr = ""; // if (FormNos.Length > 0) { // foreach (string FormNo in FormNos) { // if (!string.IsNullOrEmpty(FormNo)) { // FormDS.FormDataTable tbForm = taForm.GetDataByFormNo(FormNo); // if (tbForm != null && tbForm.Count > 0) { // RepeatFormStr += "P" + tbForm[0].FormID + ":" + tbForm[0].FormNo + "P"; // } // } // } // } // item.SystemInfo = RepeatFormStr; // taInvoice.Update(item); // } //} //FormReimburseInvoiceTableAdapter taInvoice = new FormReimburseInvoiceTableAdapter(); //FormTableAdapter taForm = new FormTableAdapter(); //FormDS.FormReimburseInvoiceDataTable tbInvoice = taInvoice.GetData(); //foreach (FormDS.FormReimburseInvoiceRow item in tbInvoice) { // if (!item.IsSystemInfoNull()) { // string SystemInfo = item.SystemInfo; // SystemInfo = SystemInfo.Replace("PP", "P"); // string[] FormNos = SystemInfo.Split('P'); // string RepeatFormStr = ""; // if (FormNos.Length > 0) { // foreach (string FormNo in FormNos) { // if (!string.IsNullOrEmpty(FormNo)) { // FormDS.FormDataTable tbForm = taForm.GetDataByID(int.Parse(FormNo.Split(':')[0])); // if (tbForm != null && tbForm.Count > 0) { // RepeatFormStr += "P" + tbForm[0].FormID + ":" + tbForm[0].FormNo + "P"; // } // } // } // } // item.SystemInfo = RepeatFormStr; // taInvoice.Update(item); // } //} FormReimburseInvoiceTableAdapter taInvoice = new FormReimburseInvoiceTableAdapter(); FormTableAdapter taForm = new FormTableAdapter(); FormDS.FormReimburseInvoiceDataTable tbInvoice = taInvoice.GetData(); foreach (FormDS.FormReimburseInvoiceRow item in tbInvoice) { if (!item.IsSystemInfoNull()) { string SystemInfo = item.SystemInfo; SystemInfo = SystemInfo.Replace("PP", "P"); string[] FormNos = SystemInfo.Split('P'); string RepeatFormStr = ""; if (FormNos.Length > 0) { foreach (string FormNo in FormNos) { if (!string.IsNullOrEmpty(FormNo)) { FormDS.FormDataTable tbForm = taForm.GetDataByID(int.Parse(FormNo.Split(':')[0])); if (tbForm != null && tbForm.Count > 0) { RepeatFormStr += "P" + tbForm[0].FormID + ":" + tbForm[0].FormNo + ":" + tbForm[0].PageType + "P"; } } } } item.SystemInfo = RepeatFormStr; taInvoice.Update(item); } } }
//审批方法 public void ApproveForm(APHelper AP, int formID, int stuffUserId, string stuffName, bool pass, string comment, string ProxyStuffName, int OrganizationUnitID) { string email = string.Empty; SqlTransaction transaction = null; try { FormTableAdapter TAMainForm = new FormTableAdapter(); transaction = TableAdapterHelper.BeginTransaction(TAMainForm); FormDS.FormRow formRow = TAMainForm.GetDataByID(formID)[0]; string returnValue = AP.approve(pass, comment, stuffUserId.ToString(), stuffName, formRow.ProcID, ProxyStuffName, formRow.OrganizationUnitID, ref email); string[] approveinfo = AP.GetProcessApproveUser(formRow.ProcID); if (AP.GetProcessIsEnd(formRow.ProcID)) { formRow.LastApprover = stuffUserId.ToString(); formRow.Comment = comment; formRow.ApprovedDate = Convert.ToDateTime(approveinfo[0]); } formRow.ApproverIds = approveinfo[3]; if (returnValue == null) { formRow.InTurnUserIds = "P"; formRow.InTurnPositionIds = "P"; //formRow.SubmitDate = DateTime.Now; if (pass) { //如果审批通过且返回值为空则该流程结束 formRow.StatusID = (int)SystemEnums.FormStatus.ApproveCompleted; //mailTitle = string.Format("您申请的编号为{0}的单据已经通过审批", formRow.FormNo); //mailBody = string.Format(mailBody, formRow.FormNo); //email = AP.getUserEmailByID(formRow.UserID); //AP.sendMail(email, "", mailTitle, mailBody); } else { //如果不通过则为驳回 formRow.StatusID = (int)SystemEnums.FormStatus.Rejected; //mailTitle = string.Format("您有单据申请被{0}退回", stuffName); //mailBody = string.Format(mailBody, formRow.FormNo); //email = AP.getUserEmailByID(formRow.UserID); //AP.sendMail(email, "", mailTitle, mailBody); } } else { string[] InTurn = returnValue.Split('&');//不同流程角色下的人员和职位 string ids = ""; string pids = ""; for (int a = 0; a < InTurn.Length; a++) { ids += InTurn[a].Split('$')[0].ToString(); ///人员 pids += InTurn[a].Split('$')[1].ToString(); //职位 } formRow.InTurnUserIds = ids; //下一步的人员 formRow.InTurnPositionIds = pids; //下一步的人员职位 //mailTitle = string.Format(mailTitle, stuffName, formRow.FormNo); //mailBody = string.Format(mailBody, formRow.FormNo); //AP.sendMail(email, "", mailTitle,mailBody); } TAMainForm.Update(formRow); transaction.Commit(); } catch (Exception ex) { if (transaction != null) { transaction.Rollback(); } throw ex; } finally { if (transaction != null) { transaction.Dispose(); } } //System.Threading.Thread.Sleep(3000); }