protected void Button1_Click(object sender, EventArgs e) { if (TextBox1.Text.Trim() == "") { ComTool.Alert("请输入设备编号"); } else if (TextBox2.Text.Trim() == "") { ComTool.Alert("请输入管理员姓名!"); } else if (TextBox3.Text.Trim() == "") { ComTool.Alert("请输入维修日期!"); } else { Equiprecord obj = new Equiprecord(); obj.equipid = Convert.ToInt64(TextBox1.Text); obj.adminname = TextBox2.Text; obj.recorddate = DateTime.Parse(TextBox3.Text); if (Equiprecord.insertRecord(obj) == 1) { ComTool.Alert("新增成功!"); ComTool.Redirect("recordview.aspx"); } else { ComTool.Alert("新增失败!"); } } }
public static int insertRecord(Equiprecord obj) { string strSQL = "insert into equiprecord(equipid,adminname,recorddate) values('" + obj.equipid + "','" + obj.adminname + "','" + obj.recorddate + "')"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }