protected void lbtn_save_Click(object sender, EventArgs e)
{
string wdh = weidaohuo.Text.Trim();
if (wdh == "")
{
wdh = "0";
}
string cq = chaoqi.Text.Trim();
if (cq == "")
{
cq = "0";
}
string sql = "update tiaojian_info set chaoqi=" + cq + ",weidaohuo=" + wdh + "";
int result = DB.ExecuteSql(sql, null);
if (result > 0)
{
SystemTool.AlertShow_Refresh1(this, "保存成功", "tiaojian_info.aspx");
}
else
{
SystemTool.AlertShow(this, "保存失败");
return;
}
}
protected void btnok_Click(object sender, EventArgs e)
{
if (txtname.Text == "")
{
SystemTool.AlertShow(this, "管理员名称不能为空");
return;
}
if (txtpassok.Text != txtpassok2.Text)
{
SystemTool.AlertShow(this, "两次输入密码不一致");
return;
}
string sql = "";
int result = 0;
if (null != Request.QueryString["manId"])
{
//更新操作
if (txtpassok.Text == "")
{//密码不更新
sql = "UPDATE manager_info set roleId='" + ddljiaose.SelectedValue + "',remark='" + SystemTool.NoHtml(txtbeizhu.Value) + "',state='" + ddlState.SelectedValue + "' where man_id=" + SystemTool.NoHtml(Request.QueryString["manId"]);
}
else
{
sql = "UPDATE manager_info set man_psw='" + SystemTool.jimi(SystemTool.NoHtml(txtpassok.Text)) + "',roleId='" + ddljiaose.SelectedValue + "',remark='" + SystemTool.NoHtml(txtbeizhu.Value) + "',state='" + ddlState.SelectedValue + "' where man_id=" + SystemTool.NoHtml(Request.QueryString["manId"]);
}
result = DB.ExecuteSql(sql, null);
}
else
{
sql = "select man_id from manager_info where man_name='" + SystemTool.NoHtml(txtname.Text) + "'";
string r = DB.ExecuteSqlValue(sql, null);
if (r != "" && r != "no")
{
SystemTool.AlertShow(this, "管理员名称已存在");
return;
}
if (txtpassok.Text == "")
{
SystemTool.AlertShow(this, "管理员密码不能为空");
return;
}
sql = "insert into manager_info (man_name,man_psw,roleId,remark,state) values('" + SystemTool.NoHtml(txtname.Text) + "','" + SystemTool.jimi(SystemTool.NoHtml(txtpassok.Text)) + "'," + ddljiaose.SelectedValue + ",'" + SystemTool.NoHtml(txtbeizhu.Value) + "','" + ddlState.SelectedValue + "')";
result = DB.ExecuteSql(sql, null);
}
if (result > 0)
{
SystemTool.AlertShow_Refresh1(this, "保存成功", "guanliyuanlist.aspx");
}
else
{
SystemTool.AlertShow(this, "保存失败");
return;
}
}
//private void BindInfo()
//{
// if (Request.QueryString["id"].ToString() != "")
// {
// string sql = "select * from taizhang_info where taizhang_id=" + Request.QueryString["id"];
// DataSet ds = DB.ExecuteSqlDataSet(sql, null);
// if (ds.Tables[0].Rows.Count > 0)
// {
// yuefen.Text = ds.Tables[0].Rows[0]["yuefen"].ToString();
// shiyongdanwei.Text = ds.Tables[0].Rows[0]["shiyongdanwei"].ToString();
// jihuabianhao.Text = ds.Tables[0].Rows[0]["jihuabianhao"].ToString();
// ddl_zijinlaiyuan.SelectedValue = ds.Tables[0].Rows[0]["zijinlaiyuan"].ToString();
// ddl_jihualeixing.SelectedValue = ds.Tables[0].Rows[0]["jihualeixing"].ToString();
// xunjiayuan.Text = ds.Tables[0].Rows[0]["xunjiayuan"].ToString();
// caigoubianhao.Text = ds.Tables[0].Rows[0]["caigoubianhao"].ToString();
// ddl_wuzishuxing.SelectedValue = ds.Tables[0].Rows[0]["wuzishuxing"].ToString();
// wuzibianma.Text = ds.Tables[0].Rows[0]["wuzibianma"].ToString();
// dingjiawuzimingcheng.Text = ds.Tables[0].Rows[0]["dingjiawuzimingcheng"].ToString();
// dingjiaguigexinghao.Text = ds.Tables[0].Rows[0]["dingjiaguigexinghao"].ToString();
// dingjiadanwei.Text = ds.Tables[0].Rows[0]["dingjiadanwei"].ToString();
// dingjiashuliang.Text = ds.Tables[0].Rows[0]["dingjiashuliang"].ToString();
// hanshuidanjia.Text = ds.Tables[0].Rows[0]["hanshuidanjia"].ToString();
// hanshuijine.Text = ds.Tables[0].Rows[0]["hanshuijine"].ToString();
// shuilv.Text = ds.Tables[0].Rows[0]["shuilv"].ToString();
// caigoufangshi.Text = ds.Tables[0].Rows[0]["caigoufangshi"].ToString();
// suoshuxieyihao.Text = ds.Tables[0].Rows[0]["suoshuxieyihao"].ToString();
// dingdanbianhao.Text = ds.Tables[0].Rows[0]["dingdanbianhao"].ToString();
// dinghuoyiju.Text = ds.Tables[0].Rows[0]["dinghuoyiju"].ToString();
// //jiaohuoshijian.Text = ds.Tables[0].Rows[0]["jiaohuoqi"].ToString();
// ddl_jiaohuodidian.SelectedValue = ds.Tables[0].Rows[0]["jiaohuodidian"].ToString();
// zhizaoshang.Text = ds.Tables[0].Rows[0]["zhizaoshang"].ToString();
// wuzipinpai.Text = ds.Tables[0].Rows[0]["wuzipinpai"].ToString();
// gonghuochangshang.Text = ds.Tables[0].Rows[0]["gonghuochangshang"].ToString();
// ddl_dianshangpingtai.SelectedValue = ds.Tables[0].Rows[0]["dianshangpingtai"].ToString();
// wangdianmingcheng.Text = ds.Tables[0].Rows[0]["wangdianmingcheng"].ToString();
// ddl_fukuanfangshi.SelectedValue = ds.Tables[0].Rows[0]["fukuanfangshi"].ToString();
// changshangdianhua.Text = ds.Tables[0].Rows[0]["changshangdianhua"].ToString();
// dingdanriqi.Text = ds.Tables[0].Rows[0]["dingdanriqi"].ToString();
// jiaohuoqi.Text = ds.Tables[0].Rows[0]["jiaohuoqi"].ToString();
// yingdaoshijian.Text = ds.Tables[0].Rows[0]["yingdaoshijian"].ToString();
// shidaoshijian.Text = ds.Tables[0].Rows[0]["shidaoshijian"].ToString();
// shiyongshouming.Text = ds.Tables[0].Rows[0]["shiyongshouming"].ToString();
// zhibaoqi.Text = ds.Tables[0].Rows[0]["zhibaoqi"].ToString();
// qita.Text = ds.Tables[0].Rows[0]["qita"].ToString();
// beizhu.Value = ds.Tables[0].Rows[0]["beizhu"].ToString();
// ddl_state.SelectedValue = ds.Tables[0].Rows[0]["isfinished"].ToString();
// if (ds.Tables[0].Rows[0]["isfinished"].ToString() == "1")
// {
// ddl_state.Enabled = false;
// }
// }
// sql = "select man_name from manager_info where man_id=" + ViewState["user_id"];
// string resulta = DB.ExecuteSqlValue(sql, null);
// if (resulta != "" && resulta != "no")
// {
// lbl_user.Text = resulta;
// }
// }
//}
protected void lbtn_save_Click(object sender, EventArgs e)
{
string daohuoshuliang = txtdaohuoshuliang.Text;
if (daohuoshuliang == "")
{
daohuoshuliang = "0";
}
string taizhangid = "0";
if (null != Request.QueryString["id"])
{
taizhangid = Request.QueryString["id"].ToString();
}
string manid = ViewState["user_id"].ToString();
string bz = beizhu.Value;
SqlParameter[] pars = new SqlParameter[] {
new SqlParameter("@daohuoshuliang", System.Data.SqlDbType.NVarChar)
{
Value = daohuoshuliang
},
new SqlParameter("@taizhangid", System.Data.SqlDbType.NVarChar)
{
Value = taizhangid
},
new SqlParameter("@manid", System.Data.SqlDbType.NVarChar)
{
Value = manid
},
new SqlParameter("@bz", System.Data.SqlDbType.NVarChar)
{
Value = bz
}
};
if (null != Request.QueryString["id"])
{
string sqlck = "select taizhang_id from taizhang_info where taizhang_id='" + Request.QueryString["id"] + "' and manager_id=" + ViewState["user_id"];
string resultck = DB.ExecuteSqlValue(sqlck, null);
if (resultck == "" || resultck == "no")
{
SystemTool.AlertShow(this, "非添加者，不可操作此记录");
return;
}
string sql = "insert into jilu_info (daohuo,taizhang_id,manager_id,beizhu) values(@daohuoshuliang,@taizhangid,@manid,@bz)";
//string sql = "update taizhang_info set yuefen=@yuefen,shiyongdanwei=@shiyongdanwei,jihuabianhao=@jihuabianhao,zijinlaiyuan=@zijinlaiyuan,jihualeixing=@jihualeixing,xunjiayuan=@xunjiayuan,caigoubianhao=@caigoubianhao,wuzishuxing=@wuzishuxing,wuzibianma=@wuzibianma,dingjiawuzimingcheng=@dingjiawuzimingcheng,dingjiaguigexinghao=@dingjiaguigexinghao,dingjiadanwei=@dingjiadanwei,dingjiashuliang=@dingjiashuliang,hanshuidanjia=@hanshuidanjia,hanshuijine=@hanshuijine,shuilv=@shuilv,caigoufangshi=@caigoufangshi,suoshuxieyihao=@suoshuxieyihao,dingdanbianhao=@dingdanbianhao,dinghuoyiju=@dinghuoyiju,jiaohuodidian=@jiaohuodidian,zhizaoshang=@zhizaoshang,wuzipinpai=@wuzipinpai,gonghuochangshang=@gonghuochangshang,dianshangpingtai=@dianshangpingtai,wangdianmingcheng=@wangdianmingcheng,fukuanfangshi=@fukuanfangshi,changshangdianhua=@changshangdianhua,dingdanriqi=@dingdanriqi,jiaohuoqi=@jiaohuoqi,yingdaoshijian=@yingdaoshijian,shidaoshijian=@shidaoshijian,shiyongshouming=@shiyongshouming,zhibaoqi=@zhibaoqi,qita=@qita,beizhu=@beizhu,isfinished=@isfinished where taizhang_id=" + Request.QueryString["id"];
int result = DB.ExecuteSql(sql, pars);
if (result > 0)
{
SystemTool.AlertShow_Refresh1(this, "保存成功", "taizhang_list.aspx");
}
else
{
SystemTool.AlertShow(this, "保存失败");
return;
}
}
//else
//{
// string sql = "insert into taizhang_info( yuefen,shiyongdanwei,jihuabianhao,zijinlaiyuan,jihualeixing,xunjiayuan,caigoubianhao,wuzishuxing,wuzibianma,dingjiawuzimingcheng,dingjiaguigexinghao,dingjiadanwei,dingjiashuliang,hanshuidanjia,hanshuijine,shuilv,caigoufangshi,suoshuxieyihao,dingdanbianhao,dinghuoyiju,jiaohuodidian,zhizaoshang,wuzipinpai,gonghuochangshang,dianshangpingtai,wangdianmingcheng,fukuanfangshi,changshangdianhua,dingdanriqi,jiaohuoqi,yingdaoshijian,shidaoshijian,shiyongshouming,zhibaoqi,qita,beizhu) values (@yuefen,@shiyongdanwei,@jihuabianhao,@zijinlaiyuan,@jihualeixing,@xunjiayuan,@caigoubianhao,@wuzishuxing,@wuzibianma,@dingjiawuzimingcheng,@dingjiaguigexinghao,@dingjiadanwei,@dingjiashuliang,@hanshuidanjia,@hanshuijine,@shuilv,@caigoufangshi,@suoshuxieyihao,@dingdanbianhao,@dinghuoyiju,@jiaohuodidian,@zhizaoshang,@wuzipinpai,@gonghuochangshang,@dianshangpingtai,@wangdianmingcheng,@fukuanfangshi,@changshangdianhua,@dingdanriqi,@jiaohuoqi,@yingdaoshijian,@shidaoshijian,@shiyongshouming,@zhibaoqi,@qita,@beizhu)";
// int result = DB.ExecuteSql(sql, pars);
// if (result > 0)
// {
// SystemTool.AlertShow_Refresh1(this, "保存成功", "taizhang_list.aspx");
// }
// else
// {
// SystemTool.AlertShow(this, "保存失败");
// return;
// }
//}
}
protected void lbtn_save_Click(object sender, EventArgs e)
{
string suoshucequ = ddl_AreaInfo.SelectedValue;
if (suoshucequ == "0")
{
SystemTool.AlertShow(this, "所属测区不能为空");
return;
}
string mianxiangxinxi = ddl_WorkfaceInfo.SelectedValue;
if (mianxiangxinxi == "0")
{
SystemTool.AlertShow(this, "面巷信息不能为空");
return;
}
string fenzhanhao = ddl_fenzhanhao.SelectedValue;
if (fenzhanhao == "0")
{
SystemTool.AlertShow(this, "分站号不能为空");
return;
}
string duankouhao = ddl_duankouhao.SelectedValue;
if (duankouhao == "0")
{
SystemTool.AlertShow(this, "端口号不能为空");
return;
}
string botelv = ddl_botelv.SelectedValue;
if (botelv == "0")
{
SystemTool.AlertShow(this, "波特率不能为空");
return;
}
string shiyongzhuangtai = ddl_shiyongzhuangtai.SelectedValue;
if (shiyongzhuangtai == "0")
{
SystemTool.AlertShow(this, "使用状态不能为空");
return;
}
if (null != Request.QueryString["id"])
{
string sqlck = "select * from commport where areaname='" + suoshucequ + "' and areaface='" + mianxiangxinxi + "' and stationno=" + Request.QueryString["id"];
DataSet dsck = DB.ExecuteSqlDataSet(sqlck, null);
if (dsck.Tables[0].Rows.Count <= 0)
{
SystemTool.AlertShow(this, "该分站号不存在");
return;
}
string sql = "update commport set stationno='" + fenzhanhao + "',commno='" + duankouhao + "',baudrate='" + botelv + "',usestate='" + shiyongzhuangtai + "' where areaname='" + suoshucequ + "' and areaface='" + mianxiangxinxi + "' and stationno=" + Request.QueryString["id"];
int result = DB.ExecuteSql(sql, null);
if (result > 0)
{
SystemTool.AlertShow_Refresh1(this, "保存成功", "fenzhanjiduankoushezhi.aspx");
}
else
{
SystemTool.AlertShow(this, "保存失败");
return;
}
}
else
{
string sqlck = "select stationno from commport where stationno='" + fenzhanhao + "'";
string re = DB.ExecuteSqlValue(sqlck, null);
if (re != "" && re != "no")
{
SystemTool.AlertShow(this, "该分站号已存在");
return;
}
string sql = "insert into commport (areaname,areaface,stationno,commno,baudrate,usestate) values";
sql += "('" + suoshucequ + "','" + mianxiangxinxi + "','" + fenzhanhao + "','" + duankouhao + "','" + botelv + "','" + shiyongzhuangtai + "')";
int result = DB.ExecuteSql(sql, null);
if (result > 0)
{
SystemTool.AlertShow_Refresh1(this, "保存成功", "fenzhanjiduankoushezhi.aspx");
}
else
{
SystemTool.AlertShow(this, "保存失败");
return;
}
}
}
protected void lbtn_save_Click(object sender, EventArgs e)
{
string yuefena = yuefen.Text; // = ds.Tables[0].Rows[0]["yuefen"].ToString();
string shiyongdanweia = shiyongdanwei.Text; // = ds.Tables[0].Rows[0]["shiyongdanwei"].ToString();
string jihuabianhaoa = jihuabianhao.Text; // = ds.Tables[0].Rows[0]["jihuabianhao"].ToString();
string zijinlaiyuana = ddl_zijinlaiyuan.SelectedValue; // = ds.Tables[0].Rows[0]["zijinlaiyuan"].ToString();
string jihualeixinga = ddl_jihualeixing.SelectedValue; // = ds.Tables[0].Rows[0]["jihualeixing"].ToString();
string xunjiayuana = xunjiayuan.Text; // = ds.Tables[0].Rows[0]["xunjiayuan"].ToString();
string caigoubianhaoa = caigoubianhao.Text; // = ds.Tables[0].Rows[0]["caigoubianhao"].ToString();
string wuzishuxinga = ddl_wuzishuxing.SelectedValue; // = ds.Tables[0].Rows[0]["wuzishuxing"].ToString();
string wuzibianmaa = wuzibianma.Text; // = ds.Tables[0].Rows[0]["wuzibianma"].ToString();
string dingjiawuzimingchenga = dingjiawuzimingcheng.Text; // = ds.Tables[0].Rows[0]["dingjiawuzimingcheng"].ToString();
string dingjiaguigexinghaoa = dingjiaguigexinghao.Text; // = ds.Tables[0].Rows[0]["dingjiaguigexinghao"].ToString();
string dingjiadanweia = dingjiadanwei.Text; // = ds.Tables[0].Rows[0]["dingjiadanwei"].ToString();
string dingjiashulianga = dingjiashuliang.Text; // = ds.Tables[0].Rows[0]["dingjiashuliang"].ToString();
if (dingjiashulianga == "")
{
dingjiashulianga = "0";
}
string hanshuidanjiaa = hanshuidanjia.Text;// = ds.Tables[0].Rows[0]["hanshuidanjia"].ToString();
if (hanshuidanjiaa == "")
{
hanshuidanjiaa = "0";
}
string hanshuijinea = hanshuijine.Text;// = ds.Tables[0].Rows[0]["hanshuijine"].ToString();
if (hanshuijinea == "")
{
hanshuijinea = "0";
}
string shuilva = shuilv.Text;// = ds.Tables[0].Rows[0]["shuilv"].ToString();
if (shuilva == "")
{
shuilva = "0";
}
string caigoufangshia = caigoufangshi.Text; // = ds.Tables[0].Rows[0]["caigoufangshi"].ToString();
string suoshuxieyihaoa = suoshuxieyihao.Text; //= ds.Tables[0].Rows[0]["suoshuxieyihao"].ToString();
string dingdanbianhaoa = dingdanbianhao.Text; // = ds.Tables[0].Rows[0]["dingdanbianhao"].ToString();
string dinghuoyijua = dinghuoyiju.Text; // = ds.Tables[0].Rows[0]["dinghuoyiju"].ToString();
//string jiaohuoshijiana=jiaohuoshijian.Text;// = ds.Tables[0].Rows[0]["jiaohuoshijian"].ToString();
string jiaohuodidiana = ddl_jiaohuodidian.SelectedValue; // = ds.Tables[0].Rows[0]["jiaohuodidian"].ToString();
string zhizaoshanga = zhizaoshang.Text;
string wuzipinpaia = wuzipinpai.Text; // = ds.Tables[0].Rows[0]["wuzipinpai"].ToString();
string gonghuochangshanga = gonghuochangshang.Text; // = ds.Tables[0].Rows[0]["gonghuochangshang"].ToString();
string dianshangpingtaia = ddl_dianshangpingtai.SelectedValue; // = ds.Tables[0].Rows[0]["dianshangpingtai"].ToString();
string wangdianmingchenga = wangdianmingcheng.Text; // = ds.Tables[0].Rows[0]["wangdianmingcheng"].ToString();
string fukuanfangshia = ddl_fukuanfangshi.SelectedValue; // = ds.Tables[0].Rows[0]["fukuanfangshi"].ToString();
string changshangdianhuaa = changshangdianhua.Text; // = ds.Tables[0].Rows[0]["changshangdianhua"].ToString();
string dingdanriqia = dingdanriqi.Text; // = ds.Tables[0].Rows[0]["dingdanriqi"].ToString();
string jiaohuoqia = jiaohuoqi.Text; // = ds.Tables[0].Rows[0]["jiaohuoqi"].ToString();
string yingdaoshijiana = yingdaoshijian.Text; // = ds.Tables[0].Rows[0]["yingdaoshijian"].ToString();
string shidaoshijiana = shidaoshijian.Text; // = ds.Tables[0].Rows[0]["shidaoshijian"].ToString();
string shiyongshouminga = shiyongshouming.Text; // = ds.Tables[0].Rows[0]["shiyongshouming"].ToString();
string zhibaoqia = zhibaoqi.Text; // = ds.Tables[0].Rows[0]["zhibaoqi"].ToString();
string qitaa = qita.Text; // = ds.Tables[0].Rows[0]["qita"].ToString();
string beizhua = beizhu.Value; // = ds.Tables[0].Rows[0]["beizhu"].ToString();
string state = ddl_state.SelectedValue;
if (state == "0")
{
shidaoshijiana = "";
}
SqlParameter[] pars = new SqlParameter[] {
new SqlParameter("@yuefen", System.Data.SqlDbType.NVarChar)
{
Value = yuefena
},
new SqlParameter("@shiyongdanwei", System.Data.SqlDbType.NVarChar)
{
Value = shiyongdanweia
},
new SqlParameter("@jihuabianhao", System.Data.SqlDbType.NVarChar)
{
Value = jihuabianhaoa
},
new SqlParameter("@zijinlaiyuan", System.Data.SqlDbType.NVarChar)
{
Value = zijinlaiyuana
},
new SqlParameter("@jihualeixing", System.Data.SqlDbType.NVarChar)
{
Value = jihualeixinga
},
new SqlParameter("@xunjiayuan", System.Data.SqlDbType.NVarChar)
{
Value = xunjiayuana
},
new SqlParameter("@caigoubianhao", System.Data.SqlDbType.NVarChar)
{
Value = caigoubianhaoa
},
new SqlParameter("@wuzishuxing", System.Data.SqlDbType.NVarChar)
{
Value = wuzishuxinga
},
new SqlParameter("@wuzibianma", System.Data.SqlDbType.NVarChar)
{
Value = wuzibianmaa
},
new SqlParameter("@dingjiawuzimingcheng", System.Data.SqlDbType.NVarChar)
{
Value = dingjiawuzimingchenga
},
new SqlParameter("@dingjiaguigexinghao", System.Data.SqlDbType.NVarChar)
{
Value = dingjiaguigexinghaoa
},
new SqlParameter("@dingjiadanwei", System.Data.SqlDbType.NVarChar)
{
Value = dingjiadanweia
},
new SqlParameter("@dingjiashuliang", System.Data.SqlDbType.Decimal)
{
Value = dingjiashulianga
},
new SqlParameter("@hanshuidanjia", System.Data.SqlDbType.Decimal)
{
Value = hanshuidanjiaa
},
new SqlParameter("@hanshuijine", System.Data.SqlDbType.Decimal)
{
Value = hanshuijinea
},
new SqlParameter("@shuilv", System.Data.SqlDbType.Decimal)
{
Value = shuilva
},
new SqlParameter("@caigoufangshi", System.Data.SqlDbType.NVarChar)
{
Value = caigoufangshia
},
new SqlParameter("@suoshuxieyihao", System.Data.SqlDbType.NVarChar)
{
Value = suoshuxieyihaoa
},
new SqlParameter("@dingdanbianhao", System.Data.SqlDbType.NVarChar)
{
Value = dingdanbianhaoa
},
new SqlParameter("@dinghuoyiju", System.Data.SqlDbType.NVarChar)
{
Value = dinghuoyijua
},
new SqlParameter("@jiaohuodidian", System.Data.SqlDbType.NVarChar)
{
Value = jiaohuodidiana
},
new SqlParameter("@zhizaoshang", System.Data.SqlDbType.NVarChar)
{
Value = zhizaoshanga
},
new SqlParameter("@wuzipinpai", System.Data.SqlDbType.NVarChar)
{
Value = wuzipinpaia
},
new SqlParameter("@gonghuochangshang", System.Data.SqlDbType.NVarChar)
{
Value = gonghuochangshanga
},
new SqlParameter("@dianshangpingtai", System.Data.SqlDbType.NVarChar)
{
Value = dianshangpingtaia
},
new SqlParameter("@wangdianmingcheng", System.Data.SqlDbType.NVarChar)
{
Value = wangdianmingchenga
},
new SqlParameter("@fukuanfangshi", System.Data.SqlDbType.NVarChar)
{
Value = fukuanfangshia
},
new SqlParameter("@changshangdianhua", System.Data.SqlDbType.NVarChar)
{
Value = changshangdianhuaa
},
new SqlParameter("@dingdanriqi", System.Data.SqlDbType.NVarChar)
{
Value = dingdanriqia
},
new SqlParameter("@jiaohuoqi", System.Data.SqlDbType.NVarChar)
{
Value = jiaohuoqia
},
new SqlParameter("@yingdaoshijian", System.Data.SqlDbType.NVarChar)
{
Value = yingdaoshijiana
},
new SqlParameter("@shidaoshijian", System.Data.SqlDbType.NVarChar)
{
Value = shidaoshijiana
},
new SqlParameter("@shiyongshouming", System.Data.SqlDbType.NVarChar)
{
Value = shiyongshouminga
},
new SqlParameter("@zhibaoqi", System.Data.SqlDbType.NVarChar)
{
Value = zhibaoqia
},
new SqlParameter("@qita", System.Data.SqlDbType.NVarChar)
{
Value = qitaa
},
new SqlParameter("@beizhu", System.Data.SqlDbType.NVarChar)
{
Value = beizhua
},
new SqlParameter("@isfinished", System.Data.SqlDbType.Int)
{
Value = state
}
};
if (null != Request.QueryString["id"])
{
string sqlck = "select taizhang_id from taizhang_info where taizhang_id='" + Request.QueryString["id"] + "' and manager_id=" + ViewState["user_id"];
string resultck = DB.ExecuteSqlValue(sqlck, null);
if (resultck == "" || resultck == "no")
{
SystemTool.AlertShow(this, "非添加者，不可操作此记录");
return;
}
string sql = "update taizhang_info set yuefen=@yuefen,shiyongdanwei=@shiyongdanwei,jihuabianhao=@jihuabianhao,zijinlaiyuan=@zijinlaiyuan,jihualeixing=@jihualeixing,xunjiayuan=@xunjiayuan,caigoubianhao=@caigoubianhao,wuzishuxing=@wuzishuxing,wuzibianma=@wuzibianma,dingjiawuzimingcheng=@dingjiawuzimingcheng,dingjiaguigexinghao=@dingjiaguigexinghao,dingjiadanwei=@dingjiadanwei,dingjiashuliang=@dingjiashuliang,hanshuidanjia=@hanshuidanjia,hanshuijine=@hanshuijine,shuilv=@shuilv,caigoufangshi=@caigoufangshi,suoshuxieyihao=@suoshuxieyihao,dingdanbianhao=@dingdanbianhao,dinghuoyiju=@dinghuoyiju,jiaohuodidian=@jiaohuodidian,zhizaoshang=@zhizaoshang,wuzipinpai=@wuzipinpai,gonghuochangshang=@gonghuochangshang,dianshangpingtai=@dianshangpingtai,wangdianmingcheng=@wangdianmingcheng,fukuanfangshi=@fukuanfangshi,changshangdianhua=@changshangdianhua,dingdanriqi=@dingdanriqi,jiaohuoqi=@jiaohuoqi,yingdaoshijian=@yingdaoshijian,shidaoshijian=@shidaoshijian,shiyongshouming=@shiyongshouming,zhibaoqi=@zhibaoqi,qita=@qita,beizhu=@beizhu,isfinished=@isfinished where taizhang_id=" + Request.QueryString["id"];
int result = DB.ExecuteSql(sql, pars);
if (result > 0)
{
SystemTool.AlertShow_Refresh1(this, "保存成功", "taizhang_list.aspx");
}
else
{
SystemTool.AlertShow(this, "保存失败");
return;
}
}
else
{
string sql = "insert into taizhang_info( yuefen,shiyongdanwei,jihuabianhao,zijinlaiyuan,jihualeixing,xunjiayuan,caigoubianhao,wuzishuxing,wuzibianma,dingjiawuzimingcheng,dingjiaguigexinghao,dingjiadanwei,dingjiashuliang,hanshuidanjia,hanshuijine,shuilv,caigoufangshi,suoshuxieyihao,dingdanbianhao,dinghuoyiju,jiaohuodidian,zhizaoshang,wuzipinpai,gonghuochangshang,dianshangpingtai,wangdianmingcheng,fukuanfangshi,changshangdianhua,dingdanriqi,jiaohuoqi,yingdaoshijian,shidaoshijian,shiyongshouming,zhibaoqi,qita,beizhu) values (@yuefen,@shiyongdanwei,@jihuabianhao,@zijinlaiyuan,@jihualeixing,@xunjiayuan,@caigoubianhao,@wuzishuxing,@wuzibianma,@dingjiawuzimingcheng,@dingjiaguigexinghao,@dingjiadanwei,@dingjiashuliang,@hanshuidanjia,@hanshuijine,@shuilv,@caigoufangshi,@suoshuxieyihao,@dingdanbianhao,@dinghuoyiju,@jiaohuodidian,@zhizaoshang,@wuzipinpai,@gonghuochangshang,@dianshangpingtai,@wangdianmingcheng,@fukuanfangshi,@changshangdianhua,@dingdanriqi,@jiaohuoqi,@yingdaoshijian,@shidaoshijian,@shiyongshouming,@zhibaoqi,@qita,@beizhu)";
int result = DB.ExecuteSql(sql, pars);
if (result > 0)
{
SystemTool.AlertShow_Refresh1(this, "保存成功", "taizhang_list.aspx");
}
else
{
SystemTool.AlertShow(this, "保存失败");
return;
}
}
}
protected void btnok_Click(object sender, EventArgs e)
{
if (txtname.Text == "")
{
SystemTool.AlertShow(this, "组名称不能为空");
return;
}
//string diqu_ids = "";
//for (int i = 0; i < rpt_sheng.Items.Count; i++)
//{
// CheckBox ckb = rpt_sheng.Items[i].FindControl("ckb") as CheckBox;
// if (ckb.Checked == true)
// {
// diqu_ids += ckb.ToolTip + ",";
// }
// Repeater rpta = rpt_sheng.Items[i].FindControl("rpta_sheng") as Repeater;
// for (int j = 0; j < rpta.Items.Count; j++)
// {
// CheckBox ckba = rpta.Items[j].FindControl("ckba") as CheckBox;
// if (ckba.Checked == true)
// {
// diqu_ids += ckba.ToolTip + ",";
// }
// }
//}
//if (diqu_ids.Length > 0)
//{
// diqu_ids = diqu_ids.Substring(0, diqu_ids.Length - 1);
//}
//else
//{
// SystemTool.AlertShow(this, "请选择地区");
// return;
//}
string moduleIds = "";
for (int i = 0; i < rpt.Items.Count; i++)
{
CheckBox ckb = rpt.Items[i].FindControl("ckb") as CheckBox;
if (ckb.Checked == true)
{
moduleIds += ckb.ToolTip + ",";
}
Repeater rpta = rpt.Items[i].FindControl("rpta") as Repeater;
for (int j = 0; j < rpta.Items.Count; j++)
{
CheckBox ckba = rpta.Items[j].FindControl("ckba") as CheckBox;
if (ckba.Checked == true)
{
moduleIds += ckba.ToolTip + ",";
}
}
}
if (moduleIds.Length > 0)
{
moduleIds = moduleIds.Substring(0, moduleIds.Length - 1);
}
else
{
SystemTool.AlertShow(this, "请选择组权限");
return;
}
string sql = "";
int result = 0;
if (null != Request.QueryString["manId"])
{
//更新操作
sql = "update role_info set roleName='" + SystemTool.NoHtml(txtname.Text) + "',moduleId='" + moduleIds + "',remark='" + SystemTool.NoHtml(txtbeizhu.Value) + "',state='" + ddlState.SelectedValue + "',quanxianzhi=" + SystemTool.NoHtml(txtpassok.Text) + ",paixu=" + SystemTool.NoHtml(paixu.Text) + ",diqu_ids='' where id=" + SystemTool.NoHtml(Request.QueryString["manId"]);
result = DB.ExecuteSql(sql, null);
}
else
{
sql = "select id from role_info where roleName='" + SystemTool.NoHtml(txtname.Text) + "'";
string r = DB.ExecuteSqlValue(sql, null);
if (r != "" && r != "no")
{
SystemTool.AlertShow(this, "组名称已存在");
return;
}
sql = "insert into role_info (roleName,moduleId,remark,state,quanxianzhi,paixu,diqu_ids) values('" + SystemTool.NoHtml(txtname.Text) + "','" + moduleIds + "','" + SystemTool.NoHtml(txtbeizhu.Value) + "','" + ddlState.SelectedValue + "'," + SystemTool.NoHtml(txtpassok.Text) + "," + SystemTool.NoHtml(paixu.Text) + ",'')";
result = DB.ExecuteSql(sql, null);
}
if (result > 0)
{
SystemTool.AlertShow_Refresh1(this, "保存成功", "guanliyuanzulist.aspx");
}
else
{
SystemTool.AlertShow(this, "保存失败");
return;
}
}