/// <summary>
/// 显示系统信息查询结果
/// </summary>
/// <param name="code"></param>
public void displayComputerInfoResult(Code code)
{
PublicCode info = code as PublicCode;
ComputerInfoMsg = info.Msg;
ComputerInfoResult_rTB.Invoke(new RichTextBoxAddEvent(AddComputerInfoResult));
}
protected void btnFCsubmitClick(object sender, AjaxEventArgs e)//提交复查意见
{
if (fcfk_fcyj.Value.ToString() == "" || fcfk_fcqk.SelectedItem.Value.Trim() == "")
{
Ext.Msg.Alert("提示", "输入不可为空!").Show();
}
else
{
//更新走动计划
PublicCode.setUpdateMoveState(SessionBox.GetUserSession().PersonNumber, System.DateTime.Today, decimal.Parse(cbbplace.SelectedItem.Value.Trim()));
this.Tab1.Show();
this.Tab2.Disabled = true;
this.Tab1.Disabled = false;
RowSelectionModel sm = this.GridPanel2.SelectionModel.Primary as RowSelectionModel;
if (sm.SelectedRows.Count > 0)
{
var yinhuanFC = new Nyinhuanreview
{
Yhputinid = Convert.ToInt32(sm.SelectedRows[0].RecordID.Trim()),
Reviewopinion = fcfk_fcyj.Value.ToString(),
Reviewstate = fcfk_fcqk.SelectedItem.Value.Trim(),
Fctime = DateTime.Now,
Personid = SessionBox.GetUserSession().PersonNumber
};
Nyhinput Input = dc.Nyhinput.First(c => c.Yhputinid == Convert.ToInt32(sm.SelectedRows[0].RecordID.Trim()));
Input.Status = fcfk_fcqk.SelectedItem.Value.Trim();
dc.Nyinhuanreview.InsertOnSubmit(yinhuanFC);
dc.SubmitChanges();
bindYH();
Ext.Msg.Alert("提示", "保存成功!").Show();
}
}
}
private DataSet GetSafetyStatistics(DateTime dateBegin, DateTime dateEnd, string maindept, string deptnm, bool isLeader)
{
string strSql = string.Format("select distinct dept.deptnumber maindeptid,dept.deptname maindept,kq.deptnumber deptnumber,kq.deptname deptname,u.username,p.personnumber,p.name,pos.posname,pos.MOVEGBLEVEL,nvl(yh.xj,0) xj,nvl(yh.yh,0) yh,nvl(yh.xc,0) YXC,nvl(yh.fxc,0) fxc,nvl(yh.ybh,0) ybh,nvl(yh.wbh,0) wbh,nvl(sw.sw,0) sw,nvl(dl.LoginCount,0) LoginCount from sf_user u inner join person p on u.personnumber = p.personnumber left join department kq on p.areadeptid=kq.deptnumber left join department dept on p.maindeptid=dept.deptnumber left join position pos on p.posid=pos.posid left join (select personid,count(xj) xj,sum(xj) yh ,sum(xc) xc,sum(fxc) fxc,sum(ybh) ybh,sum(wbh) wbh from (" +
//修改隐患排查时间为排查人的个人排查时间
"select nim.personid,nim.pctime,count(*) xj,sum(case when ni.status='现场整改' then 1 else 0 end) xc,sum(case when ni.status='现场整改' then 0 else 1 end) fxc,sum(case when ni.status='现场整改' or ni.status='复查通过' then 1 else 0 end) ybh,sum(case when ni.status='现场整改' or ni.status='复查通过' then 0 else 1 end) wbh from nyhinput ni inner join NYHINPUT_MORE nim on ni.yhputinid=nim.yhputinid where ni.status not in ('新增','提交审批') and nim.pctime between to_date('{0}','YYYY-MM-DD') and to_date('{1}','YYYY-MM-DD') group by nim.personid,nim.pctime) group by personid ) yh on p.personnumber=yh.personid" +
" left join (select PCPERSONID,count(*) sw from NSWINPUT where pctime between to_date('{2}','YYYY-MM-DD') and to_date('{3}','YYYY-MM-DD') group by PCPERSONID ) sw on p.personnumber=sw.PCPERSONID left join ( SELECT username,count(DISTINCT case when to_number(to_char(vuserlog.activetime,'hh24')) between 0 and 12 then TO_CHAR(vuserlog.activetime,'yyyy-mm-dd')||'上午' when to_number(to_char(vuserlog.activetime,'hh24')) between 12 and 24 then TO_CHAR(vuserlog.activetime,'yyyy-mm-dd')||'下午' end) LoginCount FROM vuserlog where activetype='登录' and username !='yu' and vuserlog.activetime between to_date('{4}','YYYY-MM-DD') and to_date('{5}','YYYY-MM-DD') group by vuserlog.username) dl on u.username = dl.username",
dateBegin.ToString("yyyy-MM-dd"), dateEnd.ToString("yyyy-MM-dd"), dateBegin.ToString("yyyy-MM-dd"), dateEnd.ToString("yyyy-MM-dd"), dateBegin.ToString("yyyy-MM-dd"), dateEnd.ToString("yyyy-MM-dd"));
strSql += " where 1=1";
if (UserHandle.ValidationHandle(PermissionTag.SearchAll))
{
if (maindept != "-1")
{
strSql += string.Format(" and dept.deptnumber='{0}'", maindept);
}
if (deptnm != "-1")
{
strSql += string.Format(" and kq.deptnumber='{0}'", deptnm);
}
if (isLeader)
{
strSql += " and pos.movegblevel='矿领导'"; //or pos.posname like '%矿长' or pos.posname like '%副总')";
}
}
else if (UserHandle.ValidationHandle(PermissionTag.SearchMainDept))
{
strSql += string.Format(" and dept.deptnumber='{0}'", SessionBox.GetUserSession().DeptNumber);
if (deptnm != "-1")
{
strSql += string.Format(" and kq.deptnumber='{0}'", deptnm);
}
if (isLeader)
{
strSql += " and pos.movegblevel='矿领导'"; //or pos.posname like '%矿长' or pos.posname like '%副总')";
}
}
else if (UserHandle.ValidationHandle(PermissionTag.SearchDept))
{
strSql += string.Format(" and dept.deptnumber='{0}'", SessionBox.GetUserSession().DeptNumber);
strSql += string.Format(" and kq.deptnumber='{0}'", PublicCode.GetKQdeptNumber(SessionBox.GetUserSession().PersonNumber));
if (isLeader)
{
strSql += " and pos.movegblevel='矿领导'"; //or pos.posname like '%矿长' or pos.posname like '%副总')";
}
}
else if (UserHandle.ValidationHandle(PermissionTag.SearchPersonal))
{
strSql += string.Format(" and p.personnumber='{0}'", SessionBox.GetUserSession().PersonNumber);
}
else
{
return(new DataSet());
}
return(OracleHelper.Query(strSql));
}
protected void KQRefresh(object sender, StoreRefreshDataEventArgs e)
{
if (cbbMianDept.SelectedIndex > -1)
{
KQStore.DataSource = PublicCode.GetKQdept(cbbMianDept.SelectedItem.Value);
KQStore.DataBind();
cbbKQ.Disabled = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (!string.IsNullOrEmpty(Request["head"]))
{
GridPanel1.TopBar[0].Visible = false;
if (Request["head"].Trim() == "0")
{
GridPanel1.Header = false;
GridPanel1.Height = 160;
}
if (Request["head"].Trim() == "1")
{
GridPanel1.Height = 300;
}
Window1.Listeners.BeforeShow.Fn = "function(el) { el.setHeight(Ext.getBody().getViewSize().height-20);el.setWidth(Ext.getBody().getViewSize().width-20); }";
}
dfBegin.SelectedDate = System.DateTime.Today.AddDays(1 - System.DateTime.Today.Day);
dfEnd.SelectedDate = System.DateTime.Today;
//dfBegin.MaxDate = System.DateTime.Today;
//dfEnd.MaxDate = System.DateTime.Today;
#region 初始化单位
DBSCMDataContext dc = new DBSCMDataContext();
if (SessionBox.GetUserSession().rolelevel.Contains("1") || SessionBox.GetUserSession().rolelevel.Contains("0"))
{
//var dept = from d in dc.Department
// where d.Deptnumber.Substring(4) == "00000" && d.Deptname.EndsWith("矿")
// select new
// {
// d.Deptname,
// Deptid = d.Deptnumber
// };
UnitStore.DataSource = PublicCode.GetMaindept("");
UnitStore.DataBind();
cbbUnit.SelectedItem.Value = "-1";
cbbUnit.Disabled = false;
}
else
{
var dept = from d in dc.Department
where d.Deptnumber == SessionBox.GetUserSession().DeptNumber
select new
{
d.Deptname,
Deptid = d.Deptnumber
};
UnitStore.DataSource = dept;
UnitStore.DataBind();
cbbUnit.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber;
cbbUnit.Disabled = true;
}
#endregion
//storebind();//第一次不加载
}
}
public static int getYujingSW(string deptnumber)//三违预警
{
//DataSet ds = GetKaoHeInfo.GetPersonSWPoint(DateTime.Parse(System.DateTime.Today.Year + "-01-01"), DateTime.Parse(System.DateTime.Today.Year + "-12-31"), deptnumber, "");
//System.Data.DataView dv = new System.Data.DataView(ds.Tables[0]);
//string filter = "三违总数>=" + PublicCode.GetSWMaxCountSet(deptnumber) + " or TOTAL>="+PublicCode.GetSWMaxScoreSet(deptnumber);
//dv.RowFilter = filter;
//ds.Tables.Clear();
//ds.Tables.Add(dv.ToTable());
//return ds.Tables[0].Rows.Count;
DateTime today = DateTime.Today;
DateTime dateTime = DateTime.Parse(string.Concat(today.Year, "-01-01"));
today = DateTime.Today;
DataSet personSWPoint = GetKaoHeInfo.GetPersonSWPoint(dateTime, DateTime.Parse(string.Concat(today.Year, "-12-31")), deptnumber, "");
DataView dataViews = new DataView(personSWPoint.Tables[0]);
object[] sWMaxCountSet = new object[] { "三违总数>=", PublicCode.GetSWMaxCountSet(deptnumber), " or TOTAL>=", PublicCode.GetSWMaxScoreSet(deptnumber) };
dataViews.RowFilter = string.Concat(sWMaxCountSet);
personSWPoint.Tables.Clear();
personSWPoint.Tables.Add(dataViews.ToTable());
return(personSWPoint.Tables[0].Rows.Count);
//DBSCMDataContext dc = new DBSCMDataContext();
//var data = (from sw in dc.Nswinput
// from per in dc.Person
// from dep in dc.Department
// from sb in dc.Swbase
// from s in dc.Swscore
// where sw.Swpersonid == per.Personnumber && per.Areadeptid == dep.Deptnumber && sw.Swid == sb.Swid && sb.Levelid == s.Levelid
// && sw.Pctime >= DateTime.Parse(System.DateTime.Today.Year + "-01-01") && sw.Pctime <= DateTime.Parse(System.DateTime.Today.Year + "-12-31")
// && sw.Maindeptid == deptnumber && sw.Isend == 1
// select new
// {
// per.Personnumber,
// per.Name,
// dep.Deptnumber,
// dep.Deptname,
// s.Kcscore
// }).ToList();
//var group = from p in data
// group p by new
// {
// p.Deptname,
// p.Name
// }
// into g
// select new
// {
// g.Key.Deptname,
// g.Key.Name,
// Score = g.Sum(p => p.Kcscore),
// Count = g.Count()
// };
//return group.Count(p => p.Score >= 12 || p.Count >= 2);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Ext.IsAjaxRequest)
{
StoreLoad();
DeptStore.DataSource = PublicCode.GetKQdept(SessionBox.GetUserSession().DeptNumber);
DeptStore.DataBind();
//获取三违预警设置
//hdnScore.SetValue(PublicCode.GetSWMaxScoreSet(SessionBox.GetUserSession().DeptNumber));
hdnScore.Value = PublicCode.GetSWMaxScoreSet(SessionBox.GetUserSession().DeptNumber).ToString();
hdnCount.Value = PublicCode.GetSWMaxCountSet(SessionBox.GetUserSession().DeptNumber).ToString();
}
}
//下面的可以优化
private void AddYhMorePerson(decimal Yhid, string[] person)
{
//var ymall = dc.NyhinputMore.Where(p => p.Yhputinid == Yhid && !person.Contains(p.Personid));//所有不在人员列表的数据
//dc.NyhinputMore.DeleteAllOnSubmit(ymall);
//dc.SubmitChanges();
string msg = "";
foreach (string per in person)
{
//decimal rjid = PublicCode.GetKQrecord(per, dfPCtime.SelectedDate, cbbBc.SelectedItem.Value, SessionBox.GetUserSession().PersonNumber);
//if (rjid == -1)
//{
// msg += dc.Person.First(p => p.Personnumber == per).Name + ":为检测到一小时内出井记录!;";
//}
//else
//{
if (dc.NyhinputMore.Where(p => p.Yhputinid == Yhid && p.Personid == per).Count() == 0)
{
DBSCMDataContext db = new DBSCMDataContext();
NyhinputMore ym = new NyhinputMore
{//修正多人排查不同享检查信息
Personid = per,
Yhputinid = Yhid,
//--------------------------------
Pctime = dfPCtime.SelectedDate,
Banci = cbbBc.SelectedItem.Value,
Jctype = cbbJctype.SelectedIndex,
Remarks = TextArea1.Text.Trim() //,
//Rjid=rjid
//--------------------------------
};
db.NyhinputMore.InsertOnSubmit(ym);
db.SubmitChanges();
//msg += dc.Person.First(p => p.Personnumber == per).Name + ":添加成功!;";
//更新入井信息
//var rj = dc.KqRecord.First(p => p.Rjid == rjid);
//rj.Inputyhcount = rj.Inputyhcount == null ? 1 : (rj.Inputyhcount.Value + 1);
//rj.Status = 1;
//dc.SubmitChanges();
//更新走动计划
PublicCode.setUpdateMoveState(per, Convert.ToDateTime(dfPCtime.Value), decimal.Parse(cbbplace.SelectedItem.Value.Trim()));
}
else
{
msg += dc.Person.First(p => p.Personnumber == per).Name + ":已添加过的人员!;";
}
//}
}
//WriteYHlog(Yhid, msg);
//return msg;
}
private void BaseLoad()
{
UnitStore.DataSource = PublicCode.GetMaindept("");
UnitStore.DataBind();
if (SessionBox.GetUserSession().rolelevel.Trim().IndexOf("1") > -1)
{
cbbUnit.SelectedItem.Value = "241700000";
cbbUnit.Disabled = false;
}
else
{
cbbUnit.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber;
cbbUnit.Disabled = true;
}
}
private void SearchLoad()//查询窗口初始化
{
//初始化日期
df_begin.SelectedDate = System.DateTime.Today.AddDays(-2);
df_end.SelectedDate = System.DateTime.Today;
#region 初始化部门
var dep = from d in dc.Department
from p in dc.Person
where d.Deptnumber == p.Areadeptid && p.Maindeptid == SessionBox.GetUserSession().DeptNumber
select new
{
DeptName = d.Deptname,
DeptID = d.Deptnumber
};
DeptStore.DataSource = dep;
DeptStore.DataBind();
#endregion
#region 初始化单位
if (SessionBox.GetUserSession().rolelevel.Trim().IndexOf("1") > -1)
{
UnitStore.DataSource = PublicCode.GetMaindept("");
UnitStore.DataBind();
cbbUnit.Disabled = false;
cbb_part.Disabled = true;
}
else
{
var dept = from d in dc.Department
where d.Deptnumber == SessionBox.GetUserSession().DeptNumber
select new
{
d.Deptname,
d.Deptnumber
};
UnitStore.DataSource = dept;
UnitStore.DataBind();
cbbUnit.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber;
cbbUnit.Disabled = true;
}
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Ext.IsAjaxRequest)
{
baseset();
//Gridload();
Hidden1.Value = "-1";
btnEdit.Disabled = true;
btnDelete.Disabled = true;
//绑定排查人
pcPersonLoad();
//高级查询
BindStore(int.Parse(PublicMethod.ReadXmlReturnNode("ZY", this)), TypeStore);
BindStore(int.Parse(PublicMethod.ReadXmlReturnNode("FXLX", this)), FXStore);
bindGLDX(PublicMethod.ReadXmlReturnNode("REN", this) + "," + PublicMethod.ReadXmlReturnNode("GUAN", this), GLRYStore);
cbbBc.SelectedItem.Value = PublicCode.GetBanci(DateTime.Now);
}
}
private void BaseSet()
{
var dept = PublicCode.GetKQdept(SessionBox.GetUserSession().DeptNumber);
DeptStore.DataSource = dept;
DeptStore.DataBind();
var place = from pl in dc.Place
where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber
orderby pl.Placename ascending
select new
{
placID = pl.Placeid,
placName = pl.Placename
};
placeStore.DataSource = place;
placeStore.DataBind();
}
private void SearchLoad()//查询窗口初始化
{
//初始化日期
df_begin.SelectedDate = System.DateTime.Today.AddDays(-15);
df_end.SelectedDate = System.DateTime.Today;
#region 初始化部门
DeptStore.DataSource = PublicCode.GetKQdept(SessionBox.GetUserSession().DeptNumber);
DeptStore.DataBind();
#endregion
#region 初始化单位
if (SessionBox.GetUserSession().rolelevel.Trim().IndexOf("1") > -1)
{
UnitStore.DataSource = PublicCode.GetMaindept("");
UnitStore.DataBind();
cbbUnit.Disabled = false;
cbb_part.Disabled = true;
}
else
{
UnitStore.DataSource = PublicCode.GetMaindept(SessionBox.GetUserSession().DeptNumber);
UnitStore.DataBind();
cbbUnit.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber;
cbbUnit.Disabled = true;
}
#endregion
//三违级别
var lavel = from c in dc.CsBaseinfoset
where c.Fid == int.Parse(PublicMethod.ReadXmlReturnNode("SWJB", this))
select new
{
SWLevelID = c.Infoid,
SWLevel = c.Infoname
};
LevelStore.DataSource = lavel;
LevelStore.DataBind();
}
//下面的可以优化
private void AddYhMorePerson(decimal Yhid, string[] person)
{
var ymall = dc.YhinputMore.Where(p => p.Yhputinid == Yhid && !person.Contains(p.Personid));//所有不在人员列表的数据
dc.YhinputMore.DeleteAllOnSubmit(ymall);
dc.SubmitChanges();
foreach (string per in person)
{
if (dc.YhinputMore.Where(p => p.Yhputinid == Yhid && p.Personid == per).Count() == 0)
{
DBSCMDataContext db = new DBSCMDataContext();
YhinputMore ym = new YhinputMore
{
Personid = per,
Yhputinid = Yhid
};
db.YhinputMore.InsertOnSubmit(ym);
db.SubmitChanges();
//更新走动计划
PublicCode.setUpdateMoveState(per, Convert.ToDateTime(dfPCtime.Value), decimal.Parse(cbbplace.SelectedItem.Value.Trim()));
}
}
}
/// <summary>
/// 发送主机信息结果
/// </summary>
/// <param name="sender"></param>
/// <param name="code"></param>
private void sendComputerInfoResult(BaseCommunication sender, ThreeCode code)
{
try
{
PublicCode info = new PublicCode();
info.Head = CodeHead.SEND_COMPUTERINFO;
if (code.Body == "")
{
info.Msg = BD.Get_ComputerInfo();
}
else if (code.Foot != "")
{
info.Msg = BD.WMI_Searcher(code.Body, code.Foot);
}
else
{
info.Msg = BD.WMI_Searcher(code.Body);
}
sender.SendCode(info);
}
catch
{ }
}
private void BindData()//基础信息绑定
{
if (SessionBox.GetUserSession().rolelevel.Trim().IndexOf("1") > -1)
{
Store5.DataSource = PublicCode.GetMaindept("");
Store5.DataBind();
cbbDept.SelectedItem.Value = "241700000";
cbbDept.Disabled = false;
}
else
{
var dept = from d in db.Department
where d.Deptnumber == SessionBox.GetUserSession().DeptNumber
select new
{
d.Deptname,
Deptid = d.Deptnumber
};
Store5.DataSource = dept;
Store5.DataBind();
cbbDept.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber;
cbbDept.Disabled = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Ext.IsAjaxRequest)
{
#region 初始化单位
MainDeptStore.DataSource = PublicCode.GetMaindept("");
MainDeptStore.DataBind();
if (SessionBox.GetUserSession().rolelevel.Contains("1") || SessionBox.GetUserSession().rolelevel.Contains("0"))
{
cbbKQ.Disabled = true;
cbbPerson.Disabled = true;
}
else
{
cbbMianDept.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber;
cbbMianDept.Disabled = true;
KQStore.DataSource = PublicCode.GetKQdept(SessionBox.GetUserSession().DeptNumber);
KQStore.DataBind();
cbbPerson.Disabled = true;
}
#endregion
}
}
public void PYsearch(string py, string store)
{
if (py.Trim() == "")
{
return;
}
switch (store.Trim())
{
case "deptStore":
if (PublicCode.BugCreate(SessionBox.GetUserSession().DeptNumber))
{
string areadept = dc.Person.First(p => p.Personnumber == SessionBox.GetUserSession().PersonNumber).Areadeptid;
var dept = from d in dc.Department
where d.Deptnumber.Substring(0, 4) == SessionBox.GetUserSession().DeptNumber.Substring(0, 4) &&
d.Deptnumber != areadept && d.Fatherid != areadept &&
(dc.F_PINYIN(d.Deptname).ToLower().Contains(py.ToLower()) || d.Deptname.Contains(py.Trim()))
select new
{
deptID = d.Deptnumber,
deptName = d.Deptname
};
deptStore.DataSource = dept.Distinct();
deptStore.DataBind();
}
else
{
var dept = from d in dc.Department
where d.Deptnumber.Substring(0, 4) == SessionBox.GetUserSession().DeptNumber.Substring(0, 4) &&
(d.Deptnumber.Substring(7) == "00" || d.Deptlevel == "正科级") && d.Deptstatus == "1" &&
(dc.F_PINYIN(d.Deptname).ToLower().Contains(py.ToLower()) || d.Deptname.Contains(py.Trim()))
select new
{
deptID = d.Deptnumber,
deptName = d.Deptname
};
deptStore.DataSource = dept.Distinct();
deptStore.DataBind();
}
break;
case "placeStore":
if (PublicCode.BugCreate(SessionBox.GetUserSession().DeptNumber))
{
decimal areaid = (from p in dc.Person
from d in dc.Department
from a in dc.Placeareas
where p.Personnumber == SessionBox.GetUserSession().PersonNumber &&
p.Areadeptid == d.Deptnumber && d.Deptname.Replace(" ", "") == a.Pareasname
select a).First().Pareasid;
var place = from pl in dc.Place
where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber &&
pl.Pareasid != areaid && pl.Placestatus == 1 &&
(dc.F_PINYIN(pl.Placename).ToLower().Contains(py.ToLower()) || pl.Placename.Contains(py.Trim()))
select new
{
placID = pl.Placeid,
placName = pl.Placename
};
placeStore.DataSource = place;
placeStore.DataBind();
}
else
{
var place = from pl in dc.Place
where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber&& pl.Placestatus == 1 &&
(dc.F_PINYIN(pl.Placename).ToLower().Contains(py.ToLower()) || pl.Placename.Contains(py.Trim()))
select new
{
placID = pl.Placeid,
placName = pl.Placename
};
placeStore.DataSource = place;
placeStore.DataBind();
}
break;
case "yhStore": //修改多列显示
var hazard = from yh in dc.Getyhandhazusing
where yh.Deptnumber == SessionBox.GetUserSession().DeptNumber &&
(yh.Conpyfirst.ToLower().Contains(py.ToLower()) || yh.Yhcontent.Contains(py.Trim()) || yh.Yhnumber.ToLower().Contains(py.ToLower()))
select new
{
yhNumber = yh.Yhid,
yhContent = yh.Yhcontent,
Gzrwname = yh.Levelname,
Gxname = yh.Typename
};
yhStore.DataSource = hazard;
yhStore.DataBind();
break;
case "PCpersonStore":
if (cbbJctype.SelectedItem.Value == "2")
{
//局端排查人
var person = from p in dc.Person
from d in dc.Department
where p.Areadeptid == d.Deptnumber && p.Visualfield == 3 && p.Personstatus == 1 &&
(dc.F_PINYIN(p.Name).ToLower().Contains(py.ToLower()) || p.Name.Contains(py.Trim()))
select new
{
p.Personnumber,
p.Name,
d.Deptname
};
PCpersonStore.DataSource = person;
PCpersonStore.DataBind();
}
else
{
var person = from pl in dc.Vgetpl
from p in dc.Person
where pl.Moduletag == "HiddenDanage_HDprocess" && pl.Operatortag == "YH_fcfk" && pl.Unitid == SessionBox.GetUserSession().DeptNumber &&
(dc.F_PINYIN(pl.Name).ToLower().Contains(py.ToLower()) || pl.Name.Contains(py.Trim())) &&
pl.Personnumber == p.Personnumber && p.Personstatus == 1
select new
{
pl.Personnumber,
pl.Name
};
PCpersonStore.DataSource = person.Distinct();
PCpersonStore.DataBind();
}
break;
case "WorkTaskStore":
var gzrw = dc.Worktasks.Where(
p => p.Professionalid == decimal.Parse(cbbSbsdy.SelectedItem.Value) &&
dc.F_PINYIN(p.Worktask).ToLower().Contains(py.ToLower())
);
WorkTaskStore.DataSource = gzrw;
WorkTaskStore.DataBind();
break;
}
}
public void AddClick(string action)
{
if (cbbBc.SelectedIndex == -1 || cbbplace.SelectedIndex == -1 || cbbSWcontent.SelectedIndex == -1 || cbbPCperson.SelectedIndex == -1)
{
Ext.Msg.Alert("提示", "请填写完整信息!").Show();
return;
}
if (action == "new")
{
try
{
Nswinput sw = new Nswinput
{
Banci = cbbBc.SelectedItem.Value.Trim(),
Inputpersonid = SessionBox.GetUserSession().PersonNumber,//cbbPCperson.SelectedItem.Value,
Intime = System.DateTime.Now,
Pctime = Convert.ToDateTime(dfPCtime.Value),
Pcpersonid = cbbPCperson.SelectedItem.Value,
Placeid = int.Parse(cbbplace.SelectedItem.Value),
Swpersonid = cbbSwperson.SelectedItem.Value,
Swid = decimal.Parse(cbbSWcontent.SelectedItem.Value.Trim()),
Maindeptid = SessionBox.GetUserSession().DeptNumber,
Remarks = TextArea1.Text,
Jctype = cbbJctype.SelectedIndex
};
dc.Nswinput.Insert(sw);
dc.SubmitChanges();
Ext.Msg.Alert("提示", "保存成功!").Show();
//更新走动计划
PublicCode.setUpdateMoveState(cbbPCperson.SelectedItem.Value.Trim(), Convert.ToDateTime(dfPCtime.Value), decimal.Parse(cbbplace.SelectedItem.Value.Trim()));
Gridload();
//清空三违信息
cbbSWcontent.SelectedIndex = -1;
TextArea2.Text = "";
}
catch
{
Ext.Msg.Alert("提示", "保存失败，请稍候重试!").Show();
}
}
else
{
RowSelectionModel sm = this.GridPanel1.SelectionModel.Primary as RowSelectionModel;
if (sm.SelectedRows.Count > 0)
{
try
{
var sw = dc.Nswinput.First(p => p.Id == decimal.Parse(sm.SelectedRow.RecordID.Trim()));
sw.Banci = cbbBc.SelectedItem.Value.Trim();
sw.Pctime = Convert.ToDateTime(dfPCtime.Value);
sw.Pcpersonid = cbbPCperson.SelectedItem.Value;
sw.Placeid = int.Parse(cbbplace.SelectedItem.Value);
sw.Swpersonid = cbbSwperson.SelectedItem.Value;
sw.Swid = decimal.Parse(cbbSWcontent.SelectedItem.Value.Trim());
sw.Remarks = TextArea1.Text;
sw.Jctype = cbbJctype.SelectedIndex;
dc.SubmitChanges();
Ext.Msg.Alert("提示", "修改成功!").Show();
Gridload();
//清空三违信息
cbbSWcontent.SelectedIndex = -1;
TextArea2.Text = "";
}
catch
{
Ext.Msg.Alert("提示", "保存失败，请稍候重试!").Show();
}
}
}
}
private void BaseSet()
{
HBBLL hb = new HBBLL();
var data = hb.GetLeaderRole(SessionBox.GetUserSession().DeptNumber, 431);
var q = from p in data
select new
{
Personnumber = p.personnumber,
Name = p.name
};
perStore.DataSource = q;
perStore.DataBind();
if (SessionBox.GetUserSession().Role.Contains("11,矿级管理员"))
{
//cbbPerson.SelectedItem.Value = SessionBox.GetUserSession().PersonNumber;
if (SessionBox.GetUserSession().Role.Contains("431,副总及以上领导"))
{
cbbPerson.SelectedItem.Value = SessionBox.GetUserSession().PersonNumber;
cbbPerson.Disabled = false;
}
else
{
cbbPerson.SelectedIndex = 0;
}
}
else
{
cbbPerson.Items.Add(new Coolite.Ext.Web.ListItem(SessionBox.GetUserSession().Name, SessionBox.GetUserSession().PersonNumber));
cbbPerson.SelectedItem.Value = SessionBox.GetUserSession().PersonNumber;
cbbPerson.Disabled = true;
}
df_begin.MinDate = System.DateTime.Today;
df_begin.SelectedDate = df_begin.MinDate;
//cx_date.SelectedDate = System.DateTime.Today;
//var q = from p in dc.Person
// where p.Personnumber==SessionBox.GetUserSession().PersonNumber
// select new
// {
// p.Personnumber,
// p.Name
// };
//perStore.DataSource = q;
//perStore.DataBind();
DeptStore.DataSource = PublicCode.GetMaindept("");
DeptStore.DataBind();
if (SessionBox.GetUserSession().rolelevel.Contains("1") || SessionBox.GetUserSession().rolelevel.Contains("0"))
{
cbbDept.Items.Insert(0, new Coolite.Ext.Web.ListItem("--全部--", "-1"));
cbbDept.SelectedItem.Value = "-1";
cbbDept.Disabled = false;
}
else
{
cbbDept.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber;
cbbDept.Disabled = true;
}
//HBBLL hb = new HBBLL();
//var data2 = hb.GetYPPT(SessionBox.GetUserSession().PersonNumber, SessionBox.GetUserSession().DeptNumber, "个人");
//var pt = from r in data2
// select new
// {
// Id = r.Id,
// Name = r.Name,
// Level = r.TLevel
// };
//placeTemplateStore.DataSource = pt;
//placeTemplateStore.DataBind();
//cboPlaceTemplate.Items.Insert(0, new Coolite.Ext.Web.ListItem("--不使用模板--", "-1"));
cx_date.SelectedValue = DateTime.Today;
}
public void PYsearch(string py, string store)
{
if (py.Trim() == "")
{
return;
}
switch (store.Trim())
{
case "personStore":
if (PublicCode.BugCreate(SessionBox.GetUserSession().DeptNumber))
{
string areadept = dc.Person.First(p => p.Personnumber == SessionBox.GetUserSession().PersonNumber).Areadeptid;
var person = from r in dc.Person
from d in dc.Department
where r.Deptid == d.Deptnumber && r.Maindeptid == SessionBox.GetUserSession().DeptNumber &&
r.Areadeptid != areadept && r.Personstatus == 1 &&
(r.Pinyin.ToLower().Contains(py.ToLower()) || r.Lightnumber.ToLower().Contains(py.ToLower()) || r.Name.Contains(py.Trim()))
select new
{
pernID = r.Personid,
pernName = r.Name,
pernLightNumber = r.Lightnumber,
persNnmber = r.Personnumber,
DeptName = d.Deptname
};
personStore.DataSource = person;
personStore.DataBind();
}
else
{
var person = from r in dc.Person
from d in dc.Department
where r.Deptid == d.Deptnumber && r.Maindeptid == SessionBox.GetUserSession().DeptNumber&& r.Personstatus == 1 &&
(r.Pinyin.ToLower().Contains(py.ToLower()) || r.Lightnumber.ToLower().Contains(py.ToLower()) || r.Name.Contains(py.Trim()))
select new
{
pernID = r.Personid,
pernName = r.Name,
pernLightNumber = r.Lightnumber,
persNnmber = r.Personnumber,
DeptName = d.Deptname
};
personStore.DataSource = person;
personStore.DataBind();
}
break;
case "placeStore":
if (PublicCode.BugCreate(SessionBox.GetUserSession().DeptNumber))
{
decimal areaid = (from p in dc.Person
from d in dc.Department
from a in dc.Placeareas
where p.Personnumber == SessionBox.GetUserSession().PersonNumber &&
p.Areadeptid == d.Deptnumber && d.Deptname.Replace(" ", "") == a.Pareasname
select a).First().Pareasid;
var place = from pl in dc.Place
where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber &&
pl.Pareasid != areaid &&
(dc.F_PINYIN(pl.Placename).ToLower().Contains(py.ToLower()) || pl.Placename.Contains(py.Trim()))
select new
{
placID = pl.Placeid,
placName = pl.Placename
};
placeStore.DataSource = place;
placeStore.DataBind();
}
else
{
var place = from pl in dc.Place
where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber&& pl.Placestatus == 1 &&
(dc.F_PINYIN(pl.Placename).ToLower().Contains(py.ToLower()) || pl.Placename.Contains(py.Trim()))
select new
{
placID = pl.Placeid,
placName = pl.Placename
};
placeStore.DataSource = place;
placeStore.DataBind();
}
break;
case "yhStore":
var hazard = from yh in dc.Getswandhazusing
where yh.Deptnumber == SessionBox.GetUserSession().DeptNumber &&
(yh.Conpyfirst.ToLower().Contains(py.ToLower()) || yh.Swcontent.Contains(py.Trim()) || yh.Swnumber.ToLower().Contains(py.ToLower()))
select new
{
yhNumber = yh.Swid,
yhContent = yh.Swcontent,
Gzrwname = yh.Levelname,
Gxname = yh.Typename
};
yhStore.DataSource = hazard;
yhStore.DataBind();
break;
case "PCpersonStore":
var person1 = from pl in dc.Vgetpl
from p in dc.Person
where pl.Moduletag == "HiddenDanage_HDprocess" && pl.Operatortag == "YH_fcfk" && pl.Unitid == SessionBox.GetUserSession().DeptNumber &&
(dc.F_PINYIN(pl.Name).ToLower().Contains(py.ToLower()) || pl.Name.Contains(py.Trim())) &&
pl.Personnumber == p.Personnumber && p.Personstatus == 1
select new
{
pl.Personnumber,
pl.Name
};
PCpersonStore.DataSource = person1.Distinct();
PCpersonStore.DataBind();
break;
case "WorkTaskStore":
var gzrw = dc.Worktasks.Where(
p => p.Professionalid == decimal.Parse(cbbSbsdy.SelectedItem.Value) &&
dc.F_PINYIN(p.Worktask).ToLower().Contains(py.ToLower())
);
WorkTaskStore.DataSource = gzrw;
WorkTaskStore.DataBind();
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Ext.IsAjaxRequest)
{
UserHandle.InitModule(this.PageTag); //初始化此模块的权限。
if (UserHandle.ValidationHandle(PermissionTag.Browse)) //是否有浏览权限
{
dfBegin.SelectedDate = System.DateTime.Today.AddDays(1 - System.DateTime.Today.Day);
dfEnd.SelectedDate = System.DateTime.Today;
//dfBegin.MaxDate = System.DateTime.Today;
//dfEnd.MaxDate = System.DateTime.Today;
#region 初始化单位
MainDeptStore.DataSource = PublicCode.GetMaindept("");
MainDeptStore.DataBind();
KQStore.DataSource = PublicCode.GetKQdept(SessionBox.GetUserSession().DeptNumber);
KQStore.DataBind();
if (SessionBox.GetUserSession().rolelevel.Contains("1") || SessionBox.GetUserSession().rolelevel.Contains("0"))
{
cbbKQ.Disabled = true;
}
else
{
cbbMianDept.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber;
cbbMianDept.Disabled = true;
}
#endregion
//LoadData();
if (UserHandle.ValidationHandle(PermissionTag.SearchAll))
{
cbbMianDept.Disabled = false;
cbbKQ.Disabled = false;
btnSearch.Disabled = false;
}
else if (UserHandle.ValidationHandle(PermissionTag.SearchMainDept))
{
cbbMianDept.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber;
cbbMianDept.Disabled = true;
cbbKQ.Disabled = false;
btnSearch.Disabled = false;
}
else if (UserHandle.ValidationHandle(PermissionTag.SearchDept))
{
cbbMianDept.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber;
cbbMianDept.Disabled = true;
cbbKQ.SelectedItem.Value = PublicCode.GetKQdeptNumber(SessionBox.GetUserSession().PersonNumber);
cbbKQ.Disabled = true;
btnSearch.Disabled = false;
}
else if (UserHandle.ValidationHandle(PermissionTag.SearchPersonal))
{
cbbMianDept.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber;
cbbMianDept.Disabled = true;
cbbKQ.SelectedItem.Value = PublicCode.GetKQdeptNumber(SessionBox.GetUserSession().PersonNumber);
cbbKQ.Disabled = true;
btnSearch.Disabled = false;
}
else
{
btnSearch.Disabled = true;
}
}
else
{
Session["ErrorNum"] = "0";
Response.Redirect("~/Error.aspx");
}
}
}
