xnadd.aspx.cs

系统使用VS2005编写 数据库 使用SQL server 2000 或 SQL server 2005 测试前请先修改app.config 或web.config 的数据库连接字符串

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;

public partial class XNadd : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        lblMsg.Visible = false;
        if (!IsPostBack)
        {
            ddlXN.Items.Clear();
            for (int i = 2005; i < 2040; i++)
            {
                ddlXN.Items.Add(new ListItem(i.ToString() + "年"));
            }
        }
        if (Request.Params["XNID"].Equals("ADD"))
        {
            txtXNID.Text = "此项不填";
            txtXNID.Enabled = false;
        }
        else
        {
            JPKC.DAL.WLDXT.XUENIAN xn = JPKC.DAL.WLDXT.XUENIAN.Find(int.Parse(Request.Params["XNID"].ToString()));
            foreach (ListItem li in ddlXN.Items)
            {
                if (li.Text == xn.XNName)
                {
                    li.Selected = true;
                }
            }
            txtXNID.Text = xn.XNID.ToString();
            txtXNID.Enabled = true;
            txtPX.Text = xn.XNOrder.ToString();
        }
    }
    protected void btnOK_Click(object sender, EventArgs e)
    {
        JPKC.DAL.WLDXT.XUENIAN xn;
        if (Request.Params["XNID"].Equals("ADD"))
        {
            xn = new JPKC.DAL.WLDXT.XUENIAN();
        }
        else
        {
            xn = JPKC.DAL.WLDXT.XUENIAN.Find(int.Parse(Request.Params["XNID"].ToString()));
        }
        xn.XNName = ddlXN.Text;
        xn.XNOrder = int.Parse(txtPX.Text);
        try
        {
            if (Request.Params["XNID"].Equals("ADD"))
            {
                xn.Create();
            }
            else
            {
                xn.Update();
            }
            lblMsg.Text = "更新成功！";
        }
        catch
        {
            lblMsg.Text = "更新失败！";
        }
        lblMsg.Visible = true;
    }
    protected void btnReturn_Click(object sender, EventArgs e)
    {
        Server.Transfer("Nian.aspx");
    }
}