addcompact.aspx.cs

一个简单的信息系统 系统用户管理 编辑系统用户 新增系统用户

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class addcompact : System.Web.UI.Page
{

    SqlConnection cn;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["branch"].ToString() == "0" || Session["branch"].ToString() == "1" || Session["branch"].ToString() == "2")
        {
           
        }
        else
        {
            Response.Write("您不是合法用户，请登入后再操作，<a href='default.aspx'>返回登录</a>");
            Page.Response.End();
        }
        string strconn = ConfigurationSettings.AppSettings["ConnectionString"];
        cn = new SqlConnection(strconn);
    }
    private void Cv_id_ServerValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args)
    {
        cn.Open();
        SqlCommand cm = new SqlCommand("select * from compact where compact_id=@compact_id", cn);
        cm.Parameters.Add("@compact_id", SqlDbType.VarChar, 20);
        cm.Parameters["@compact_id"].Value = compact_id.Text;
        SqlDataReader dr = cm.ExecuteReader();
        if (dr.Read())
        {
            args.IsValid = false;
        }
        else
        {
            args.IsValid = true;
        }
        cn.Close();
    }
    protected void Btn_ok_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            SqlCommand cm = new SqlCommand("Addcompact", cn);
            cm.CommandType = CommandType.StoredProcedure;
            cm.Parameters.Add(new SqlParameter("@compact_id", SqlDbType.VarChar, 20));
            cm.Parameters.Add(new SqlParameter("@Client_id", SqlDbType.VarChar, 20));
            cm.Parameters.Add(new SqlParameter("@person", SqlDbType.VarChar, 20));
            cm.Parameters.Add(new SqlParameter("@price", SqlDbType.Money, 8));            
            cm.Parameters.Add(new SqlParameter("@start", SqlDbType.DateTime, 8));
            cm.Parameters.Add(new SqlParameter("@send", SqlDbType.DateTime, 8));
            cm.Parameters.Add(new SqlParameter("@finish", SqlDbType.DateTime, 8));
            cm.Parameters.Add(new SqlParameter("@state", SqlDbType.Char, 10));
            cm.Parameters["@compact_id"].Value = compact_id.Text;
            cm.Parameters["@Client_id"].Value = DropDownList1.SelectedItem.Value;
            cm.Parameters["@person"].Value = compact_person.Text;
            cm.Parameters["@price"].Value = compact_price.Text;           
            cm.Parameters["@start"].Value = compact_start.Text;
            cm.Parameters["@send"].Value = compact_send.Text;
            cm.Parameters["@finish"].Value = compact_finish.Text;
            cm.Parameters["@state"].Value = compact_state.SelectedItem.Value;
            cm.Connection.Open();
            try
            {
                cm.ExecuteNonQuery();
                Response.Redirect("editcompact.aspx");
            }
            catch (SqlException)
            {
                Lbl_note.Text = "添加失败";
                Lbl_note.Style["color"] = "red";
            }
            cm.Connection.Close();
        }
    }
    protected void Btn_cancel_Click(object sender, EventArgs e)
    {
        Page.Response.Redirect("addcompact.aspx");
    }
}