} //申请表全部 //private void BindData4(yuyuehuiyi obj) //{ // DataTable dt = yuyuehuiyi.selectshenhe(obj); // gvcourse.DataSource = dt; // gvcourse.DataBind(); //} private void BindData5(huiyi obj) { DataTable dt = huiyi.selecthuiyi(obj); gvcourse.DataSource = dt; gvcourse.DataBind(); }
private huiyi searchCon2() { huiyi obj = new huiyi(); obj.yuyue = TB2.Text.Trim(); return(obj); }
private void BindData2(huiyi obj) { DataTable dt = huiyi.selectyuyue(obj); GridView2.DataSource = dt; GridView2.DataBind(); }
protected void Button2_Click(object sender, EventArgs e) { if (TextBox1.Text.Trim() == "") { ComTool.Alert("请输入设备编号!"); } else if (TextBox2.Text.Trim() == "") { ComTool.Alert("请输入设备状态!"); } else { huiyi obj = new huiyi(); obj.huiyiname = TextBox1.Text; obj.yuyue = TextBox2.Text; if (huiyi.updateRecord(obj) == 1) { ComTool.Alert("更新成功!"); ComTool.Redirect("huiyiListListM.aspx"); } else { ComTool.Alert("更新失败!"); } } }
private huiyi searchCon1() { huiyi obj = new huiyi(); obj.huiyiname = TB.Text.Trim(); return(obj); }
protected void Button1_Click(object sender, EventArgs e) { if (tbxUserName.Text.Trim() == "") { ComTool.Alert("请输入会议室名称!"); } else if (tbxUserPWD.Text.Trim() == "") { ComTool.Alert("请输入会议室位置!"); } else if (TextBox2.Text.Trim() == "") { ComTool.Alert("请输入会议室状态!"); } else { huiyi obj = new huiyi(); obj.huiyiname = tbxUserName.Text; obj.didian = tbxUserPWD.Text; obj.yuyue = TextBox2.Text; if (huiyi.insertRecord(obj) == 1) { ComTool.Alert("新增成功!"); ComTool.Redirect("huiyiListM.aspx"); } else { ComTool.Alert("新增失败!"); } } }
public static int quxiaoRecord(huiyi obj) { string strSQL = "update tbhuiyi set yuyue='" + "0" + "' where huiyiname='" + obj.huiyiname + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int deleteRecord(huiyi obj) { string strSQL = "delete from tbhuiyi where huiyiid='" + obj.huiyiid + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int insertRecord(huiyi obj) { string strSQL = "insert into tbhuiyi(huiyiname,yuyue,didian) values('" + obj.huiyiname + "','" + obj.yuyue + "','" + obj.didian + "')"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
//private void BindData4(yuyuehuiyi obj) //{ // DataTable dt = yuyuehuiyi.update(obj); // gvcourse.DataSource = dt; // gvcourse.DataBind(); //} protected void gvcourse_RowCommand(object sender, GridViewCommandEventArgs e) { huiyi hy = new huiyi(); hy.huiyiname = e.CommandArgument.ToString(); huiyi.updateRecord(hy);//yuyue=1 BindData5(hy); yuyuehuiyi obj = new yuyuehuiyi(); obj.huiyiname = e.CommandArgument.ToString(); yuyuehuiyi.updateshenheRecord(obj); BindData(obj); }
public static DataTable selectyuyue(huiyi hy) { string str = "select * from tbhuiyi where 1=1 "; if (hy.yuyue != "" && hy.yuyue != null) { str = str + "and yuyue='" + hy.yuyue + "'"; } DataTable dt = DBOper.execQueryBySQLText(str); return(dt); }
private yuyuehuiyi searchCon() { huiyi h = new huiyi(); h.huiyiname = hyname.Text.Trim(); DataTable da = huiyi.selecthuiyi(h); yuyuehuiyi obj = new yuyuehuiyi(); obj.huiyiname = hyname.Text.Trim(); obj.shijian = shijian.Text.Trim(); obj.yuyue = (string )da.Rows[0][2]; return(obj); }
protected void lbtndel_Click(object sender, EventArgs e) { for (int i = 0; i < gvcourse.Rows.Count; i++) { CheckBox cb = (CheckBox)gvcourse.Rows[i].FindControl("cbsel"); if (cb.Checked) { string name = gvcourse.DataKeys[i].Value.ToString(); yuyuehuiyi myhuiyi = new yuyuehuiyi(); myhuiyi.huiyiname = name; yuyuehuiyi.deleteshenqingRecord(myhuiyi); BindData(myhuiyi); huiyi huiy = new huiyi(); huiy.huiyiname = name; huiyi.quxiaoRecord(huiy); BindData5(huiy); } } }