ERP合同管理二（三十）

ERP合同管理二（三十）

未审核表单列表显示:

if (Request.QueryString["taskid"] != null && Request.QueryString["listid"] != null) { contractid = Request.QueryString["taskid"].ToString(); tasklistid = Request.QueryString["listid"].ToString(); } else { Response.Write(""); }

防止匿名登录：登录后将基本信息保存至Session["Userid"],如果每个页面加载时候判断Session["Userid"]，如果为空则跳转至指定登录页面。

public BasePage() { this.Load += new EventHandler(BasePage_Load); } void BasePage_Load(object sender, EventArgs e) { Session["Userid"] = "29"; if (Session["Userid"] == null) { Response.Redirect("~/Web/UserLogin.aspx"); } }

用法：

public partial class CRMContractEidt:BasePage { protected void Page_Load(object sender, EventArgs e) { this.txtCreatTime.Text = DateTime.Now.ToString("yyyy-MM-dd"); if (!IsPostBack) { pageinfo(); } }}

合同基础信息表：

///

/// 合同基础信息表 ///

/// 编号 /// ViewContactInfo public ViewContactInfo getViewContactInfoByContactID2(string contactid,string listid) { SqlDataReader reader = SqlComm.GetDataReaderByCondition("BioCRMContract", "*", " ContractID=" + contactid); ViewContactInfo contactinfo= new ViewContactInfo(); if (reader.Read()==true) { contactinfo.UserID = Convert.ToInt32(reader["UserID"].ToString()); contactinfo. AssessorAuditing = Convert.ToBoolean(reader["AssessorAuditing"].ToString()); contactinfo.ContractDesc = reader["ContractDesc"].ToString(); contactinfo.ContractID = Convert.ToInt32(reader["ContractID"].ToString()); contactinfo.ContractName = reader["ContractName"].ToString(); contactinfo.ContractNumber = reader["ContractNumber"].ToString(); contactinfo.ContractSum = Decimal.Parse(reader["ContractSum"].ToString()); contactinfo.ContractType = reader["ContractType"].ToString(); contactinfo.CreateTime = Convert.ToDateTime(reader["CreateTime"].ToString()); contactinfo.CustomerID = Convert.ToInt32(reader["CustomerID"].ToString()); contactinfo.DeleteState = Convert.ToBoolean(reader["DeleteState"].ToString()); contactinfo.EndTime = Convert.ToDateTime(reader["EndTime"].ToString()); contactinfo. EffectiveTime = Convert.ToDateTime(reader["EffectiveTime"].ToString()); contactinfo. ExecutiveState = reader["ExecutiveState"].ToString(); contactinfo.SignTime = Convert.ToDateTime(reader["SignTime"].ToString()); } reader.Close(); return contactinfo; }

显示的前端代码：

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="CRMContractShow.aspx.cs" Inherits="BioErpWeb.CRMSystem.CRMContract.CRMContractShow" %>

合同审核
合同名称		下次审批人		合同负责人		所属部门
签约客户		签约金额	元（RMB）	合同创建时间		计划签约时间
生效时间		截止
合同内容
合同附件	(下载)					合同类型	买卖合同 运输合同 技术合同 保管合同 仓储合同 委托合同
历史意见
审批意见

后端的代码：

