//绑定待复查隐患
private void bindYH()
{
//绑定隐患录入信息
var query = from yh in dc.Nyhinput
from yu in dc.Getyhandhazusing
from d in dc.Department
from pl in dc.Place
from p in dc.Person
where yh.Yhid == yu.Yhid && yh.Deptid == d.Deptnumber && yh.Placeid == pl.Placeid && yu.Deptnumber == SessionBox.GetUserSession().DeptNumber &&
yh.Status == "隐患已整改" && yh.Placeid == int.Parse(cbbplace.SelectedItem.Value.Trim()) && yh.Personid == p.Personnumber
orderby yh.Intime descending
select new
{
YHPutinID = yh.Yhputinid,
DeptName = d.Deptname,
PlaceName = pl.Placename,
YHContent = yu.Yhcontent,
Remarks = yh.Remarks,
BanCi = yh.Banci,
PCTime = yh.Pctime,
YHType = yu.Typename,
Status = yh.Status,
YHLevel = yu.Levelname,
INTime = yh.Intime,
Name = p.Name
};
Store6.DataSource = query;
Store6.DataBind();
}
//绑定待复查隐患
private void bindYH()
{
//绑定隐患录入信息
var query = from yh in dc.Yhview
where yh.Status == "隐患已整改" && yh.Placeid == int.Parse(cbbplace.SelectedItem.Value.Trim())
orderby yh.Intime descending
select new
{
YHPutinID = yh.Yhputinid,
DeptName = yh.Deptname,
PlaceName = yh.Placename,
YHContent = yh.HBm,
Remarks = yh.Remarks,
BanCi = yh.Banci,
PCTime = yh.Pctime,
YHType = yh.Zyname,
Status = yh.Status,
YHLevel = yh.Levelname,
INTime = yh.Intime,
Name = yh.Personname
};
Store6.DataSource = query;
Store6.DataBind();
}
protected void documentsStore_ReadData(object sender, StoreReadDataEventArgs e)
{
//GEtting the filter from the page
string filter = string.Empty;
int totalCount = 1;
//Fetching the corresponding list
//in this test will take a list of News
DocumentListRequest request = new DocumentListRequest();
request.Status = 0;
request.Filter = "";
ListResponse <AdminDocument> routers = _administrationService.ChildGetAll <AdminDocument>(request);
if (!routers.Success)
{
Common.errorMessage(routers);
return;
}
if (!string.IsNullOrEmpty(DeptId1.Text))
{
Store1.DataSource = routers.Items.Where(x => x.departmentId == DeptId1.Text);
Store1.DataBind();
}
if (!string.IsNullOrEmpty(DeptId2.Text))
{
Store2.DataSource = routers.Items.Where(x => x.departmentId == DeptId2.Text);
Store2.DataBind();
}
if (!string.IsNullOrEmpty(DeptId3.Text))
{
Store3.DataSource = routers.Items.Where(x => x.departmentId == DeptId3.Text);
Store3.DataBind();
}
if (!string.IsNullOrEmpty(DeptId4.Text))
{
Store3.DataSource = routers.Items.Where(x => x.departmentId == DeptId4.Text);
Store4.DataBind();
}
if (!string.IsNullOrEmpty(DeptId5.Text))
{
Store5.DataSource = routers.Items.Where(x => x.departmentId == DeptId5.Text);
Store5.DataBind();
}
if (!string.IsNullOrEmpty(DeptId6.Text))
{
Store6.DataSource = routers.Items.Where(x => x.departmentId == DeptId6.Text);
Store6.DataBind();
}
}
protected void city_Select(object sender, DirectEventArgs e)
{
string city = cbCity.Text;
string province = cbProvince.Text;
//地区数据
var areaList = AreaCodeService.GetAreaCodeByCity(4, province + "/" + city);
Store6.DataSource = areaList;
Store6.DataBind();
cbArea.Clear();
}