1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11
12public partial class admin_Default2 : System.Web.UI.Page
13...{
14    BaseClass bc = new BaseClass();
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17       
18            if (Convert.ToString(Session["UID"]) == "")
19            ...{
20                Response.Redirect("login.aspx");
21
22            }
23            else
24            ...{
25                DataSet ds = null;
26                int p_int_newCode = 0;
27                string P_string_newcode = "";
28                ds = bc.ExecDS("select * from fixManager order by fixID");
29                if (ds.Tables[0].Rows.Count == 0)
30                ...{
31                    txtfixCode.Text = DateTime.Now.ToString("yyyy-MM-dd") + "FM100001";
32                }
33                else
34                ...{
35                 //   Response.Write(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["fixID"]) ;
36                   // Response.End();
37                   
38                    
39                    P_string_newcode = Convert.ToString(ds.Tables[0].Rows[ds.Tables[0].Rows.Count-1]["fixID"]);
40                  //  Response.Write(P_string_newcode);
41                    //Response.End();
42                    p_int_newCode = Convert.ToInt32(P_string_newcode.Substring(12, 6)) + 1;
43                    
44                    P_string_newcode = DateTime.Now.ToString("yyyy-MM-dd") + "FM" + p_int_newCode.ToString();
45                    txtfixCode.Text = P_string_newcode;
46                }
47
48            }
49        
50    }
51    
52    protected void Button1_Click(object sender, EventArgs e)
53    ...{
54       
55       
56
57        string sqlstr = "insert into fixManager (fixID,name,amount,factory,factorydate)values('"+txtfixCode.Text+"','"+name.Text + "','" + amount.Text + "','" + factory.Text + "','" + logoutdate.Text  + "')";
58     // Response.Write(sqlstr);
59      //  Response.End();
60
61        if (bc.ExecSql(sqlstr))
62        ...{
63            Response.Write("<script language=javascript>alert('添加设备成功！');location='fix.aspx'</script>");
64        }
65        else
66        ...{
67            Response.Write("<script>alert('添加失败，请重试！');</script>");
68        }
69
70    }
71}
72