当前文件路径：KeXinCrm/ContractADD.aspx.cs

		            
  1using System;
  2using System.Collections;
  3using System.ComponentModel;
  4using System.Data;
  5using System.Drawing;
  6using System.Web;
  7using System.Web.SessionState;
  8using System.Web.UI;
  9using System.Web.UI.WebControls;
 10using System.Web.UI.HtmlControls;
 11using System.Data.SqlClient;
 12
 13namespace CRMS
 14...{
 15    /**//// <summary>
 16    /// ContractADD 的摘要说明。
 17    /// </summary>
 18    public partial class ContractADD : System.Web.UI.Page
 19    ...{
 20        data hsjdata=new data();
 21    
 22        protected void Page_Load(object sender, System.EventArgs e)
 23        ...{
 24            // 在此处放置用户代码以初始化页面
 25            
 26            if(Session["managerin"]==null)
 27            ...{
 28                Response.Redirect("login.aspx");
 29            }
 30            if(Session["MemberState"].ToString()=="关闭")
 31            ...{
 32                Response.Redirect("ErrorPage.aspx?ErrMms=对不起，您的帐号已经被停止使用！");
 33            }
 34            if(Session["MemberAuthority"].ToString()!="系统管理员")
 35            ...{
 36                Response.Redirect("ErrorPage.aspx?ErrMms=对不起，您无权管理该项！");
 37            }
 38            
 39            int CompanyID=Convert.ToInt16(Request.QueryString["CompanyID"]);
 40            string sql="SELECT CompanyName,CompanyContact,Telephone,Cellphone,CompanyAddress,RealName FROM VIEW_Contract WHERE CompanyID="+CompanyID+"";
 41            try
 42            ...{
 43                SqlDataReader dr=hsjdata.readrow(sql);
 44                CompanyName.Text=dr.GetValue(0).ToString();
 45                CompanyContact.Text=dr.GetValue(1).ToString();
 46                Telephone.Text=dr.GetValue(2).ToString();
 47                Cellphone.Text=dr.GetValue(3).ToString();
 48                CompanyAddress.Text=dr.GetValue(4).ToString();
 49                RealName.Text=dr.GetValue(5).ToString();
 50            }
 51            catch
 52            ...{
 53                    Response.Redirect("ErrorPage.aspx?ErrMms=初始化错误！");
 54            }
 55
 56        }
 57
 58        Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
 59        override protected void OnInit(EventArgs e)
 60        ...{
 61            //
 62            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
 63            //
 64            InitializeComponent();
 65            base.OnInit(e);
 66        }
 67        
 68        /**//// <summary>
 69        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 70        /// 此方法的内容。
 71        /// </summary>
 72        private void InitializeComponent()
 73        ...{    
 74
 75        }
 76        #endregion
 77
 78        protected void Button1_Click(object sender, System.EventArgs e)
 79        ...{
 80            //更新企业表内容Company
 81            int T_CompanyID=Convert.ToInt16(Request.QueryString["CompanyID"]);
 82            string T_CompanyName=Request.Form["CompanyName"];
 83            string T_CompanyContact=Request.Form["CompanyContact"];
 84            string T_Telephone=Request.Form["Telephone"];
 85            string T_Cellphone=Request.Form["Cellphone"];
 86            string T_CompanyAddress=Request.Form["CompanyAddress"];
 87            string sql="UPDATE Company set CompanyName='"+T_CompanyName+"',CompanyContact='"+T_CompanyContact+"',Telephone='"+T_Telephone+"',Cellphone='"+T_Cellphone+"',CompanyAddress='"+T_CompanyAddress+"',Operation='签订合同' Where CompanyID="+T_CompanyID+"";
 88            //Response.Write (sql);
 89            //Response.End();
 90            try
 91            ...{
 92                hsjdata.moddata(sql);
 93            }
 94            catch
 95            ...{
 96                Response.Redirect("ErrorPage.aspx?ErrMms=数据更新时发生错误，请查证！");
 97            }
 98            //添加合同详细内容到Contract
 99            //合同状态分为：执行、终止、续费、到期
100            string T_addtime=Request.Form["addtime"].Trim();
101            string T_ContractNo=Request.Form["ContractNo"].Trim();
102            string T_Content=Request.Form["Content"].Trim();
103            string T_Amount=Request.Form["Amount"].Trim();
104            string T_ContractClass=Request.Form["ContractClass"].Trim();
105            int T_Endtime=Convert.ToInt16(Endtime.SelectedItem.Value);
106            DateTime dt=Convert.ToDateTime(T_addtime).AddYears(T_Endtime);
107            //检验数据库中是否有相同类型的合同（主要验证合同类型及合同签署单位）
108            string strsql="SELECT ContractClass FROM Contract Where ContractClass='"+T_ContractClass+"' AND CompanyID="+T_CompanyID+"";
109            //Response.Write(strsql);
110            //    Response.End();
111            if(hsjdata.datareader(strsql))
112            ...{
113                Response.Redirect("ErrorPage.aspx?ErrMms=对不起，"+T_CompanyName+"的合同"+T_ContractClass+"已经存在！");
114            }
115            else
116            ...{
117                string SQL="insert into Contract (addtime,Endtime,ContractNo,Content,CompanyID,Amount,ContractClass,zt) values('"+T_addtime+"','"+dt+"','"+T_ContractNo+"','"+T_Content+"',"+T_CompanyID+","+T_Amount+",'"+T_ContractClass+"','执行')";
118                //Response.Write (SQL);
119                //Response.End();
120                try
121                ...{
122                    hsjdata.moddata(SQL);
123                    Response.Write("<script>alert('添加合同操作成功！');window.location.href='Javascript:history.go(-2)'</script>");
124                }
125                catch 
126                ...{
127                    Response.Redirect("ErrorPage.aspx?ErrMms=数据库插入错误，请查证！");
128                    return;
129                }
130            }
131
132
133        }
134    }
135}
136