我现在做一个毕业设计是企业客户服务系统，
我的qq号是635500852,如果详细说明的话，请加我qq!
namespace CustomerServiceSys.Modules
{
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Drawing;
using System.Web;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
/// <summary>
/// RecordAddModule 的摘要说明。
/// </summary>
public class RecordAddModule :ModuleBase
{
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.TextBox ClientIdTextBox;
protected System.Web.UI.WebControls.Label Label5;
protected System.Web.UI.WebControls.TextBox CNameTextBox;
protected System.Web.UI.WebControls.Label Label9;
protected System.Web.UI.WebControls.TextBox PhoneTextBox;
protected System.Web.UI.WebControls.Label Label12;
protected System.Web.UI.WebControls.DropDownList LevelList;
protected System.Web.UI.WebControls.CustomValidator LevelCustomvalidator;
protected System.Web.UI.WebControls.Label Label14;
protected System.Web.UI.WebControls.TextBox RDetailsTextBox;
protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator2;
protected System.Web.UI.WebControls.Label Label17;
protected System.Web.UI.WebControls.DropDownList StatusList;
protected System.Web.UI.WebControls.CustomValidator StatusCustomvalidator;
protected System.Web.UI.WebControls.Label Label20;
protected System.Web.UI.WebControls.Label UserNameLabel;
protected System.Web.UI.WebControls.Label Label21;
protected System.Web.UI.WebControls.TextBox FinishDateTextBox;
protected System.Web.UI.WebControls.Label Label22;
protected System.Web.UI.WebControls.Label Label23;
protected System.Web.UI.WebControls.TextBox RemarksTextBox;
protected System.Web.UI.WebControls.Label Label24;
protected System.Web.UI.WebControls.RadioButtonList ResearchList;
protected System.Web.UI.WebControls.Label ShowMsg;
protected System.Web.UI.WebControls.ValidationSummary ValidationSummary1;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator7;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
protected System.Web.UI.WebControls.Label NowTimeLabel;
protected System.Web.UI.WebControls.Button ReturnButton;
protected System.Web.UI.WebControls.Button SubmitButton;
protected System.Web.UI.WebControls.Image Image1;
private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
//显示录入人信息
UserNameLabel.Text=HttpContext.Current.User.Identity.Name;
//显示登记时间
NowTimeLabel.Text=DateTime.Now.ToString();
}
}
//检验严重级别列表框是否填写
public void LevelNotNullValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args)
{
if(LevelList.SelectedIndex==0)
{
args.IsValid =false;//未填写
}
else
{
args.IsValid =true;//已填写
}
}
//检验状态列表框是否填写
public void StatusNotNullValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args)
{
if(StatusList.SelectedIndex==0)
{
args.IsValid =false;//未填写
}
else
{
args.IsValid =true;//已填写
}
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器
/// 修改此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.SubmitButton.Click += new System.EventHandler(this.SubmitButton_Click);
this.ReturnButton.Click += new System.EventHandler(this.ReturnButton_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void SubmitButton_Click(object sender, System.EventArgs e)
{
if(Page.IsValid)
{
//从文件Web.config中读取连接字符串
string sqldb= ConfigurationSettings.AppSettings["ConnectionString"];
//连接JdglSys数据库
SqlConnection Conn= new SqlConnection (sqldb);
Conn.Open ();
//利用Command对象调用存储过程
SqlCommand mycommand=new SqlCommand ("sp_InsertRecord",Conn);
//将命令类型转为存储类型
mycommand.CommandType =CommandType.StoredProcedure ;
//往存储过程中添加参数
mycommand.Parameters .Add ("@ClientName",SqlDbType.NVarChar);
mycommand.Parameters .Add ("@CPerson",SqlDbType.NVarChar);
mycommand.Parameters .Add ("@CTel",SqlDbType.NVarChar);
mycommand.Parameters .Add ("@RLevel",SqlDbType.NVarChar);
mycommand.Parameters .Add ("@RDetails",SqlDbType.NVarChar);
mycommand.Parameters .Add ("@RStatus",SqlDbType.NVarChar);
mycommand.Parameters .Add ("@LogPerson",SqlDbType.NVarChar);
mycommand.Parameters .Add ("@CreateDate",SqlDbType.DateTime);
mycommand.Parameters .Add ("@FinishDate",SqlDbType.DateTime);
mycommand.Parameters .Add ("@Remarks",SqlDbType.NVarChar);
mycommand.Parameters .Add ("@IsResearch",SqlDbType.Int);
//给存储过程的参数赋值
mycommand.Parameters ["@ClientName"].Value =ClientIdTextBox.Text.Trim();
mycommand.Parameters ["@CPerson"].Value = CNameTextBox.Text.Trim();
mycommand.Parameters ["@CTel"].Value =PhoneTextBox.Text.Trim();
mycommand.Parameters ["@RLevel"].Value =LevelList.SelectedIndex;
mycommand.Parameters ["@RDetails"].Value =RDetailsTextBox.Text.Trim();
mycommand.Parameters ["@RStatus"].Value =StatusList.SelectedIndex;
mycommand.Parameters ["@LogPerson"].Value =UserNameLabel.Text.Trim();
mycommand.Parameters ["@CreateDate"].Value =NowTimeLabel.Text.Trim();
if(FinishDateTextBox.Text=="")
mycommand.Parameters ["@FinishDate"].Value ="2000-1-1";
else
mycommand.Parameters ["@FinishDate"].Value =FinishDateTextBox.Text.Trim();
mycommand.Parameters ["@Remarks"].Value =RemarksTextBox.Text.Trim();
mycommand.Parameters ["@IsResearch"].Value =ResearchList.SelectedIndex;
try
{
mycommand.ExecuteNonQuery();
ShowMsg.Text="新客户记录添加成功";
ShowMsg.Style["color"]="green";
}
catch(SqlException error)
{
ShowMsg.Text="添加未成功，请稍后再试。原因："+error.Message;
ShowMsg.Style["color"]="red";
}
//关闭连接
Conn.Close();
}
}
private void ReturnButton_Click(object sender, System.EventArgs e)
{
Response.Redirect(PathPrefix+"/RecordMan.aspx");
}
}
}
