//启动流程
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 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));
}
//审批方法
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);
}
public void ScrapForm(int FormID)
{
FormDS.FormRow formRow = new FormTableAdapter().GetDataByID(FormID)[0];
formRow.StatusID = (int)SystemEnums.FormStatus.Scrap;
new FormTableAdapter().Update(formRow);
}
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);
}
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);
}
}
}
