khinfo.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 ZDWH_KHInfo : System.Web.UI.Page
{
    SqlCommand cmd=null;
    SqlDataAdapter dtcmd;    
    static string theModiCode; //表示当前正在修改的购书单位代码   
    SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["connection"]);
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!IsPostBack)
        {

            if (Session["DispUser"] == null)
            {
                Session["DispUser"] = "";
                Session["logintime"] = "";
            }
            //Page.RegisterStartupScript("", getSessionInfo(Session["DispUser"].ToString(), Session["logintime"].ToString()));
            string url = Request.RawUrl.ToString();
            if (Session["CurrUser"] == null)
                Response.Redirect("../Index.aspx?handle=" + url);
        }
        BindGrid();
    }
    public void BindGrid()
    {
        SqlDataReader dataR = null;
        DataTable dt = new DataTable();
        string str1 = String.Empty;
        string str2 = String.Empty;
        if (query_content.Text != "")
            str1 = " where " + query_tj.SelectedItem.Value + " like '%" + query_content.Text + "%'";
        str2 = "select count(*) as nums from buyerinfosheet " + str1;
        cmd = new SqlCommand(str2, conn);
        conn.Open();
        dataR = cmd.ExecuteReader();
        if (dataR.Read())
        {
            if (dataR["nums"].ToString() == "0")
                Msg.Text = "";
            else
                Msg.Text = "合计：记录数 " + dataR["nums"].ToString();
        }
        dataR.Close();
        str1 = "select * from buyerinfosheet " +str1+ " order by code";
        dtcmd = new SqlDataAdapter(str1, conn);
        dtcmd.Fill(dt);
        //DataGrid1.DataSource = Socut.Data.ExecuteDataSet(str1, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize);
        //DataGrid1.DataBind();
        DataGrid1.DataSource = dt;
        DataGrid1.DataBind();
        conn.Close();     
        
    }
    protected void Query_Click(object sender, EventArgs e)
    {
        BindGrid();
    }
    public string getalertinfo(string str1)
    {
        string str;
        str = "<script language='javascript'>alert('" + str1 + "')</script>";
        return str.Trim();
    }
    protected void Grid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {
        this.DataGrid1.CurrentPageIndex = e.NewPageIndex;
        BindGrid();
    }
    protected void Clear_Click(object sender, EventArgs e)
    {
        switch(ClearBtn.Text)
        {  
            case "清  空":
                ClearData();
                return;
            case "取  消":
                ClearData();
                theModiCode = "";
                SaveBtn.Text = "保  存";
                ClearBtn.Text = "清  空";
                return;
        }
    }
    public void ClearData()
    {
        Name.Text = "";
        Addr.Text = "";
        tel.Text = "";
        lxr.Text = "";
        faxno.Text = "";
        zipcode.Text = "";
        bankname.Text = "";
        account.Text = "";
        Email.Text = "";
        shui.Text = "";
    }
    protected void Save_Click(object sender, EventArgs e)
    {
        #region //获取信息;
        string NameStr = Name.Text;
        string AddrStr = Addr.Text;
        string TelStr = tel.Text;
        string LxrStr = lxr.Text;
        string FaxNoStr = faxno.Text;
        string ZipcodeStr = zipcode.Text;
        string BankStr = bankname.Text;
        string AccountStr = account.Text;
        string EmailStr = Email.Text;
        string shuiStr = shui.Text;
        SqlDataReader dataR;
        string BuyerCode;
        string sql;
        #endregion
        switch (SaveBtn.Text)
        {
            case "保  存": //表示该记录是新增信息
                conn.Open();
                sql = "select * from buyerinfosheet order by code desc";
                cmd = new SqlCommand(sql, conn);
                dataR = cmd.ExecuteReader();
                if (dataR.Read())
                {
                    Int32 temp = Convert.ToInt32(dataR["code"].ToString()) + 1;
                    BuyerCode = temp.ToString("000");
                }
                else
                    BuyerCode = "001";
                dataR.Close();
                sql = "insert into buyerinfosheet(code,name,address,zipcode,telno,faxno,emailbox,connector,bankname,account,shuicode) values('" + BuyerCode + "','" + NameStr + "','" + AddrStr + "','" + ZipcodeStr + "','" + TelStr + "','" + FaxNoStr + "','" + EmailStr + "','" + LxrStr + "','" + BankStr + "','" + AccountStr + "','" + shuiStr + "')";
                cmd = new SqlCommand(sql, conn);
                cmd.ExecuteNonQuery();
                ClearData();
                BindGrid();
                Page.RegisterStartupScript("", getalertinfo("数据保存成功！"));
                conn.Close();
                return;
            case "修  改"://表示该记录是修改信息
                conn.Open();              
                sql = "update buyerinfosheet set name='" +NameStr+ "',address='" +AddrStr+ "',zipcode='" +ZipcodeStr+ "',telno='" +TelStr+ "',faxno='" +FaxNoStr+ "',emailbox='" +EmailStr+ "',connector='" +LxrStr+ "',bankname='" +BankStr+ "',account='" +AccountStr+ "',shuicode='" +shuiStr+ "' where code='" +theModiCode+ "'";
                cmd = new SqlCommand(sql, conn);
                cmd.ExecuteNonQuery();
                conn.Close();
                SaveBtn.Text = "保  存";
                ClearBtn.Text = "清  空";
                ClearData();
                BindGrid();
                Page.RegisterStartupScript("", getalertinfo("数据修改成功！"));
                return;
        }
    }

    protected void Grid1_Edit(object source, DataGridCommandEventArgs e)
    {
        string codeStr = e.Item.Cells[0].Text;
        string sql;
        SqlDataReader dataR;
        if (e.CommandName.ToString() == "Edit")
        {
            //编辑操作
            Name.Text = e.Item.Cells[1].Text;
            Addr.Text = e.Item.Cells[2].Text.Replace("&nbsp;","");
            tel.Text = e.Item.Cells[4].Text.Replace("&nbsp;","");
            lxr.Text = e.Item.Cells[3].Text.Replace("&nbsp;","");
            faxno.Text = e.Item.Cells[8].Text.Replace("&nbsp;","");
            zipcode.Text = e.Item.Cells[7].Text.Replace("&nbsp;", "");
            bankname.Text = e.Item.Cells[5].Text.Replace("&nbsp;","");
            account.Text = e.Item.Cells[6].Text.Replace("&nbsp;","");
            Email.Text = e.Item.Cells[10].Text.Replace("&nbsp;","");
            shui.Text = e.Item.Cells[9].Text.Replace("&nbsp;","");          
            theModiCode = e.Item.Cells[0].Text.Trim();
            SaveBtn.Text = "修  改";
            ClearBtn.Text = "取  消";
        }
        else
        {
            //删除操作
            ClearData();
            theModiCode = "";
            SaveBtn.Text = "保  存";
            ClearBtn.Text = "清  空";
            sql = "select * from outstoresheetz where buyercode='" + codeStr + "'";
            cmd = new SqlCommand(sql, conn);
            conn.Open();
            dataR = cmd.ExecuteReader();
            if (dataR.Read())
                Page.RegisterStartupScript("", getalertinfo("该单位存在购书信息，无法删除！"));
            else
            {
                dataR.Close();
                sql = "select * from recretbooksheet where buyercode='" + codeStr + "'";
                cmd = new SqlCommand(sql, conn);
                dataR = cmd.ExecuteReader();
                if (dataR.Read())
                    Page.RegisterStartupScript("", getalertinfo("该单位存在退书信息，无法删除！"));
                else
                {
                    
                    dataR.Close();
                    sql = "delete from buyerinfosheet where code='" + codeStr + "'";
                    cmd = new SqlCommand(sql, conn);
                    cmd.ExecuteNonQuery();
                    conn.Close();
                    BindGrid();
                }
            }
        }        
    }
    protected void DataGrid1_DeleteCommand(object source, DataGridCommandEventArgs e)
    {
        #region 用来判断当前删除是否为当前页的最后一条记录
        if ((this.DataGrid1.CurrentPageIndex == this.DataGrid1.PageCount - 1) && this.DataGrid1.Items.Count == 1)
        {
            if (this.DataGrid1.CurrentPageIndex - 1 > 1)
            {
                this.DataGrid1.CurrentPageIndex = this.DataGrid1.CurrentPageIndex - 1;
            }
            else
            {
                this.DataGrid1.CurrentPageIndex = 0;
            }
        }
        #endregion
    }
}