private void InitDept()
{
HBBLL hb = new HBBLL();
var dept = hb.GetVPDept();
var data = from d in dept
select new
{
Deptnumber = d.DeptNumber,
Deptname = d.DeptName
};
DeptStore.DataSource = data;
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;
}
}
private void SearchLoad()//查询窗口初始化 已改
{
//DBSCMDataContext dc = new DBSCMDataContext();
//初始化日期
//df_begin.SelectedDate = System.DateTime.Today.AddDays(-6);
//df_end.SelectedDate = System.DateTime.Today;
//初始化部门
var dept = from d in dc.Department
where d.Deptnumber.Substring(0, 4) == SessionBox.GetUserSession().DeptNumber.Substring(0, 4) &&
d.Deptnumber.Substring(7) == "00"
orderby d.Deptname
select new
{
d.Deptnumber,
d.Deptname
};
DeptStore.DataSource = dept;
DeptStore.DataBind();
//初始化级别
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 BaseSet()
{
var dept = from d in dc.Department
where d.Deptnumber.Substring(0, 4) == SessionBox.GetUserSession().DeptNumber.Substring(0, 4) &&
d.Deptlevel == "正科级"
orderby d.Deptname
select new
{
d.Deptnumber,
d.Deptname
};
if (dept.Count() > 0)
{
DeptStore.DataSource = dept;
DeptStore.DataBind();
}
else
{
var de = from d in dc.Department
where d.Deptnumber.Substring(4) == "00000"
select new
{
d.Deptnumber,
d.Deptname
};
DeptStore.DataSource = de;
DeptStore.DataBind();
}
dfDate.SelectedDate = System.DateTime.Today;
}
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 BaseBind()
{
var dept = from d in db.Department
where d.Deptnumber.Substring(0, 4) == SessionBox.GetUserSession().DeptNumber.Substring(0, 4) &&
d.Deptlevel == "正科级"
orderby d.Deptname
select new
{
d.Deptnumber,
d.Deptname
};
DeptStore.DataSource = dept;
DeptStore.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Ext.IsAjaxRequest)
{
StoreLoad();
var dept = from d in dc.Department
where d.Deptnumber.Substring(0, 4) == SessionBox.GetUserSession().DeptNumber.Substring(0, 4) &&
d.Deptlevel == "正科级"
orderby d.Deptname
select new
{
d.Deptnumber,
d.Deptname
};
DeptStore.DataSource = dept;
DeptStore.DataBind();
}
}
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
}
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();
}
public void PYsearch(string py, string store)
{
if (py.Trim() == "")
{
return;
}
switch (store.Trim())
{
case "DeptStore":
var dept = from d in dc.Department
where (d.Deptnumber.Substring(0, 2) == "13" || d.Deptnumber.Substring(0, 4) == "2364") && //1303为集团公司处级，2364为设备管理中心
(d.Deptnumber.Substring(7) == "00" || d.Deptlevel == "正科级") &&
(d.Visualfield != 3 || d.Visualfield == null) &&
(dc.F_PINYIN(d.Deptname).ToLower().Contains(py.ToLower()) || d.Deptname.Contains(py.Trim()))
select new
{
d.Deptnumber,
d.Deptname
};
DeptStore.DataSource = dept.Distinct();
DeptStore.DataBind();
break;
case "personStore":
var person = from pl in dc.Person
where (pl.Areadeptid == hdnKindid.Value.ToString() || pl.Maindeptid == hdnKindid.Value.ToString()) &&
(pl.Visualfield != 3 || pl.Visualfield == null) &&
(dc.F_PINYIN(pl.Name).ToLower().Contains(py.ToLower()) || pl.Name.Contains(py.Trim()))
select new
{
pl.Personnumber,
pl.Name
};
personStore.DataSource = person.Distinct();
personStore.DataBind();
break;
}
}
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 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;
}
private void SearchLoad()//查询窗口初始化
{
//初始化日期
df_begin.SelectedDate = System.DateTime.Today;
df_end.SelectedDate = System.DateTime.Today;
//df_begin.SelectedDate = System.DateTime.Today;//.AddDays(-1);
//df_end.SelectedDate = System.DateTime.Today;
#region 初始化职务
var pos = from p in dc.Position
from per in dc.Person
where p.Posid == per.Posid && per.Maindeptid == SessionBox.GetUserSession().DeptNumber
select new
{
p.Posid,
p.Posname
};
Store3.DataSource = pos;
Store3.DataBind();
#endregion
#region 初始化部门
//var dep = from d in dc.Department
// where d.Fatherid == SessionBox.GetUserSession().DeptNumber
// select new
// {
// d.Deptname,
// Deptid = d.Deptnumber
// };
//DeptStore.DataSource = dep;
//DeptStore.DataBind();
var dep = from d in dc.Department
from p in dc.Person
where d.Deptnumber == p.Areadeptid && p.Maindeptid == SessionBox.GetUserSession().DeptNumber
select new
{
d.Deptname,
Deptid = d.Deptnumber
};
DeptStore.DataSource = dep;
DeptStore.DataBind();
#endregion
#region 初始化单位
if (SessionBox.GetUserSession().rolelevel.Trim().IndexOf("1") > -1)
{
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 = dept;
UnitStore.DataBind();
cbbUnit.Disabled = false;
cbb_position.Disabled = true;
cbb_person.Disabled = true;
cbb_part.Disabled = true;
cbb_status.Disabled = true;
}
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
//#region 初始化级别
//var lavel = from l in dc.Yinhuanlevel
// select new
// {
// l.YHLevelID,
// l.YHLevel
// };
//LevelStore.DataSource = lavel;
//LevelStore.DataBind();
//#endregion
#region 初始化类型
int zyID = int.Parse(PublicMethod.ReadXmlReturnNode("ZY", this));
var type = from t in dc.CsBaseinfoset
where t.Fid == zyID
select new
{
YHTypeID = t.Infoid,
YHType = t.Infoname
};
TypeStore.DataSource = type;
TypeStore.DataBind();
#endregion
#region 初始化状态
StatusStore.DataBind();
#endregion
}
