bookregisteredit.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;
//该源码下载自【编程联盟】ASp.Net下载中心 【 http://aspx.bcbbs.net 】
//该源码下载自【编程联盟】ASp.Net下载中心 【 http://aspx.bcbbs.net 】
//该源码下载自【编程联盟】ASp.Net下载中心 【 http://aspx.bcbbs.net 】
//该源码下载自【编程联盟】ASp.Net下载中心 【 http://aspx.bcbbs.net 】

public partial class Pages_BookRegisterEdit : System.Web.UI.Page
{
    //更新标志
    public static string Update_Flag;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //取得参数
            string strCode = Request.QueryString["ID"];

            //判断是添加还是编辑
            if (strCode == null || strCode == "")
            {
                //设置标题
                this.Title = "图书登记管理--添加";

                //设置更新标志
                Update_Flag = "Add";

            }
            else
            {
                //设置标题
                this.Title = "图书登记管理--编辑";

                //保存参数
                lblID.Text = strCode;

                //设置更新标志
                Update_Flag = "Update";

                //绑定信息
                BindData();
            }
        }
    }

    private void BindData()
    {
        //定义一个连接对象
        SqlConnection conn = new SqlConnection("server=(local);database=school;uid=sa;pwd=");

        //SQL 语句
        string strSql = "select * from BookRegister where RegisterID='" + lblID.Text + "'";

        //定义一个适配器,从数据库中去数据
        SqlDataAdapter adapter = new SqlDataAdapter(strSql, conn);

        //定义数据集
        DataSet dsBook = new DataSet();

        conn.Open();

        //用适配器填充数据集
        adapter.Fill(dsBook, "Book");

        conn.Close();

        //将信息赋给控件 
        if (dsBook != null)
        {
            
            txtBookName.Text = dsBook.Tables[0].Rows[0]["BookName"].ToString();
            txtPublish.Text = dsBook.Tables[0].Rows[0]["PublishingHouse"].ToString();
            txtChief_editor.Text = dsBook.Tables[0].Rows[0]["Chief_editor"].ToString();
            txtProofread.Text = dsBook.Tables[0].Rows[0]["Proofread"].ToString();
            txtFormatDesign.Text = dsBook.Tables[0].Rows[0]["FormatDesign"].ToString();
            txtCoverDesign.Text = dsBook.Tables[0].Rows[0]["CoverDesign"].ToString();
            txtPrice.Text = dsBook.Tables[0].Rows[0]["Price"].ToString();
            txtQuantity.Text = dsBook.Tables[0].Rows[0]["Quantity"].ToString();
            txtStorageSites.Text = dsBook.Tables[0].Rows[0]["StorageSites"].ToString();
            txtAppendix.Text = dsBook.Tables[0].Rows[0]["Appendix"].ToString();
            txtRegisterDate.Text = dsBook.Tables[0].Rows[0]["RegisterDate"].ToString();
            txtPrincipal.Text = dsBook.Tables[0].Rows[0]["PrincipalPeople"].ToString();
            txtBrief.Text = dsBook.Tables[0].Rows[0]["Brief"].ToString();
            txtRemark.Text = dsBook.Tables[0].Rows[0]["Remarks"].ToString();
            for (int i = 0; i < ddlBookType.Items.Count; i++)
            {
                if (ddlBookType.Items[i].Text.ToString() == dsBook.Tables[0].Rows[0]["BookType"].ToString())
                {
                    ddlBookType.SelectedIndex = i;
                    break;
                }
            }
            for (int i = 0; i < ddlUnit.Items.Count; i++)
            {
                if (ddlUnit.Items[i].Text.ToString() == dsBook.Tables[0].Rows[0]["Unit"].ToString())
                {
                    ddlUnit.SelectedIndex = i;
                    break;
                }
            }
        }

        dsBook.Dispose();
    }
    protected void btnOK_Click(object sender, ImageClickEventArgs e)
    {
        SqlConnection conn = new SqlConnection("server=(local);database=school;uid=sa;pwd=");

        string strSql = "";
        //判断更新标志，Add为添加， update为修改
        if (Update_Flag == "Add")
        {
            //添加语句
            strSql = "INSERT INTO BookRegister(BookName,PublishingHouse,Chief_editor,Proofread,FormatDesign,CoverDesign,Price,Appendix,Brief,BookType,Quantity,Unit,RegisterDate,PrincipalPeople,StorageSites,Remarks)VALUES('"
                + txtBookName.Text.Trim() + "','" + txtPublish.Text.Trim() + "','" + txtChief_editor.Text.Trim() + "','" + txtProofread.Text.Trim() + "','" + txtFormatDesign.Text.Trim() + "','" + txtCoverDesign.Text.Trim() + "','" + txtPrice.Text.Trim() + "','" + txtAppendix.Text.Trim() + "','"
                + txtBrief.Text.Trim() + "','" + ddlBookType.SelectedItem.Text + "','" + txtQuantity.Text.Trim() + "','" + ddlUnit.SelectedItem.Text + "','" + txtRegisterDate.Text.Trim() + "','" + txtPrincipal.Text.Trim() + "','" + txtStorageSites.Text.Trim() + "','" + txtRemark.Text.Trim() + "')";
        }
        else if (Update_Flag == "Update")
        {
            //修改语句
            strSql ="UPDATE BookRegister SET BookName= '"+txtBookName.Text.Trim()+"',PublishingHouse= '"+txtPublish.Text.Trim()+"',Chief_editor='"+txtChief_editor.Text.Trim()+"',Proofread = '"+txtProofread.Text.Trim()+"',FormatDesign = '"+txtFormatDesign.Text.Trim()+"',CoverDesign = '"+txtCoverDesign.Text.Trim()
                +"',Price = '"+txtPrice.Text.Trim()+"',Appendix = '"+txtAppendix.Text.Trim()+"',Brief = '"+txtBrief.Text.Trim()+"',BookType = '"+ddlBookType.SelectedItem.Text+"',Quantity = '"+txtQuantity.Text.Trim()+"',Unit = '"+ddlUnit.SelectedItem.Text+"',RegisterDate = '"+txtRegisterDate.Text
                +"',PrincipalPeople = '"+txtPrincipal.Text.Trim()+"',StorageSites = '"+txtStorageSites.Text.Trim()+"',Remarks = '"+txtRemark.Text.Trim()+"' WHERE RegisterID = "+lblID.Text;
        }

        SqlCommand cmd = new SqlCommand(strSql, conn);

        try
        {
            conn.Open();

            cmd.ExecuteNonQuery();

            //关闭子窗体，刷新父窗体
            //Response.Write("<script>window.close();window.opener.location='BookRegister.aspx'; </script>");
            Response.Write("<script>window.close(); </script>");
            Response.Write("<script>window.opener.location='BookRegister.aspx'; </script>");
        }
        catch (Exception ex)
        {
            Response.Write("<script>alert('" + ex.Message + "');</script>");
        }
        finally
        {
            conn.Close();
        }
    }
    protected void btnCancel_Click(object sender, ImageClickEventArgs e)
    {
        //关闭子窗体
        Response.Write("<script>window.close(); </script>");
    }
}