public partial class CRMContractShow : BasePage { protected void Page_Load(object sender, EventArgs e) { this.txtCreatTime.Text = DateTime.Now.ToString("yyyy-MM-dd"); if (!IsPostBack) { pageinfo(); //遍历页面所有TextBox控件，设置为只读 TextBox txt = null; foreach (Control c in Page.Controls) { if (c.GetType().Name == "HtmlForm") { foreach (Control c1 in c.Controls) { if (c1.GetType().Name == "TextBox") { txt = ((TextBox)c1); txt.ReadOnly = true; } } } } } } static byte[] filecontent = null; static string contractid = ""; static string tasklistid = ""; static string documentsid = ""; ///

/// 绑定页面信息 ///

protected void pageinfo() { contractid ="8"; tasklistid ="7"; #region 从合同信息表中绑定数据 CrmContractBLL cbll = new CrmContractBLL(); ViewContactInfo contactinfo = new ViewContactInfo(); contactinfo = cbll.getViewContactInfoByContactID2(contractid, tasklistid); this.txtName.Text = contactinfo.ContractName; this.txtUser2.Text = contactinfo.UserID.ToString(); this.txtSinTime.Text = Convert.ToDateTime(contactinfo.SignTime.ToString()).ToString("yyyy-MM-dd"); this.txtCreatTime.Text = Convert.ToDateTime(contactinfo.CreateTime.ToString()).ToString("yyyy-MM-dd"); this.txtCustomer.Text = contactinfo.CustomerID.ToString(); this.txtSum.Text = Convert.ToDecimal(contactinfo.ContractSum.ToString()).ToString("0.00"); this.txtEffectiveTime.Text = Convert.ToDateTime(contactinfo.EffectiveTime).ToString("yyyy-MM-dd"); this.txtDesc.Text = contactinfo.ContractDesc; this.txtEndTime.Text = Convert.ToDateTime(contactinfo.EndTime).ToString("yyyy-MM-dd"); this.ddlType.SelectedItem.Text = contactinfo.ContractType.ToString(); this.cbIsCheck.Checked =bool.Parse(contactinfo.AssessorAuditing.ToString()); #endregion #region 从流程表中绑定数据 //1代表 合同管理表单 System.Data.DataTable dt = SqlComm.getTaskListRecordsByCondition(contractid, "1"); System.Data.DataRow[] dr0 = dt.Select(" listID=" + tasklistid); string historys = ""; for (int i = 1; i < dt.Rows.Count; i++) { historys+= dt.Rows[i]["Mind"].ToString() + " " + Convert.ToDateTime(dt.Rows[i]["SumitTime"].ToString()).ToString("yyyy-MM-dd")+"
"; } if (historys.Length == 0) { historys = "暂无审核意见"; } this.lbHistory.Text = historys; this.txtDepartMentID.Text = dr0[0].ItemArray[12].ToString(); this.txtUser1.Text = dr0[0].ItemArray[5].ToString(); #endregion filecontent = Comm.GetDownDocumet("BioCrmCorrelationDocument", "Content", " DocumentID=" + contactinfo.DocumentID); documentsid = contactinfo.DocumentID.ToString(); if (SqlComm.getUserRightsByUserId(Session["Userid"].ToString()).Contains("45") || this.cbIsCheck.Checked==true) { this.lbIsCheck.Visible = true; this.cbIsCheck.Visible = true; } else { this.lbIsCheck.Visible = false; this.cbIsCheck.Visible = false; } } ///

/// 下载 ///

/// /// protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { if (filecontent == null) { ClientScript.RegisterStartupScript(this.GetType(), "test", "alert('没有要下载的文档')", true); return; } //创建弹出式Windows下载窗体 Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(this.txtName.Text)); //把二进制数组写入Http输出流 Response.BinaryWrite(filecontent); //想当前客户端缓冲区输出 Response.Flush(); //停止执行 Response.End(); } }

合同审单执行：

业务逻辑代码：

//判断当前登录用户是否是被提交人 if (dr0[0].ItemArray[5].ToString() == Session["Userid"].ToString()) { //45法律资质审核权限 if (SqlComm.getUserRightsByUserId(Session["Userid"].ToString()).Contains("45")) { this.lbIsCheck.Visible = true; this.cbIsCheck.Visible = true; this.btnRun.Visible = true; } else { this.lbIsCheck.Visible = false; this.cbIsCheck.Visible = false; this.btnRun.Visible = false; } } //如果当前登录用户是合同负责人（第一次提交合同申请的用户） if (dr0[0].ItemArray[10].ToString() == Session["Userid"].ToString()) { this.FileUpload1.Visible = true; }else { this.FileUpload1.Visible = false; }

///

/// 下载 ///

/// /// protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { if (filecontent == null) { ClientScript.RegisterStartupScript(this.GetType(), "test", "alert('没有要下载的文档')", true); return; } //创建弹出式Windows下载窗体 Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(this.txtName.Text)); //把二进制数组写入Http输出流 Response.BinaryWrite(filecontent); //想当前客户端缓冲区输出 Response.Flush(); //停止执行 Response.End(); } protected void btnRun_Click(object sender, EventArgs e) { CrmContractBLL conbll = new CrmContractBLL(); BioCRMContract contract = new BioCRMContract(); TaskListRecord tasklistRecord = null; BioCrmCorrelationDocument document = null; //获取合同相关信息 contract.ContractID = int.Parse(contractid); contract.UserID = int.Parse(this.txtUser2.Text); contract.ContractName = this.txtName.Text; contract.CustomerID = int.Parse(this.txtCustomer.Text); contract.ContractSum = decimal.Parse(this.txtSum.Text); contract.ContractType = this.ddlType.SelectedValue; contract.EndTime = Convert.ToDateTime(this.txtEndTime.Text); contract.EffectiveTime = Convert.ToDateTime(this.txtEffectiveTime.Text); contract.SignTime = Convert.ToDateTime(this.txtSinTime.Text); contract.ContractDesc = this.txtDesc.Text; contract.ExecutiveState = "待审核"; if (this.cbIsCheck.Visible == true) { contract.AssessorAuditing = cbIsCheck.Checked; } contract.CreateTime = Convert.ToDateTime(this.txtCreatTime.Text); int count = conbll.BioCRMContractaUpdate(contract); //文档基本信息 if (this.FileUpload1.HasFile) { document = new BioCrmCorrelationDocument() { DocumentID = int.Parse(documentsid.ToString()), Subject = this.txtName.Text, Content = this.FileUpload1.FileBytes, DocumentSize = this.FileUpload1.FileContent.Length, Type = this.FileUpload1.PostedFile.ContentType, ExetendName = System.IO.Path.GetExtension(this.FileUpload1.FileName), DocumentLevel = "绝密", Name = this.FileUpload1.FileName, Remark = "合同附件文档", UserID = int.Parse(this.txtUser2.Text), UploadTime = DateTime.Now }; BioCrmCorrelationDocumentBLL documentbll = new BioCrmCorrelationDocumentBLL(); documentbll.BioCrmCorrelationDocumentUpdate(document); } tasklistRecord = new TaskListRecord() { Accepter = int.Parse(this.txtUser2.Text), Transmitter = int.Parse(Session["Userid"].ToString()), AuditingSate =2, DepartMentId = int.Parse(this.txtDepartMentID.Text), FirstAccepter = int.Parse(this.hf_FirstAccepter.Value), FirstSumitTime = Convert.ToDateTime(this.hf_FirstDateTime.Value), FirstTransmitter = int.Parse(this.hf_FirstTransmitter.Value), Mind = this.txtMind.Text, Pass = 1, Subject = this.txtName.Text, SumitTime = DateTime.Now, TaskID = int.Parse(contractid), TaskTableID = 1 }; //向流程表添加一条新的记录 if (SqlComm.TaskListRecordAdd(tasklistRecord) != 0) { SqlComm.UpdateTableByCondition("dbo.TaskListRecord", " AuditingSate=1", " ListID=" + tasklistid); ClientScript.RegisterStartupScript(this.GetType(), "test", "alert('合同申请提交成功,下次审批人员编号：" + this.txtUser1.Text + "')", true); } }

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。