/// <summary>
/// 绑定单位
/// </summary>
private void BindBddw()
{
string sql = "select pfdw from dlysxx where len(id)>13 ";
//检查角色：1：派单员，2：库管，8：线管
if (Session["roleid"] != null && Session["deptname"] != null && (Session["roleid"].ToString() == "1" || Session["roleid"].ToString() == "2" || Session["roleid"].ToString() == "8"))
{
sql += " and pfdw='" + Session["deptname"].ToString() + "'";
}
//3:外包单位;
if (Session["roleid"] != null && Session["deptname"] != null && Session["roleid"].ToString() == "3")
{
sql += " and whdw='" + Session["deptname"].ToString() + "'";
}
//7：区域维护
if (Session["roleid"] != null && Session["uname"] != null && Session["roleid"].ToString() == "7")
{
sql += " and qywh='" + Session["uname"].ToString() + "'";
}
sql += " group by pfdw";
DataSet ds = DirectDataAccessor.QueryForDataSet(sql);
ddlpfdw.Items.Add(new ListItem("----全部----", "0"));
foreach (DataRow dr in ds.Tables[0].Rows)
{
ddlpfdw.Items.Add(dr[0].ToString());
}
}
///// <summary>
///// 绑定repeater
///// </summary>
private void NewsBind()
{
DataSet ds = DirectDataAccessor.QueryForDataSet(GetSqlStr());
repData.DataSource = ds;
repData.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "update xlqxxx set hfsj='" + hfsj.Text + "' where id='" + qxid.Text + "'";
DirectDataAccessor.Execute(sql);
ClientScript.RegisterStartupScript(this.GetType(), "info", "alert('该抢修设置完结成功！');location.href='" + url + "'", true);
}
/// <summary>
/// 获取DataTable
/// </summary>
/// <returns></returns>
private DataTable GetDataTable()
{
string sqlStr = "select * from xlbdxx_llmx ";
DataSet ds = DirectDataAccessor.QueryForDataSet(sqlStr);
return(ds.Tables[0]);
}
/// <summary>
/// 绑定类别
/// </summary>
private void BindClass()
{
string strPre = Request.QueryString["pre"] != null ? Request.QueryString["pre"].ToString() : Session["pre"].ToString();
string sql = "select * from " + strPre + "yjylkc_Class";
//判断权限：0:admin看全部；4：运维部看全部；2：库管，5：公众领导不能看南水北调；11：南水北调库管只操作南水北调
if (Session["roleid"] != null)
{
switch (Session["roleid"].ToString())
{
case "2":
case "5":
sql += " where classname<>'南水北调'";
break;
case "11":
sql += " where classname='南水北调'";
break;
}
}
DataSet ds = DirectDataAccessor.QueryForDataSet(sql);
ddlClass.Items.Add(new ListItem("---全部---", "0"));
foreach (DataRow dr in ds.Tables[0].Rows)
{
ddlClass.Items.Add(new ListItem(dr[1].ToString()));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["uname"] == null || Session["uname"].ToString() == "" || Session["roleid"] == null || Session["roleid"].ToString() == "")
{
Response.Write("<script type='text/javascript'>alert('请重新登陆！');top.location.href='../';</script>");
}
else
{
BindCity();
BindClass();
NewsBind();
if (Request.QueryString["action"] == "del" && Session["pre"] != null)
{
int infoid = 0;
if (Request.QueryString["id"] == null || !int.TryParse(Request.QueryString["id"].ToString(), out infoid))
{
Response.Write("参数错误！");
Response.End();
}
else
{
DirectDataAccessor.Execute("Delete from " + Session["pre"].ToString() + "yjylkc_kcmx where id='" + infoid.ToString() + "'");
ClientScript.RegisterStartupScript(this.GetType(), "info", "alert('删除成功！'); location.href='" + Request.UrlReferrer + "';", true);
}
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "update xlqgxx set sgdw='" + sgdw.Text + "',sgdwfzr='" + sgdwfzr.Text + "',sgdwlxdh='" + sgdwlxdh.Text + "' where id='" + id.InnerText + "'";
DirectDataAccessor.Execute(sql);
ClientScript.RegisterStartupScript(this.GetType(), "info", "alert('迁改派单成功！');location.href='" + url + "'", true);
}
/// <summary>
/// 绑定repeater
/// </summary>
private void NewsBind()
{
string sql = "select '日常维护与考核（满分100分)' as pclass, b.id,row_number() over( order by b.id,itemname) as rowid,a.classname,itemname,std,marks,markstd";
sql += " from xlkh_class as a join xlkh_item as b ";
sql += "on b.classid=a.id and ";
if (Session["roleid"].ToString() == "4")//运维部考核
{
sql += " a.parentid=3";
}
else
{
if (Session["roleid"].ToString() == "5")//响应中心考核长线局
{
sql += "a.parentid=19";
}
else
{
sql += " a.parentid=2";
}
}
DataSet ds = DirectDataAccessor.QueryForDataSet(sql);
repData.DataSource = ds;
repData.DataBind();
MergeCells(repData, "pclass");
MergeCells(repData, "classname");
MergeCells(repData, "itemname");
if (Session["roleid"].ToString() == "5")//响应中心考核长线局
{
MergeCells(repData, "lblMarks");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "update xlzgxx set zgcs='" + zgcs.Text + "',zgr='" + zgr.Text + "' where id='" + zgid.InnerText + "'";
DirectDataAccessor.Execute(sql);
ClientScript.RegisterStartupScript(this.GetType(), "info", "alert('整改措施录入成功！');location.href='" + url + "'", true);
}
protected void Button1_Click(object sender, EventArgs e)
{
//创建正则表达式，验证密码强度
string pattern = @"^(([A-Z]*|[a-z]*|\d*|[-_\~!@#\$%\^&\*\.\(\)\[\]\{\}<>\?\\\/\'\""]*)|.{0,7})$|\s";
Regex reg = new Regex(pattern);
if (reg.IsMatch(txtRenew.Text))
{
ClientScript.RegisterStartupScript(this.GetType(), "info", "alert('新密码必须包含字母、数字和符号！！')", true);
}
else
{
string sql = "select * from userinfo where uname=@uname and passwd=@oldpasswd";
SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@uname", uname.InnerText), new SqlParameter("@oldpasswd", FormsAuthentication.HashPasswordForStoringInConfigFile(txtOld.Text, "MD5").ToLower()), new SqlParameter("@newpasswd", FormsAuthentication.HashPasswordForStoringInConfigFile(txtRenew.Text, "MD5").ToLower()) };
DataSet ds = DirectDataAccessor.QueryForDataSet(sql, paras);
if (ds.Tables[0].Rows.Count > 0)
{
string UpdateSql = "update userinfo set passwd=@newpasswd where uname=@uname";
SqlHelper.ExecuteNonQuery(SqlHelper.GetConnection(), CommandType.Text, UpdateSql, paras);
ClientScript.RegisterStartupScript(this.GetType(), "info", "alert('密码修改成功！')", true);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Error", "alert('旧密码错误，请重新输入！')", true);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["uname"] == null || Session["uname"].ToString() == "")
{
Response.Write("<script type='text/javascript'>alert('请重新登陆！');top.location.href='../';</script>");
}
else
{
//判断权限，派单人有权确认电缆延伸完结
if (Session["roleid"] == null || Session["roleid"].ToString() != "1")
{
Response.Write("<script type='text/javascript'>alert('您没有相应的权限，请重新登陆！');top.location.href='../';</script>");
}
if (Request.QueryString["zgid"] == null)
{
Response.Write("参数错误！");
Response.End();
}
else
{
zgid.InnerText = Request.QueryString["zgid"].ToString();
DataSet ds = DirectDataAccessor.QueryForDataSet("select * from dlysxx where id='" + Request.QueryString["zgid"].ToString() + "'");
if (ds.Tables[0].Rows.Count < 1)
{
Response.Write("参数错误！");
Response.End();
}
else
{
whdw.InnerHtml = ds.Tables[0].Rows[0][1].ToString();
fzr.InnerHtml = ds.Tables[0].Rows[0][2].ToString();
zgqy.InnerHtml = ds.Tables[0].Rows[0][3].ToString();
czwt.InnerHtml = ds.Tables[0].Rows[0][4].ToString();
zgyq.InnerHtml = ds.Tables[0].Rows[0][5].ToString();
zgsx.InnerHtml = ds.Tables[0].Rows[0][6].ToString();
pdr.InnerHtml = ds.Tables[0].Rows[0]["pdr"].ToString();
pdsj.InnerHtml = ds.Tables[0].Rows[0]["pdsj"].ToString();
zgcs.InnerHtml = ds.Tables[0].Rows[0]["zgcs"].ToString();
zgr.InnerHtml = ds.Tables[0].Rows[0]["zgr"].ToString();
wjsj.InnerHtml = ds.Tables[0].Rows[0]["wjsj"].ToString();
lxr.InnerHtml = ds.Tables[0].Rows[0]["lxr"].ToString();
lxdh.InnerHtml = ds.Tables[0].Rows[0]["lxdh"].ToString();
qywh.InnerHtml = ds.Tables[0].Rows[0]["qywh"].ToString();
if (Request.QueryString["bz"] != null && Request.QueryString["bz"].ToString() == "1")
{
zgbz.Text = ds.Tables[0].Rows[0]["zgbz"].ToString();
zgbz.ReadOnly = true;
}
}
}
}
if (Request.UrlReferrer != null && Request.UrlReferrer != Request.Url)
{
url = Request.UrlReferrer.ToString();
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "INSERT INTO userinfo VALUES('" + uname.Text + "','ayltyw.0','" + ddlDept.SelectedItem.Text + "','" + ddlRole.Text + "','" + pre.Text + "',1)";
DirectDataAccessor.Execute(sql);
ClientScript.RegisterStartupScript(this.GetType(), "info", "alert('用户添加成功！');location.href=location.href;", true);
}
/// <summary>
/// 绑定repeater
/// </summary>
private void NewsBind()
{
double total = 0;
StringBuilder sql = new StringBuilder("select b.id,row_number() over(order by b.orderid) as rowid,a.classname,itemname,std,marks,markstd");
sql.Append(",c.score,c.memo,c.markingdept,c.markingtime ");
sql.Append("from ((zwkh_class as a join zwkh_item as b ");
sql.Append("on b.classid=a.id and a.id=1) join zwkh_marking as c ");
sql.Append("on b.id=c.itemid and c.deptname='" + deptname.InnerHtml + "' and c.scoredate='" + scoredate.InnerText + "')");
DataSet ds = DirectDataAccessor.QueryForDataSet(sql.ToString());
repData.DataSource = ds;
repData.DataBind();
//前台显示
MergeCells(repData, "classname");
foreach (DataRow dr in ds.Tables[0].Rows)
{
total += double.Parse(dr["score"].ToString());
}
trtotal.InnerText = total.ToString();
if (ds.Tables[0].Rows.Count > 0)
{
markingdept.InnerHtml = "<b>考核单位：</b>" + ds.Tables[0].Rows[0]["markingdept"];
markingtime.InnerHtml = "<b>考核时间：</b>" + ds.Tables[0].Rows[0]["markingtime"];
}
}
protected void btnExportExcel_Click(object sender, EventArgs e)
{
string outputFileName = "";
if (Request.QueryString["qj"] != null)
{
outputFileName += Request.QueryString["qj"].ToString() + "-";
}
if (Request.QueryString["dw"] != null)
{
outputFileName += Request.QueryString["dw"].ToString() + "-";
}
if (Request.QueryString["qrwj"] != null)
{
if (Request.QueryString["qrwj"] == "1")
{
outputFileName += "已完结-";
}
if (Request.QueryString["qrwj"] == "2")
{
outputFileName += "未完结-";
}
}
outputFileName += "线路整改信息统计.xls";
DataTable dt = DirectDataAccessor.QueryForDataSet(GetSqlStr()).Tables[0];;
xlsGridview(dt, outputFileName);
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql;
if (PanHaoShow(ddlClass.SelectedItem.Text, ddlType.SelectedItem.Text))
{
sql = "insert into yjylkc_llmx values('" + id.InnerText + "','" + cksj.InnerText + "','" + lldw.Text + "','" + llr.Text + "','" + ddlClass.SelectedItem.Text + "',";
sql += "'" + ddlType.SelectedItem.Text + "','" + ddlPanhao.SelectedItem.Text + "','" + amount.Text + "','" + units1.InnerHtml + "','" + yldz.Text + "','" + llyt.Text + "','" + bz.Text + "','" + ckdw.InnerText + "'); ";
sql += "update " + Session["pre"].ToString() + "yjylkc_kcmx set amount=amount-" + amount.Text + " where classname='" + ddlClass.SelectedItem.Text + "' and typename ='" + ddlType.SelectedItem.Text + "' and panhao='" + ddlPanhao.SelectedItem.Text + "' ; ";
}
else
{
sql = "insert into yjylkc_llmx values('" + id.InnerText + "','" + cksj.InnerText + "','" + lldw.Text + "','" + llr.Text + "','" + ddlClass.SelectedItem.Text + "',";
sql += "'" + ddlType.SelectedItem.Text + "','','" + amount.Text + "','" + units1.InnerHtml + "','" + yldz.Text + "','" + llyt.Text + "','" + bz.Text + "','" + ckdw.InnerText + "'); ";
sql += "update " + Session["pre"].ToString() + "yjylkc_kcmx set amount=amount-" + amount.Text + " where classname='" + ddlClass.SelectedItem.Text + "' and typename ='" + ddlType.SelectedItem.Text + "'; ";
}
sql += "Update autoid set " + Pre + "xxid=" + (int.Parse(id.InnerText.Substring(Pre.Length)) + 1);
//写入sql日志
DirectDataAccessor.writeLog("KHJR", Session["pre"].ToString() == "" ? "SQ_" : Session["pre"].ToString(), sql.ToString());
DirectDataAccessor.Execute(sql);
string script = "if (confirm('领料成功！是否继续领料？\\n点击确定继续领料，点击取消返回信息管理页面')){location.href=\"";
script += "yjylkctzlr.aspx?cksj=" + cksj.InnerText + "&lldw=" + Server.UrlEncode(lldw.Text) + "&llr=" + Server.UrlEncode(llr.Text) + "&id=" + id.InnerText + "\";}";
script += "else{location.href=\"yjylkctzgl.aspx\";}";
ClientScript.RegisterStartupScript(this.GetType(), "info", script, true);
}
/// <summary>
/// 绑定区域维护
/// </summary>
private void Bindqywh()
{
string sql = "select qywh from dlysxx where len(id)=13";
//检查角色：1：派单员，2：库管，8：线管(2014年7月15日 去掉2,8)
if (Session["roleid"] != null && Session["deptname"] != null && Session["roleid"].ToString() == "1")
{
sql += " and pfdw='" + Session["deptname"].ToString() + "' and qywh<>''";
}
//3:外包单位;
if (Session["roleid"] != null && Session["deptname"] != null && Session["roleid"].ToString() == "3")
{
sql += " and whdw='" + Session["deptname"].ToString() + "' and qywh<>''";
}
//7：区域维护
if (Session["roleid"] != null && Session["uname"] != null && Session["roleid"].ToString() == "7")
{
sql += " and qywh='" + Session["uname"].ToString() + "' and qywh<>''";
}
//0：管理员
if (Session["roleid"] != null && Session["uname"] != null && Session["roleid"].ToString() == "0")
{
sql += " and qywh<>''";
}
sql += " group by qywh";
DataSet ds = DirectDataAccessor.QueryForDataSet(sql);
ddlqywh.Items.Add(new ListItem("----全部----", "0"));
foreach (DataRow dr in ds.Tables[0].Rows)
{
ddlqywh.Items.Add(dr[0].ToString());
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "update dlysxx set qrwjsj='" + qrwjsj.Text + "',zgbz='" + zgbz.Text + "' where id='" + zgid.InnerText + "'";
DirectDataAccessor.Execute(sql);
ClientScript.RegisterStartupScript(this.GetType(), "info", "alert('电缆延伸完结时间设置成功！');location.href='" + url + "'", true);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["uname"] == null || Session["uname"].ToString() == "")
{
Response.Write("<script type='text/javascript'>alert('请重新登陆！');top.location.href='../';</script>");
}
else
{
if (Request.QueryString["id"] == null)
{
Response.Write("参数错误！");
Response.End();
}
else
{
id.InnerHtml = Request.QueryString["id"].ToString();
DataSet ds = DirectDataAccessor.QueryForDataSet("select * from nsbdxx where id='" + Request.QueryString["id"].ToString() + "'");
if (ds.Tables[0].Rows.Count < 1)
{
Response.Write("参数错误！");
Response.End();
}
else
{
fssj.InnerHtml = ds.Tables[0].Rows[0][1].ToString();
fsdw.InnerHtml = ds.Tables[0].Rows[0][2].ToString();
lxr.InnerHtml = ds.Tables[0].Rows[0][3].ToString();
lxdh.InnerHtml = ds.Tables[0].Rows[0][4].ToString();
dd.InnerHtml = ds.Tables[0].Rows[0][5].ToString();
sgdd.InnerHtml = ds.Tables[0].Rows[0][6].ToString();
sy.InnerHtml = ds.Tables[0].Rows[0][7].ToString();
ysje.InnerHtml = ds.Tables[0].Rows[0][8].ToString();
ysyj.InnerHtml = ds.Tables[0].Rows[0][12].ToString();
ysr.InnerHtml = ds.Tables[0].Rows[0][13].ToString();
yssj.InnerHtml = ds.Tables[0].Rows[0][14].ToString();
sssj.InnerHtml = ds.Tables[0].Rows[0][15].ToString();
ssje.InnerHtml = ds.Tables[0].Rows[0][16].ToString();
sjsj.InnerHtml = ds.Tables[0].Rows[0][17].ToString();
sjje.InnerHtml = ds.Tables[0].Rows[0][18].ToString();
ffsj.InnerHtml = ds.Tables[0].Rows[0][19].ToString();
//设置前台显示
//派单信息
sgdwxx.InnerHtml = ds.Tables[0].Rows[0][9].ToString() == "" ? "<span style='color:#F98E02;font-weight:700;'>该南水北调工单未派单</span>" : "施工单位：" + ds.Tables[0].Rows[0][7].ToString() + " 负责人：" + ds.Tables[0].Rows[0][8].ToString() + " 联系电话：" + ds.Tables[0].Rows[0][9].ToString();
qgll.InnerHtml = ds.Tables[0].Rows[0][20].ToString() == "0" ? "<span style='color:#1F41EF;font-weight:700;'>该南水北调未领料</span>" : "<a href=nsbdllxxxq.aspx?id=" + id.InnerText + " target='_blank'>点击查看领料详情</a>";
qgtl.InnerHtml = ds.Tables[0].Rows[0][21].ToString() == "0" ? "<span style='color:#17A0EF;font-weight:700;'>该南水北调未退料</span>" : "<a href=nsbdtlxxxq.aspx?id=" + id.InnerText + ">点击查看退料详情</a>";
isSs = ds.Tables[0].Rows[0][15].ToString() == "" ? false : true;
isSj = ds.Tables[0].Rows[0][17].ToString() == "" ? false : true;
isFf = ds.Tables[0].Rows[0][19].ToString() == "" ? false : true;
isYs = ds.Tables[0].Rows[0][10].ToString() == "" ? false : true;
sjbz.InnerHtml = isFf ? "<span class='b_red'>已付费</span>" : isSj ? "<span class='b_orange'>已审计，未付费</span>" : isSs ? "<span class='b_blue'>已送审，未审计</span>" : "<span class='b_green'>未送审</span>";
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["uname"] == null || Session["uname"].ToString() == "" || Request.QueryString["ym"] == null || Request.QueryString["ym"] == "")
{
Response.Write("<script type='text/javascript'>alert('请重新登陆！');window.location.href='Default.aspx';</script>");
}
else
{
string scoreDate = Request.QueryString["ym"];
StringBuilder sql = new StringBuilder();
sql.Append("select * from ywbkh_marking ");
sql.Append("where markinguser='******' and ");
sql.Append("scoremonth='" + scoreDate + "' and itemid='a'");
DataSet ds = DirectDataAccessor.QueryForDataSet(sql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
repList.DataSource = ds;
repList.DataBind();
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "show", "document.getElementById('noScore').style.display = 'block';document.getElementById('scoreList').style.display = 'none';", true);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["uname"] == null || Session["uname"].ToString() == "" || Session["roleid"] == null || Session["roleid"].ToString() == "")
{
Response.Write("<script type='text/javascript'>alert('请重新登陆！');window.location.href='Default.aspx';</script>");
}
else
{
if (Session["uname"] != null)
{
lblDeptName.Text = "当前用户：" + Session["uname"].ToString();
}
markmonth.InnerText = DateTime.Now.AddMonths(-1).ToString("yyyy年MM月");
//绑定Repepater开始
DataSet ds = DirectDataAccessor.QueryForDataSet(" select username from ywbkh_userinfo where roleid<>'0'");
rep.DataSource = ds;
rep.DataBind();
//绑定Repepater结束
// 绑定下拉列表框
DataSet ds1 = DirectDataAccessor.QueryForDataSet("select scoremonth from ywbkh_marking group by scoremonth ");
foreach (DataRow dr in ds1.Tables[0].Rows)
{
ddlYm.Items.Add(new ListItem(dr[0].ToString().Trim()));
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["uname"] == null || Session["uname"].ToString() == "")
{
Response.Write("<script type='text/javascript'>alert('请重新登陆！');top.location.href='../';</script>");
}
else
{
BindMonth();
Bindqxdw();
NewsBind();
//判断是否运维部超管
isAdminYW = (Session["roleid"].ToString() == "0" && Session["deptname"].ToString() == "运行维护部") ? true : false;
//删除
if (Request.QueryString["action"] == "del")
{
if (Request.QueryString["id"] == null || Request.QueryString["id"].ToString() == "")
{
Response.Write("参数错误！");
Response.End();
}
else
{
DirectDataAccessor.Execute("Delete from xlqxxx where id='" + Request.QueryString["id"] + "'");
ClientScript.RegisterStartupScript(this.GetType(), "info", "alert('删除成功！'); location.href='xlqxxxgl.aspx';", true);
}
}
}
}
}
/// <summary>
/// 绑定类别
/// </summary>
private void BindClass()
{
string sql = "select * from " + Session["pre"] + "yjylkc_Class ";
//判断权限：2：库管不能看南水北调；11：南水北调库管只操作南水北调
if (Session["roleid"] != null)
{
switch (Session["roleid"].ToString())
{
case "2":
sql += " where classname<>'南水北调'";
break;
case "11":
sql += " where classname='南水北调'";
break;
}
}
DataSet ds = DirectDataAccessor.QueryForDataSet(sql);
ddlClass.Items.Add(new ListItem("选择类别", "0"));
foreach (DataRow dr in ds.Tables[0].Rows)
{
ddlClass.Items.Add(new ListItem(dr[1].ToString(), dr[0].ToString()));
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "update xlqgxx set sjsj='" + sjsj.Text + "',sjje='" + sjje.Text + "' where id='" + id.InnerText + "'";
DirectDataAccessor.Execute(sql);
ClientScript.RegisterStartupScript(this.GetType(), "info", "alert('成功提交审计信息！');location.href='" + url + "'", true);
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "INSERT INTO " + Session["pre"] + "yjylkc_Type(classid,typename,units) VALUES('" + ddlClass.SelectedValue + "','" + txtType.Text + "','" + txtUnits.Text + "')";
DirectDataAccessor.Execute(sql);
ClientScript.RegisterStartupScript(this.GetType(), "info", "alert('型号添加成功！');location.href=location.href;", true);
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "update nsbdxx set ysyj='" + ysyj.Text + "',ysr='" + ysr.Text + "',yssj='" + yssj.Text + "' where id='" + id.InnerText + "'";
DirectDataAccessor.Execute(sql);
ClientScript.RegisterStartupScript(this.GetType(), "info", "alert('该南水北调验收完成，进入审计报账状态！');location.href='" + url + "'", true);
}
protected void Page_Load(object sender, EventArgs e)
{
Pre = Session["pre"] != null ? Session["pre"].ToString() : "";
if (!IsPostBack)
{
if (Session["uname"] == null || Session["uname"].ToString() == "")
{
Response.Write("<script type='text/javascript'>alert('请重新登陆！');top.location.href='../';</script>");
}
else
{
//判断角色 为 1，各单位派单人员可以录单
if (Session["roleid"] == null || Session["roleid"].ToString() != "1")
{
Response.Write("<script type='text/javascript'>alert('权限不足，请重新登陆！');top.location.href='../';</script>");
}
//获取编号
DataSet dr = DirectDataAccessor.QueryForDataSet("SELECT " + Pre + "xxid FROM autoid");
string currentId = dr.Tables[0].Rows[0][0].ToString();
string datePre = DateTime.Now.ToString("yyyyMM");
if (currentId.Substring(0, 6) == datePre)
{
id.InnerText = Pre + currentId;
}
else
{
id.InnerText = Pre + datePre + "001";
}
fsdw.InnerText = Session["deptname"].ToString();
fssj.InnerText = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
}
}
private void BindDept()
{
//各县打自己
if (Session["deptname"].ToString() != "网络管理中心" && Session["deptname"].ToString() != "网络部")
{
deptname.Items.Add(Session["deptname"].ToString());
}
else
{
//网维打市区
string sql = "select deptname from jzkh_deptinfo";
if (Session["deptname"] != null && Session["deptname"].ToString() == "网络管理中心")
{
sql = "select deptname from jzkh_deptinfo where id=1";
}
//运维部打市公司对各县考核
else if (Session["deptname"] != null && Session["deptname"].ToString() == "网络部")
{
sql = "select deptname from jzkh_deptinfo";
}
DataSet ds = DirectDataAccessor.QueryForDataSet(sql);
deptname.Items.Add(new ListItem("选择被考核分公司", "0"));
foreach (DataRow dr in ds.Tables[0].Rows)
{
deptname.Items.Add(dr[0].ToString());
}
}
}
/// <summary>
/// 获取DataTable
/// </summary>
/// <returns></returns>
private DataTable GetDataTable()
{
string sql;
sql = "select b.* from yjkxx as a join yjkxx_llmx as b on a.id=b.yjkid ";
if (Session["roleid"] != null && (Session["roleid"].ToString() == "2" || Session["roleid"].ToString() == "1") && Session["pre"].ToString() != "")
{
sql += " and b.jsdw='" + Session["deptname"] + "' ";
}
string whereStr = "where";
if (Request.QueryString["qj"] != null)
{
ddlMonth.Text = Request.QueryString["qj"].ToString();
whereStr += " substring (cksj,0,8)>='" + Request.QueryString["qj"].ToString() + "' and";
}
else
{
whereStr += " substring (cksj,0,8)>='" + DateTime.Now.AddMonths(-1).ToString("yyyy-MM") + "' and";
}
if (Request.QueryString["jz"] != null)
{
ddlMonth1.Text = Request.QueryString["jz"].ToString();
whereStr += " substring (cksj,0,8)<='" + Request.QueryString["jz"].ToString() + "' and";
}
else
{
whereStr += " substring (cksj,0,8)<='" + DateTime.Now.ToString("yyyy-MM") + "' and";
}
if (Request.QueryString["typename"] != null)
{
ddlType.Text = Server.UrlDecode(Request.QueryString["typename"].ToString());
whereStr += " typename = '" + Server.UrlDecode(Request.QueryString["typename"].ToString()) + "' and";
}
if (Request.QueryString["lldw"] != null)
{
lldw.Text = Server.UrlDecode(Request.QueryString["lldw"].ToString());
whereStr += " b.jsdw = '" + Server.UrlDecode(Request.QueryString["lldw"].ToString()) + "' and";
}
if (Request.QueryString["yjkid"] != null)
{
yjkid.Text = Request.QueryString["yjkid"].ToString();
whereStr += " yjkid like '%" + Request.QueryString["yjkid"].ToString() + "%' and";
}
if (whereStr != "where")
{
whereStr = whereStr.Substring(0, whereStr.Length - 3);
sql += whereStr;
}
sql += " order by b.id desc";
//Response.Write (sql);
//Response.End();
//return null;
DataSet ds = DirectDataAccessor.QueryForDataSet(sql);
return(ds.Tables[0]);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["uname"] == null || Session["uname"].ToString() == "")
{
Response.Write("<script type='text/javascript'>alert('请重新登陆！');top.location.href='../';</script>");
}
else
{
if (Request.QueryString["bdid"] == null)
{
Response.Write("参数错误！");
Response.End();
}
else
{
bdid.Text = Request.QueryString["bdid"].ToString();
DataSet ds = DirectDataAccessor.QueryForDataSet("select * from xlbdxx where id='" + Request.QueryString["bdid"].ToString() + "'");
if (ds.Tables[0].Rows.Count < 1)
{
Response.Write("参数错误！");
Response.End();
}
else
{
bdrq.Text = ds.Tables[0].Rows[0][1].ToString();
bddd.Text = ds.Tables[0].Rows[0][2].ToString();
bgarq.Text = ds.Tables[0].Rows[0][4].ToString();
bbxgsrq.Text = ds.Tables[0].Rows[0][5].ToString();
bxgscxc.Text = ds.Tables[0].Rows[0][6].ToString();
bdss.Text = ds.Tables[0].Rows[0][7].ToString();
ssje.Text = ds.Tables[0].Rows[0][8].ToString();
hfsj.Text = ds.Tables[0].Rows[0][9].ToString();
bdll.Text = ds.Tables[0].Rows[0][10].ToString() == "0" ? "<span style='color:#F98E02;font-weight:700;'>该被盗未领料</span>" : "<a href=xlbdllxxxq.aspx?bdid=" + bdid.Text + " target='_blank'>点击查看领料详情</a>";
bdwj.Text = ds.Tables[0].Rows[0][9].ToString() == "" ? "<span style='color:#E82246;font-weight:700;'>未完结</span>" : "已完结";
//被盗现场照片
DataSet dsxc = DirectDataAccessor.QueryForDataSet("select * from Attachment_BDAndQX where InfoAutoID='" + Request.QueryString["bdid"].ToString() + "' and LiveOrFinish=0");
if (dsxc.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsxc.Tables[0].Rows)
{
bdxczp.Text += "<span style='margin-right:10px;'><a target='_blank' style='margin-left:6px;' href='../" + dr["filepath"] + "' title='点击查看'>" + dr["filename"] + "</a></span>";
}
}
//被盗恢复现场照片
DataSet dshf = DirectDataAccessor.QueryForDataSet("select * from Attachment_BDAndQX where InfoAutoID='" + Request.QueryString["bdid"].ToString() + "' and LiveOrFinish=1");
if (dshf.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dshf.Tables[0].Rows)
{
bdhfxc.Text += "<span style='margin-right:10px;'><a target='_blank' style='margin-left:6px;' href='../" + dr["filepath"] + "' title='点击查看'>" + dr["filename"] + "</a></span>";
}
}
}
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
double total = 0, ratio;
ratio = fieldPre == "sgs_" ? 0.1 : 0.25;
string sqlExit = "select count(*) from jzkh_marking where deptname='" + deptname.Text + "' and scoredate='" + scoredate.InnerText + "'";
sqlExit += " and markingdept='" + Session["deptname"].ToString() + "'";
sqlExit += " and itemid in( select b.id from jzkh_class as a join jzkh_item as b ";
sqlExit += " on b.classid=a.id and a.parentid=3)";
DataSet ds = DirectDataAccessor.QueryForDataSet(sqlExit);
if (ds.Tables[0].Rows[0][0].ToString() != "0")
{
ClientScript.RegisterStartupScript(this.GetType(), "info", "alert('已经对" + deptname.Text + "分公司考核成功，不能重复考核！');location.href=location.href;", true);
return;
}
StringBuilder sql = new StringBuilder();
foreach (RepeaterItem rpitem in repData.Items)
{
TextBox score = (TextBox)rpitem.FindControl("txtscore");
HiddenField itemid = (HiddenField)rpitem.FindControl("hfid");
TextBox memo = (TextBox)rpitem.FindControl("txtmemo");
sql.Append("insert into jzkh_marking values('");
sql.Append(deptname.Text); sql.Append("','");
sql.Append(scoredate.InnerText); sql.Append("','");
sql.Append(itemid.Value); sql.Append("','");
sql.Append(score.Text); sql.Append("','");
sql.Append(memo.Text); sql.Append("','");
sql.Append(Session["uname"]); sql.Append("','");
sql.Append(Session["deptname"]); sql.Append("','");
sql.Append(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); sql.Append("');");
}
DirectDataAccessor.Execute(sql.ToString());
StringBuilder sb = new StringBuilder();
string sqlTotal = "select sum(score) from jzkh_marking where deptname='" + deptname.Text + "' and scoredate='" + scoredate.InnerText + "'";
////县公司打分
//if (Session["pre"] != null && Session["pre"].ToString().Trim() != "")
sqlTotal += " and markingdept='" + Session["deptname"].ToString() + "'";
////网络管理中心、网络部打分
//if (Session["pre"] != null && Session["pre"].ToString().Trim() == "")
// sqlTotal += " and (markingdept='网络管理中心' or markingdept='网络部')";
sqlTotal += " and itemid in( select b.id from jzkh_class as a join jzkh_item as b ";
sqlTotal += " on b.classid=a.id and a.parentid=3)";
total = (double)DirectDataAccessor.QueryForDataSet(sqlTotal).Tables[0].Rows[0][0];
//判断当前月，当前分公司记录是否存在，存在就update,不存在就insert
sb.Append("IF EXISTS (SELECT * FROM jzkh_score WHERE deptname ='" + deptname.Text + "' ");
sb.Append(" and scoredate='" + scoredate.InnerText + "') ");
sb.Append(" Update jzkh_score set " + fieldPre + "rcwh_score=" + (100 - total) * ratio + " where deptname='" + deptname.Text + "' ");
sb.Append(" and scoredate='" + scoredate.InnerText + "'");
sb.Append(" ELSE ");
sb.Append(" Insert into jzkh_score(deptname,scoredate," + fieldPre + "rcwh_score) values('" + deptname.Text + "','" + scoredate.InnerText + "'," + (100 - total) * ratio + ")");
DirectDataAccessor.Execute(sb.ToString());
ClientScript.RegisterStartupScript(this.GetType(), "info", "alert('对" + deptname.Text + "分公司考核成功！');location.href=location.href;", true);
}
