} //申请表全部
//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);
}
}
}
