addkc.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;
using Castle.ActiveRecord;
using NHibernate.Expression;
public partial class addKC : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        lblMsg.Visible = false;
        if (!IsPostBack)
        {
            
            ddlNian.DataSource = JPKC.DAL.WLDXT.XUENIAN.FindAll(Expression.Eq("XNDELETELAG", false));
            ddlNian.DataTextField = "XNName";
            ddlNian.DataValueField = "XNID";
            ddlNian.DataBind();


           
            ddlJIBie.DataSource = JPKC.DAL.WLDXT.JIBIE.FindAll(Expression.Eq("JBDELETELAG", false));
            ddlJIBie.DataTextField = "JBName";
            ddlJIBie.DataValueField = "JBID";
            ddlJIBie.DataBind();

            if (Request.Params["KCID"].Equals("ADD"))
            {
                txtKCID.Text = "此项不填";
            }
            else
            {
                JPKC.DAL.WLDXT.KECHENG kc = JPKC.BFL.WLDXT.KECHENGBFL.GetKCByID(decimal.Parse(Request.Params["KCID"].ToString()));
                txtKCID.Text = kc.KCID.ToString();
                txtKCName.Text = kc.KCName;
                txtKCFZR.Text = kc.KCFZR;
                txtKCFZRZC.Text = kc.KCZC;
                txtSBRQ.Text = kc.KCSBSJ.ToString();
                txtPZRQ.Text = kc.KCPZSJ.ToString();
                txtkcPage.Text = kc.KCIndexPage;
                foreach (ListItem li in ddlJIBie.Items)
                {
                    if (li.Value == kc.JIBIE.JBID.ToString())
                    {
                        li.Selected = true;
                    }
                }
                foreach (ListItem li in ddlNian.Items)
                {
                    if (li.Value == kc.XUENIAN.XNID.ToString())
                    {
                        li.Selected = true;
                    }
                }

            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
            JPKC.DAL.WLDXT.KECHENG k;
            if (Request.Params["KCID"].Equals("ADD"))
            {
                k = new JPKC.DAL.WLDXT.KECHENG();
            }
            else
            {
                k = JPKC.DAL.WLDXT.KECHENG.Find(decimal.Parse(txtKCID.Text.ToString()));
            }
            k.KCName = txtKCName.Text;
            k.KCFZR = txtKCFZR.Text;
            k.KCZC = txtKCFZRZC.Text;
            k.XUENIAN = JPKC.DAL.WLDXT.XUENIAN.Find(int.Parse(ddlNian.SelectedValue));
            k.JIBIE = JPKC.DAL.WLDXT.JIBIE.Find(decimal.Parse(ddlJIBie.SelectedValue));
            k.KCPZSJ =DateTime.Parse(txtPZRQ.Text);
            k.KCSBSJ = DateTime.Parse(txtSBRQ.Text);
            k.KCIndexPage = txtkcPage.Text;
            k.KCDELETELAG = false;
            if (Request.Params["KCID"].Equals("ADD"))
                k.Create();
            else
                k.Update();
            lblMsg.Text="更新成功";
        }
        catch
        {
            lblMsg.Text="更新失败";
        }
        lblMsg.Visible = true;
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Server.Transfer("KECHENG.aspx");
    }
}