public void PYsearch(string py, string store)
{
HBBLL hb = new HBBLL();
switch (store.Trim())
{
//case "perStore":
// var data = hb.GetLeaderRole(py, SessionBox.GetUserSession().DeptNumber, 431);
// var q = from p in data
// select new
// {
// Personnumber = p.personnumber,
// Name = p.name
// };
// perStore.DataSource = q;
// perStore.DataBind();
// break;
case "placeStore":
var place = from pl in dc.Place
where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber&& pl.Placestatus == 1 &&
(dc.F_PINYIN(pl.Placename) + pl.Placename).ToLower().Contains(py.ToLower())
select new
{
pl.Placeid,
pl.Placename
};
placeStore.DataSource = place;
placeStore.DataBind();
break;
}
}
private void UpdateStatus()
{
RowSelectionModel sm = this.GridPanel1.SelectionModel.Primary as RowSelectionModel;
if (sm.SelectedRows.Count > 0)
{
HBBLL hb = new HBBLL();
YPPT data = hb.GetYPPTByID(int.Parse(sm.SelectedRows[0].RecordID));
if (data.CreatePersonNumber == SessionBox.GetUserSession().PersonNumber)
{
btnDel.Disabled = false;
btnDetail.Disabled = false;
btnPlan.Disabled = false;
}
else
{
btnPlan.Disabled = true;
btnDetail.Disabled = false;
btnDel.Disabled = true;
}
}
else
{
btnPlan.Disabled = true;
btnDetail.Disabled = true;
btnDel.Disabled = true;
}
}
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;
}
}
protected void YHputinStore_RefershData(object sender, StoreRefreshDataEventArgs e)
{
int PageSize = this.pagecut.PageSize; //获取当前在页面中PagingToolBar 的PageSize的值
int Count = 0;
int CurPage = e.Start / PageSize + 1; //获取当前的页码是多少，也就是第几页
HBBLL hb = new HBBLL();
//绑定隐患录入信息
var data2 = hb.GetYHInput2(SessionBox.GetUserSession().PersonNumber, SessionBox.GetUserSession().DeptNumber, ref Count);
var data = from yh in data2
orderby yh.INTime descending
select new
{
YHPutinID = yh.YHPutinID,
DeptName = yh.DeptName,
PlaceName = yh.PlaceName,
YHContent = yh.YHContent,
Remarks = yh.Remarks,
BanCi = yh.BanCi,
Name = yh.Name,
INTime = yh.INTime,
PCTime = yh.PCTime,
YHType = yh.TypeName,
Status = yh.Status
};
e.TotalCount = Count;
if (e.TotalCount > 0)
{
this.YHputinStore.DataSource = data.Skip(e.Start <= 0 ? 0 : e.Start).Take(PageSize);//绑定数据
this.YHputinStore.DataBind();
}
}
public void SuerDeleteT(string id)
{
HBBLL hb = new HBBLL();
hb.DeleteYPPT(int.Parse(id));
Ext.Msg.Alert("提示", "删除成功!").Show();
Ext.DoScript("#{placeTemplateStore}.reload();");
}
private void BindDownDetail(string mm, string personnumber)
{
HBBLL hb = new HBBLL();
var data = hb.GetDownDetail(mm, personnumber);
DownDetailStore.DataSource = data;
DownDetailStore.DataBind();
}
private void BindDBDetail(string mm, string personnumber, string banci)
{
HBBLL hb = new HBBLL();
var data = hb.GetDBDetail(mm, personnumber, banci);
DBDetailStore.DataSource = data;
DBDetailStore.DataBind();
}
protected void placeTemplateStore_RefershData(object sender, StoreRefreshDataEventArgs e)
{
HBBLL hb = new HBBLL();
var data2 = hb.GetYPPT(SessionBox.GetUserSession().PersonNumber, SessionBox.GetUserSession().DeptNumber);
this.placeTemplateStore.DataSource = data2;
this.placeTemplateStore.DataBind();
UpdateStatus();
}
public void PlaceDown()
{
RowSelectionModel sm = this.GridPanel2.SelectionModel.Primary as RowSelectionModel;
if (sm.SelectedRows.Count == 1)
{
HBBLL hb = new HBBLL();
int id = int.Parse(sm.SelectedRows[0].RecordID.Trim());
hb.MoveDown(id, hb.GetMoveOrderByID(id), int.Parse(TID.Value.ToString()));
Ext.DoScript("#{YPPTDetailStore}.reload();");
}
}
protected void YPPTDetailStore_RefershData(object sender, StoreRefreshDataEventArgs e)
{
if (TID.Value.ToString() != "")
{
HBBLL hb = new HBBLL();
var data2 = hb.GetYPPTDetail(int.Parse(TID.Value.ToString()), "", SessionBox.GetUserSession().DeptNumber, "");
this.YPPTDetailStore.DataSource = data2;
this.YPPTDetailStore.DataBind();
UpdateStatus1();
}
}
protected void YPPTDetailStore_RefershData(object sender, StoreRefreshDataEventArgs e)
{
if (cboPlaceTemplate.SelectedIndex > 0)
{
if (cboPlaceTemplate.SelectedItem.Value != "-1")
{
HBBLL hb = new HBBLL();
var data2 = hb.GetYPPTDetail(int.Parse(cboPlaceTemplate.SelectedItem.Value), "", SessionBox.GetUserSession().DeptNumber, "");
this.YPPTDetailStore.DataSource = data2;
this.YPPTDetailStore.DataBind();
}
}
}
private void InitPost(string deptid)
{
HBBLL hb = new HBBLL();
var post = hb.GetVPPost(deptid);
var data = from p in post
select new
{
PosID = p.PosId,
PosName = p.PosName
};
PostStore.DataSource = data;
PostStore.DataBind();
cboPost.Items.Insert(0, new Coolite.Ext.Web.ListItem("--全部--", "-1"));
cboPost.SelectedItem.Value = "-1";
}
//[AjaxMethod]
//public void PYsearch(string py, string store)
//{
//
// switch (store.Trim())
// {
// case "perStore":
// var q = from p in dc.Person
// where p.Maindeptid == SessionBox.GetUserSession().DeptNumber
// && (p.Pinyin + p.Name + p.Personnumber).ToLower().Contains(py.ToLower()) && p.Personstatus == 1
// select new
// {
// p.Personnumber,
// p.Name
// };
// perStore.DataSource = q;
// perStore.DataBind();
// break;
// case "placeStore":
// var place = from pl in dc.Place
// where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber && pl.Placestatus == 1
// && (dc.F_PINYIN(pl.Placename) + pl.Placename).ToLower().Contains(py.ToLower())
// select new
// {
// pl.Placeid,
// pl.Placename
// };
// placeStore.DataSource = place;
// placeStore.DataBind();
// break;
// }
//}
#endregion
protected void CitiesRefresh(object sender, StoreRefreshDataEventArgs e)
{
HBBLL hb = new HBBLL();
var data2 = hb.GetYPPT(cbbPerson.SelectedItem.Value, SessionBox.GetUserSession().DeptNumber);
var pt = from r in data2
select new
{
Id = r.Id,
Name = r.TLevel == "矿级" ? string.Format("{0}({1})", r.Name, r.TLevel) : r.Name,
Level = r.TLevel
};
placeTemplateStore.DataSource = pt;
placeTemplateStore.DataBind();
//cboPlaceTemplate.Items.Insert(0, new Coolite.Ext.Web.ListItem("--不使用模板--", "-1"));
}
public void PlaceDown()
{
RowSelectionModel sm = this.GridPanel2.SelectionModel.Primary as RowSelectionModel;
if (sm.SelectedRows.Count == 1)
{
RowSelectionModel sm1 = this.GridPanel1.SelectionModel.Primary as RowSelectionModel;
//DBSCMDataContext db = new DBSCMDataContext();
var pp = dc.YPlanplace.First(p => p.Ctid == Decimal.Parse(sm1.SelectedRecordID) && p.Id == decimal.Parse(sm.SelectedRows[0].RecordID));
HBBLL hb = new HBBLL();
hb.MoveDown2(pp.Id, pp.Moveorder.Value, pp.Ctid);
PlanPlaceStoreLoad(Decimal.Parse(sm1.SelectedRecordID));
}
}
public void PlaceAdd()
{
if (cbbplace.SelectedIndex == -1)
{
Ext.Msg.Alert("提示", "请选择地点!").Show();
return;
}
RowSelectionModel sm = this.GridPanel1.SelectionModel.Primary as RowSelectionModel;
var detail = dc.YPlanplace.Where(p => p.Ctid == Decimal.Parse(sm.SelectedRecordID)).OrderByDescending(p => p.Moveorder);
decimal index = 1;
if (detail.Count() > 0)
{
//foreach (var r in detail)
//{
// index = r.Moveorder.Value + 1;
// break;
//}
index = (from d in detail
select d.Moveorder).Max().Value + 1;
}
YPlanplace pp = new YPlanplace
{
Recordtime = DateTime.Now,
Placeid = decimal.Parse(cbbplace.SelectedItem.Value),
Moveorder = index,
Ctid = Decimal.Parse(sm.SelectedRecordID)
};
//dc.YPlanplace.InsertOnSubmit(pp);
try
{
HBBLL hb = new HBBLL();
hb.AddYPlanplace(pp.Recordtime, pp.Placeid, pp.Moveorder.Value, pp.Ctid);
//dc.SubmitChanges();
}
catch (Exception ex)
{
Ext.Msg.Alert("错误", ex.Message).Show();
return;
}
RecordAction(Decimal.Parse(sm.SelectedRecordID), "添加地点");
cbbplace.Value = null;
Ext.Msg.Alert("提示", "添加成功!").Show();
PlanPlaceStoreLoad(Decimal.Parse(sm.SelectedRecordID));
}
public void SuerDelete()
{
RowSelectionModel sm = this.GridPanel2.SelectionModel.Primary as RowSelectionModel;
if (sm.SelectedRows.Count > 0)
{
List <int> ids = new List <int>();
foreach (var item in sm.SelectedRows)
{
ids.Add(Convert.ToInt32(item.RecordID));
}
HBBLL hb = new HBBLL();
hb.DeleteYPPTDetail(ids);
hb.UpdateYPPTDetailOrder(int.Parse(TID.Value.ToString()));
Ext.Msg.Alert("提示", "删除成功!").Show();
Ext.DoScript("#{YPPTDetailStore}.reload();");
}
}
private void storeload()
{
string person = "";
if (txtName.Text.Trim() != "")
{
string[] ss = System.Text.RegularExpressions.Regex.Split(txtName.Text.Trim(), "\\s+|[，,]");
foreach (var s in ss)
{
person = string.Format("'{0}',", s);
}
person = person.Substring(0, person.Length - 1);
}
HBBLL hb = new HBBLL();
var vp = hb.GetVP(cbbDept.SelectedItem.Value, cboPost.SelectedItem.Value, person);
var minetotal = hb.GetMineTotal(person, string.Format("{0}-{1}", cboYear.SelectedItem.Value, cboMonth.SelectedItem.Value.PadLeft(2, '0')));
var daibantotal = hb.GetDaiBanTotal(person, string.Format("{0}-{1}", cboYear.SelectedItem.Value, cboMonth.SelectedItem.Value.PadLeft(2, '0')));
var data = from v in vp
join m in minetotal on v.PersonNumber equals m.PersonId into x
from v_m in x.DefaultIfEmpty()
join d in daibantotal on v.PersonNumber equals d.PersonNumber into y
from v_d in y.DefaultIfEmpty()
select new LeaderDownMine
{
MainDeptNumber = v.DeptNumber,
MainDeptName = v.DeptName,
PersonNumber = v.PersonNumber,
PersonName = v.Name,
PostID = v.PosId,
PostName = v.PosName,
DownMineTotal = v_m == null?0:v_m.Count.Value,
DaiBanZao = v_d == null?0:v_d.Zao.Value,
DaiBanZhong = v_d == null?0:v_d.Zhong.Value,
DaiBanYe = v_d == null?0:v_d.Ye.Value,
DaiBanTotal = (v_d == null ? 0 : v_d.Zao.Value) + (v_d == null ? 0 : v_d.Zhong.Value) + (v_d == null ? 0 : v_d.Ye.Value),
About = ""
};
ldm = data.ToList <LeaderDownMine>();
Store1.DataSource = data;
Store1.DataBind();
}
public void SaveTName()
{
if (txtTName.Text.Trim() != "")
{
HBBLL hb = new HBBLL();
if (TID.Value.ToString() == "")
{
hb.AddYPPT(txtTName.Text.Trim(), rKuangJi.Checked == true?rKuangJi.BoxLabel:rGeRen.BoxLabel, SessionBox.GetUserSession().PersonNumber, SessionBox.GetUserSession().DeptNumber);
Ext.Msg.Alert("提示", "新增成功!").Show();
Ext.DoScript("#{placeTemplateStore}.reload();");
}
else
{
hb.UpdateYPPT(txtTName.Text.Trim(), int.Parse(TID.Value.ToString()));
Ext.Msg.Alert("提示", "修改成功!").Show();
Ext.DoScript("#{placeTemplateStore}.reload();");
}
}
}
private void UpdateStatus1()
{
RowSelectionModel sm = this.GridPanel2.SelectionModel.Primary as RowSelectionModel;
HBBLL hb = new HBBLL();
var data = hb.GetYPPTByID(int.Parse(TID.Value.ToString()));
if (data.CreatePersonNumber == SessionBox.GetUserSession().PersonNumber)
{
switch (sm.SelectedRows.Count)
{
case 0:
btnPlaceUpdate.Disabled = true;
btnPlaceDel.Disabled = true;
btnDown.Disabled = true;
btnUp.Disabled = true;
break;
case 1:
btnPlaceUpdate.Disabled = false;
btnPlaceDel.Disabled = false;
btnDown.Disabled = false;
btnUp.Disabled = false;
break;
default:
btnPlaceUpdate.Disabled = true;
btnPlaceDel.Disabled = false;
btnDown.Disabled = true;
btnUp.Disabled = true;
break;
}
}
else
{
btnPlaceAdd.Disabled = true;
btnPlaceUpdate.Disabled = true;
btnPlaceDel.Disabled = true;
btnDown.Disabled = true;
btnUp.Disabled = true;
}
}
public void RouteMan()
{
RowSelectionModel sm = this.GridPanel1.SelectionModel.Primary as RowSelectionModel;
if (sm.SelectedRows.Count > 0)
{
HBBLL hb = new HBBLL();
TID.SetValue(sm.SelectedRows[0].RecordID.Trim());
TID.Value = sm.SelectedRows[0].RecordID.Trim();
TID.Text = sm.SelectedRows[0].RecordID.Trim();
string id = TID.Value.ToString();
id = TID.Text;
lblDetail.Text = hb.GetYPPTNameByID(int.Parse(id));
DetailWindow.Show();
UpdateStatus1();
Ext.DoScript("#{YPPTDetailStore}.reload();");
}
else
{
Ext.Msg.Alert("提示", "请选择一个模板!").Show();
}
}
public void ExportXls()
{
HBBLL hb = new HBBLL();
DataTable dt = Util.LinqQueryToDataTable <LeaderDownMine>(ldm);
dt.TableName = "tt";
var s = Aspose.Cells.CellsHelper.GetVersion();
WorkbookDesigner designer = new WorkbookDesigner();
designer.Open(MapPath("tt.xls"));
//数据源
designer.SetDataSource(dt);
//报表标题
designer.SetDataSource("Title", string.Format("{0}副总以上领导下井人员情况汇总表", cbbDept.SelectedItem.Value == "-1"?"各矿":cbbDept.SelectedItem.Text));
designer.SetDataSource("DownDate", string.Format("{0}年{1}月)", cboYear.SelectedItem.Value, cboMonth.SelectedItem.Value.PadLeft(2, '0')));
designer.Process();
designer.Save(string.Format("各矿副总以上领导下井人员情况汇总表{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssffff")), SaveType.OpenInExcel, FileFormatType.Excel97To2003, Response);
Response.Flush();
Response.Close();
designer = null;
Response.End();
}
public void BaseSave()
{
if (cbbplace.SelectedIndex == -1)
{
Ext.Msg.Alert("提示", "请选择地点!").Show();
return;
}
if (TDID.Value.ToString() == "")
{
HBBLL hb = new HBBLL();
hb.AddYPPTDetail(int.Parse(TID.Value.ToString()), int.Parse(cbbplace.SelectedItem.Value), hb.GetMaxMoveOrder(int.Parse(TID.Value.ToString())) + 1);
cbbplace.Value = null;
Ext.Msg.Alert("提示", "新增成功!").Show();
Ext.DoScript("#{YPPTDetailStore}.reload();");
}
else
{
HBBLL hb = new HBBLL();
hb.UpdateYPPTDetail(int.Parse(cbbplace.SelectedItem.Value), int.Parse(TDID.Value.ToString()));
cbbplace.Value = null;
Ext.Msg.Alert("提示", "修改成功!").Show();
Ext.DoScript("#{YPPTDetailStore}.reload();");
}
}
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 string BaseSave()
{
if (df_begin.SelectedValue == null || cbbBc.SelectedIndex == -1 || cbbPerson.SelectedIndex == -1)
{
//Ext.Msg.Alert("提示", "请填写完整信息!").Show();
return("请填写完整信息!");
}
if (df_begin.SelectedDate < System.DateTime.Today)
{
//Ext.Msg.Alert("提示", "只能制定本日及以后的计划!").Show();
return("只能制定本日及以后的计划!");
}
if (dc.YChargetable.Where(p => p.Cdate == df_begin.SelectedDate && p.Cbanci == cbbBc.SelectedItem.Value && p.Cperson == cbbPerson.SelectedItem.Value).Count() > 0)
{
//Ext.Msg.Alert("提示", "已添加的计划!").Show();
return("已添加的计划!");
}
if (cboPlaceTemplate.SelectedIndex <= -1)
{
YChargetable ct = new YChargetable
{
Recordtime = System.DateTime.Now,
Rperson = SessionBox.GetUserSession().PersonNumber,
Cdate = df_begin.SelectedDate,
Cbanci = cbbBc.SelectedItem.Value,
Cperson = cbbPerson.SelectedItem.Value,
Maindept = SessionBox.GetUserSession().DeptNumber,
Status = 1
};
dc.YChargetable.InsertOnSubmit(ct);
dc.SubmitChanges();
//RecordAction(ct.Id, "新增");
//Ext.Msg.Alert("提示", "新增成功!").Show();
Ext.DoScript("#{Store1}.reload();");
return("新增成功!");
}
else if (cboPlaceTemplate.SelectedItem.Value != "-1")
{
HBBLL hb = new HBBLL();
if (hb.HaveMoveTemplate(int.Parse(cboPlaceTemplate.SelectedItem.Value)) > 0)
{
DateTime dt = System.DateTime.Now;
YChargetable ct = new YChargetable
{
Recordtime = dt,
Rperson = SessionBox.GetUserSession().PersonNumber,
Cdate = df_begin.SelectedDate,
Cbanci = cbbBc.SelectedItem.Value,
Cperson = cbbPerson.SelectedItem.Value,
Maindept = SessionBox.GetUserSession().DeptNumber,
Status = 1
};
dc.YChargetable.InsertOnSubmit(ct);
dc.SubmitChanges();
foreach (YPPTDetail pt in hb.GetYPPTDetail(int.Parse(cboPlaceTemplate.SelectedItem.Value), "", SessionBox.GetUserSession().DeptNumber, ""))
{
YPlanplace pp = new YPlanplace
{
Ctid = ct.Id,
Recordtime = dt,
Placeid = decimal.Parse(pt.PlaceId.ToString()),
Moveorder = decimal.Parse(pt.MoveOrder.ToString())
};
hb.AddYPlanplace(pp.Recordtime, pp.Placeid, pp.Moveorder.Value, pp.Ctid);
//dc.YPlanplace.InsertOnSubmit(pp);
//dc.SubmitChanges();
}
//RecordAction(ct.Id, "新增");
//RecordAction(ct.Id, "添加地点");
//Ext.Msg.Alert("提示", "新增成功!").Show();
//storeload();
Ext.DoScript("#{Store1}.reload();");
return("新增成功!");
}
else
{
//Ext.Msg.Alert("提示", "请确保模板里有走动线路!").Show();
return("请确保模板里有走动线路!");
}
}
else
{
//Ext.Msg.Alert("提示", "未知错误!").Show();
return("未知错误！");
}
}
