private void SearchLoad()//查询窗口初始化
{
DBSCMDataContext dc = new DBSCMDataContext();
//初始化地点
var dep = from d in dc.Place
where d.Maindeptid == SessionBox.GetUserSession().DeptNumber
select new
{
PlaceName = d.Placename,
PlaceID = d.Placeid
};
Store4.DataSource = dep;
Store4.DataBind();
//初始化人员职务
//需要添加权限判断-判断是否为走动干部进入
var pos = from p in dc.Position
from per in dc.Person
where p.Posid == per.Posid && p.Maindeptid == per.Maindeptid && per.Maindeptid == SessionBox.GetUserSession().DeptNumber
select new
{
PosID = p.Posid,
PosName = p.Posname
};
PosStore.DataSource = pos;
PosStore.DataBind();
}
public void PYchange(string py, string store)
{
string oracletext = "select * from M_OBJECT where RISK_TYPESID = 8 and MO_F_PINYIN like '%" + py.ToUpper() + "%'";
switch (store)
{
case "Store1":
string oracletext1 = "select * from M_OBJECT where RISK_TYPESID = " + extRISK_TYPESNUMBER.SelectedItem.Value.Trim() + " and MO_F_PINYIN like '%" + py.ToUpper() + "%'";
Store1.DataSource = OracleHelper.Query(oracletext1);
Store1.DataBind();
break;
case "Store2":
Store2.DataSource = OracleHelper.Query(oracletext);
Store2.DataBind();
break;
case "Store3":
Store3.DataSource = OracleHelper.Query(oracletext);
Store3.DataBind();
break;
case "Store4":
Store4.DataSource = OracleHelper.Query(oracletext);
Store4.DataBind();
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
loginService.HaveUrlRight();
if (!X.IsAjaxRequest)
{
if (!Page.IsPostBack)
{
Store1.DataSource = AvailableSofts;
Store1.DataBind();
comboxSofts.SelectedIndex = 0;
var platList = AvailableSofts[0].Platforms.Where(a => a != MobileOption.IPAD && a != MobileOption.AndroidPad).Select(p => new { PlatID = (int)p, PlatName = p.GetDescription() }).ToList();
Store2.DataSource = platList;
Store2.DataBind();
comboxSofts.SelectedItem.Value = AvailableSofts[0].ID.ToString();
comboxPlats.SelectedItem.Value = platList[0].PlatID.ToString();
isSearch.Text = "1";
//添加版本增加的代码
Store4.DataSource = AvailableSofts;
Store4.DataBind();
add_comboxSofts.SelectedIndex = 0;
Store5.DataSource = platList;
Store5.DataBind();
add_comboxSofts.SelectedItem.Value = AvailableSofts[0].ID.ToString();
add_comboxPlats.SelectedItem.Value = platList[0].PlatID.ToString();
}
}
}
private void data_Bind()
{
//项目数据
var projectList = XMProjectService.GetXMProjectList();
Store2.DataSource = projectList;
Store2.DataBind();
//发货点数据(发货仓)
var codeList = CodeService.GetCodeListInfoByCodeTypeID(227);
Store3.DataSource = codeList;
Store3.DataBind();
//省份数据
var provinceList = AreaCodeService.GetAreaCodeByRank(2);
Store4.DataSource = provinceList;
Store4.DataBind();
//物流公司数据
var logisticsList = CodeService.GetCodeListInfoByCodeTypeID(243);
Store7.DataSource = logisticsList;
Store7.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();
}
}
public void FillWorkingCalendarStore()
{
ListRequest req = new ListRequest();
ListResponse <WorkingCalendar> response = _timeAttendanceService.ChildGetAll <WorkingCalendar>(req);
if (!response.Success)
{
Common.errorMessage(response);
departmentStore.DataSource = new List <Department>();
}
Store4.DataSource = response.Items;
Store4.DataBind();
}
protected void MyData_Refresh(object sender, StoreRefreshDataEventArgs e)
{
Store4.DataSource = biService.GetProjectSources().Select(p => new SimpleProjectource()
{
ProjectSourceID = p.ProjectSourceID,
AddTime = p.AddTime,
Name = p.Name,
OnlyInternal = p.OnlyInternal,
ProjectSourceType = p.ProjectSourceType.ToString(),
SortIndex = p.SortIndex,
Status = ((int)p.Status) > 0?true:false,
SoftID = p.SoftID
}).ToList();
Store4.DataBind();
}
//绑定中层领导姓名
private void bindName_Z(string maindept)
{
//string text = "<ul>";
var query = (from a in db.Person
from b in db.Position
from c in db.Moveplan
where a.Posid == b.Posid && a.Personnumber == c.Personid && b.Movegblevel.Trim() == "中层领导" &&
b.Maindeptid == maindept
select new
{
a.Name,
PersonID = a.Personnumber
}).Distinct();
Store4.DataSource = query;
Store4.DataBind();
}
private void dataBind()
{
//项目数据
var projectList = XMProjectService.GetXMProjectList();
Store2.DataSource = projectList;
Store2.DataBind();
//物流公司数据
var logisticsList = CodeService.GetCodeListInfoByCodeTypeID(244);
Store3.DataSource = logisticsList;
Store3.DataBind();
//发货点数据(发货仓)
var codeList = CodeService.GetCodeListInfoByCodeTypeID(188);
Store4.DataSource = codeList;
Store4.DataBind();
}
private void PreviewDataBind()
{
DataTable dt = new DataTable();
dt.Columns.Add("PSName");
dt.Columns.Add("rjs1");
dt.Columns.Add("rjs2");
dt.Columns.Add("rjs3");
dt.Columns.Add("rjs4");
dt.Columns.Add("rjs5");
dt.Columns.Add("rjs6");
dt.Columns.Add("rjs7");
for (int i = 0; i < 5; i++)
{
dt.Rows.Add();
dt.Rows[i]["PSName"] = "";
dt.Rows[i]["rjs1"] = "";
dt.Rows[i]["rjs2"] = "";
dt.Rows[i]["rjs3"] = "";
dt.Rows[i]["rjs4"] = "";
dt.Rows[i]["rjs5"] = "";
dt.Rows[i]["rjs6"] = "";
dt.Rows[i]["rjs7"] = "";
}
Store1.DataSource = dt;
Store1.DataBind();
DataTable dt2 = new DataTable();
dt2.Columns.Add("PSName");
dt2.Columns.Add("rjs1");
dt2.Columns.Add("rjs2");
dt2.Columns.Add("rjs3");
dt2.Columns.Add("rjs4");
dt2.Columns.Add("rjs5");
dt2.Columns.Add("rjs6");
dt2.Columns.Add("rjs7");
dt2.Columns.Add("rjs8");
dt2.Columns.Add("rjs9");
for (int i = 0; i < 5; i++)
{
dt2.Rows.Add();
dt2.Rows[i]["PSName"] = "";
dt2.Rows[i]["rjs1"] = "";
dt2.Rows[i]["rjs2"] = "";
dt2.Rows[i]["rjs3"] = "";
dt2.Rows[i]["rjs4"] = "";
dt2.Rows[i]["rjs5"] = "";
dt2.Rows[i]["rjs6"] = "";
dt2.Rows[i]["rjs7"] = "";
dt2.Rows[i]["rjs8"] = "";
dt2.Rows[i]["rjs9"] = "";
}
Store2.DataSource = dt2;
Store2.DataBind();
DataTable dt3 = new DataTable();
dt3.Columns.Add("PSName");
dt3.Columns.Add("rjs1");
dt3.Columns.Add("rjs2");
dt3.Columns.Add("rjs3");
dt3.Columns.Add("rjs4");
dt3.Columns.Add("rjs5");
dt3.Columns.Add("rjs6");
dt3.Columns.Add("rjs7");
dt3.Columns.Add("rjs8");
dt3.Columns.Add("rjs9");
dt3.Columns.Add("rjs10");
dt3.Columns.Add("rjs11");
dt3.Columns.Add("rjs12");
dt3.Columns.Add("rjs13");
dt3.Columns.Add("rjs14");
for (int i = 0; i < 5; i++)
{
dt3.Rows.Add();
dt3.Rows[i]["PSName"] = "";
dt3.Rows[i]["rjs1"] = "";
dt3.Rows[i]["rjs2"] = "";
dt3.Rows[i]["rjs3"] = "";
dt3.Rows[i]["rjs4"] = "";
dt3.Rows[i]["rjs5"] = "";
dt3.Rows[i]["rjs6"] = "";
dt3.Rows[i]["rjs7"] = "";
dt3.Rows[i]["rjs8"] = "";
dt3.Rows[i]["rjs9"] = "";
dt3.Rows[i]["rjs10"] = "";
dt3.Rows[i]["rjs11"] = "";
dt3.Rows[i]["rjs12"] = "";
dt3.Rows[i]["rjs13"] = "";
dt3.Rows[i]["rjs14"] = "";
}
Store3.DataSource = dt3;
Store3.DataBind();
DataTable dt4 = BG_PayProjectManager.GetAllBG_PayProject();
dt4.Columns.Add("rjs1");
dt4.Columns.Add("rjs2");
dt4.Columns.Add("rjs3");
dt4.Columns.Add("rjs4");
dt4.Columns.Add("rjs5");
dt4.Columns.Add("rjs6");
dt4.Columns.Add("rjs7");
dt4.Columns.Add("rjs8");
dt4.Columns.Add("rjs9");
dt4.Columns.Add("rjs10");
dt4.Columns.Add("rjs11");
dt4.Columns.Add("rjs12");
dt4.Columns.Add("rjs13");
for (int i = 0; i < 5; i++)
{
dt4.Rows[i]["rjs1"] = "0";
dt4.Rows[i]["rjs2"] = "0";
dt4.Rows[i]["rjs3"] = "0";
dt4.Rows[i]["rjs4"] = "0";
dt4.Rows[i]["rjs5"] = "0";
dt4.Rows[i]["rjs6"] = "0";
dt4.Rows[i]["rjs7"] = "0";
dt4.Rows[i]["rjs8"] = "0";
dt4.Rows[i]["rjs9"] = "0";
dt4.Rows[i]["rjs10"] = "0";
dt4.Rows[i]["rjs11"] = "0";
dt4.Rows[i]["rjs12"] = "0";
dt4.Rows[i]["rjs13"] = "0";
}
Store4.DataSource = dt4;
Store4.DataBind();
}
