cardreg.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 CardReg : System.Web.UI.Page
{
    String teststr = "";
    SqlConnection con = new SqlConnection("server=42.1.47.11;user id=szy;pwd=123456;DataBase=AssetsDB");
    


    protected void Page_Load(object sender, EventArgs e)
    {

        if (!IsPostBack)
        {
            
            //产生卡片年度序列号 Label4.text
             String y_no_id;
             int cur_no = 0;

             con.Open();
             String get_max_y_no_id = "select max(y_no_id) as y_no_id from card where y_no='"+Application["y_no"].ToString()+"'";
             SqlCommand com = new SqlCommand(get_max_y_no_id, con);
             SqlDataReader read = com.ExecuteReader();
             read.Read();

             
            try                     //如何判断read 读取数据后为空?
            {
                y_no_id = read.GetString(0).ToString();
                int start=y_no_id.LastIndexOf("-")+1;
                int len=y_no_id.Length-start-1;
                cur_no=Convert.ToInt32(y_no_id.Substring(start,len));
                cur_no++;   //卡片序列号增加１

                if (cur_no > Convert.ToInt32(Application["number"]))                     //卡片数量超过最大值时,弹出对话框提示,且窗口自动关闭.
                {
                    Response.Write("<script language=javascript>alert('对不起,卡片已达到最大数量!')</script>");
                    Response.Write("<script language=javascript>window.close()</script>");
                }

                y_no_id=Application["y_no"].ToString()+"-"+cur_no.ToString();
                Application["cur_no"] = cur_no;
            }
            catch
            {
                cur_no=1;
                y_no_id = Application["y_no"].ToString()+"-"+cur_no.ToString();
            }

            
            
            Application["y_no_id"] = y_no_id;
            Label4.Text = Application["y_no_id"].ToString();

            //Label6.Text = Application["f_no"].ToString();
            Application["r_no"] = txt_r_no.Text;
            Application["status"] = dpl_status.SelectedValue;
            Application["u_bra_detail"] = txt_u_bra.Text;
            Application["cad_ref"] = txt_cad_ref.Text;
            Application["card_reg"] = txt_card_reg.Text;


            Label11.Text = Application["a_date"].ToString();

            imgurl.ImageUrl = Application["imgurl"].ToString();

            con.Close();
        }

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
            if (Convert.ToInt32(Application["cur_no"]) > Convert.ToInt32(Application["number"]))                     //卡片数量超过最大值时,弹出对话框提示,且窗口自动关闭.
            {
                Response.Write("<script language=javascript>alert('对不起,卡片已达到最大数量,不能提交数据!" + Convert.ToInt32(Application["number"]) + "')</script>");
                return;
            }

            con.Open();

            String InsertCardSql="insert into card(y_no_id,y_no,r_no,u_branch_no,u_bra_detail,user_name,card_ref,status,card_reg)";
            InsertCardSql+="values('"+Application["y_no_id"]+"','"+Application["y_no"]+"','"+txt_r_no.Text+"','"+Application["u_branch_no"]+"',";
            InsertCardSql += "'" + txt_u_bra.Text + "','" + TextBox1.Text + "','" + txt_cad_ref.Text + "','" + dpl_status.SelectedValue + "','"+txt_card_reg.Text+"')";
            
            //txt_cad_ref.Text = InsertCardSql;

            SqlCommand InsertCareSql_Cmd = new SqlCommand(InsertCardSql,con);
            InsertCareSql_Cmd.ExecuteNonQuery();


            String c_id = Application["y_no_id"].ToString() + "-0";      //置当前记录号,规则为y_no_id+顺序号，新增的卡片时，change_record顺序号为１
            String InsertChangeRecordSql="insert into change_record(c_id,y_no_id,c_date,c_adress)";
            InsertChangeRecordSql += "values('" + c_id + "','" + Application["y_no_id"] + "','" + Application["a_date"] + "','" + Application["a_adress&reason"] + "')";
            
            //txt_cad_ref.Text = InsertChangeRecordSql;

            SqlCommand InsertChangeRecordSql_cmd=new SqlCommand(InsertChangeRecordSql,con);
            InsertChangeRecordSql_cmd.ExecuteNonQuery();


            con.Close();
            Response.Write("<script language=javascript>alert('添加数据成功" + teststr + "')</script>");
        }
        catch
        {
            Response.Write("<script language=javascript>alert('添加数据失败" + teststr + "')</script>");
        }

    }

    protected void Button2_Click(object sender, EventArgs e)
    {
        Response.Redirect("CardReg.aspx");
    }


}