public static int GetSWMaxScoreSet(string maindept)
{
DBSCMDataContext dc = new DBSCMDataContext();
var w = dc.Swwarningset.Where(p => p.Deptnumber == maindept);
if (w.Count() > 0)
{
return(int.Parse(w.First().Maxscore.ToString()));
}
else
{
return(12);
}
}
private void AddRAdetail(XmlNode data, decimal rid)
{
ParResultAdddetail ra = new ParResultAdddetail
{
Ajcid = decimal.Parse(data.SelectSingleNode("Jcid").InnerText.Trim().Substring(1)),
Jeom = data.SelectSingleNode("Jeom").InnerText.Trim() == "" ? 0 : decimal.Parse(data.SelectSingleNode("Jeom").InnerText),
Remark = data.SelectSingleNode("Remark").InnerText.Trim(),
Rid = rid
};
DBSCMDataContext dc1 = new DBSCMDataContext();
dc1.ParResultAdddetail.InsertOnSubmit(ra);
dc1.SubmitChanges();
}
private static string GetPhoneViaName(string name)
{
name = name.Replace(" ", "").Trim();
DBSCMDataContext dc = new DBSCMDataContext();
var phone = from psn in dc.Person
where psn.Name == name && psn.Maindeptid == "241700000"
select psn.Tel;
if (phone.Count() > 0)
{
return(phone.First());
}
else
{
return("0");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Ext.IsAjaxRequest)
{
dfBegin.SelectedDate = System.DateTime.Today;
dfEnd.SelectedDate = System.DateTime.Today;
dfBegin.MaxDate = System.DateTime.Today;
dfEnd.MaxDate = System.DateTime.Today;
#region 初始化单位
DBSCMDataContext dc = new DBSCMDataContext();
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.SelectedItem.Value = "241700000";
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
LoadData();
}
}
public static decimal GetKQrecord(string personnumber, DateTime pcdate, string pcbanci, string inputperson)
{
DBSCMDataContext dc = new DBSCMDataContext();
var krs = dc.KqRecord.Where(p => p.Kqpnumber == personnumber && p.Kqtime == pcdate && p.Kqbenci == pcbanci);
if (krs.Count() == 0)
{
string historysql = string.Format("SELECT short_name, stateflag,person_name, entertime_mine, outtime_mine, trackblock, station_mark FROM v_jykj_history where remark2='{0}' and outtime_mine>='{1}' order by outtime_mine desc;",
personnumber.PadLeft(7, '0'),
System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
PostGreSQLHelper pgh = new PostGreSQLHelper();
DataTable dthistory = pgh.ExecuteQuery(historysql).Tables[0];
if (dthistory.Rows.Count > 0)
{
KqRecord kr = new KqRecord
{
Kqtime = pcdate,
Kqbenci = pcbanci,
Inputperson = inputperson,
Downtime = DateTime.Parse(dthistory.Rows[0]["entertime_mine"].ToString()),
Uptime = DateTime.Parse(dthistory.Rows[0]["outtime_mine"].ToString()),
Kqpnumber = personnumber,
Zdgj = dthistory.Rows[0]["trackblock"].ToString().Trim()
};
dc.KqRecord.InsertOnSubmit(kr);
dc.SubmitChanges();
return(dc.KqRecord.First(p => p.Kqpnumber == personnumber && p.Downtime == kr.Downtime).Rjid);
}
else
{
return(-1);
}
}
else
{
if (krs.First().Uptime >= System.DateTime.Now.AddHours(-1))
{
return(krs.First().Rjid);
}
else
{
return(-1);
}
}
}
public void PYsearch(string py, string store)//拼音检索
{
switch (store.Trim())
{
case "FkrenStore":
DBSCMDataContext dc = new DBSCMDataContext();
var q2 = from p in dc.Person
where p.Maindeptid == SessionBox.GetUserSession().DeptNumber&& p.Pinyin.ToLower().Contains(py.ToLower())
select new
{
p.Personnumber,
p.Name
};
FkrenStore.DataSource = q2;
FkrenStore.DataBind();
break;
}
}
/// <summary>
/// 获取首页待办三违信息--（已用）
/// </summary>
/// <returns>返回行数</returns>
public static string[] getSWinfoD()
{
DBSCMDataContext dc = new DBSCMDataContext();
int count = 0;
string group = "";
var q = from a in dc.Nswinput
//from b in dc.SanWeiNumber
where //a.SWNumber == b.SWNumber &&
a.Isend == 0
select a.Id;
count = q.Count();
foreach (var r in q)
{
group += r.ToString() + ",";
}
group = count > 0 ? group.Substring(0, group.Length - 1) : "";
return(new string[] { count.ToString(), group });
}
/// <summary>
/// 获取首页隐患信息--矿领导:待审批（已用）
/// </summary>
/// <param name="PerID">登陆账号人员ID</param>
/// <param name="DepID">登陆账号部门ID</param>
/// <returns>返回行数</returns>
public static string[] getYHDSP_kld(string PerID, string DepID)
{
DBSCMDataContext dc = new DBSCMDataContext();
int count = 0;
string group = "";
var q = from yh in dc.Getyhinput
//from yhNum in dc.YinHuanNumber
where //yh.YHNumber == yhNum.YHNumber &&
yh.Status == "提交审批" && yh.Refer == 1 && yh.Referid == PerID
select yh.Yhputinid;
count = q.Count();
foreach (var r in q)
{
group += r.ToString() + ",";
}
group = count > 0 ? group.Substring(0, group.Length - 1) : "";
return(new string[] { count.ToString(), group });
}
/// <summary>
/// 获取首页逾期未整改隐患信息--（已用）
/// </summary>
/// <param name="PerID">登陆账号人员ID</param>
/// <param name="DepID">登陆账号部门ID</param>
/// <returns>返回行数</returns>
public static string[] getYHinfoD3(string DepID)
{
DBSCMDataContext dc = new DBSCMDataContext();
int count = 0;
string group = "";
var q = from yh in dc.Getyhinput
where yh.Status == "逾期未整改" && yh.Unitid == DepID
select yh.Yhputinid;
count = q.Count();
foreach (var r in q)
{
group += r.ToString() + ",";
}
group = count > 0 ? group.Substring(0, group.Length - 1) : "";
return(new string[] { count.ToString(), group });
}
public void Banoutqueue()
{
RowSelectionModel sm = gpPer.SelectionModel.Primary as RowSelectionModel;
if (sm.SelectedRows.Count > 0)
{
foreach (var r in sm.SelectedRows)
{
DBSCMDataContext db = new DBSCMDataContext();
var sw = db.Nswinput.First(p => p.Swpersonid == r.RecordID && p.Islearn == 1);
sw.Islearn = 2;
db.SubmitChanges();
}
Ext.Msg.Alert("提示", "移除成功，共移除" + sm.SelectedRows.Count.ToString() + "人").Show();
SelectedStoreLoad();
sm.SelectedRows.Clear();
sm.UpdateSelection();
}
}
/// <summary>
/// 获取首页现场整改隐患信息-（未用）
/// </summary>
/// <param name="PerID">登陆账号人员ID</param>
/// <param name="DepID">登陆账号部门ID</param>
/// <returns>返回行数</returns>
public static string[] getYHinfoDXCZG(string DepID)
{
DBSCMDataContext dc = new DBSCMDataContext();
int count = 0;
string group = "";
var q = from yh in dc.Getyhinput
where yh.Status == "现场整改" && (yh.Pctime.Value.Year.ToString().Trim() + yh.Pctime.Value.Month.ToString().Trim()) == (DateTime.Now.Year.ToString().Trim() + DateTime.Now.Month.ToString().Trim()) && yh.Deptid == DepID
select yh.Yhputinid;
count = q.Count();
foreach (var r in q)
{
group += r.ToString() + ",";
}
group = count > 0 ? group.Substring(0, group.Length - 1) : "";
return(new string[] { count.ToString(), group });
}
public void Detail_Del()
{
CheckboxSelectionModel sm = this.GridPanel1.SelectionModel.Primary as CheckboxSelectionModel;
if (sm.SelectedRows.Count() > 0)
{
foreach (var r in sm.SelectedRows)
{
DBSCMDataContext dc = new DBSCMDataContext();
var mp1 = dc.Moveplan.Where(p => p.Id == Convert.ToInt32(r.RecordID) && p.Movestate != "已走动");
if (mp1.Count() > 0)
{
dc.Moveplan.DeleteAllOnSubmit(mp1);
dc.SubmitChanges();
}
}
storeload();
Ext.Msg.Alert("提示", "删除成功!").Show();
}
}
protected void SaveJ(object sender, BeforeStoreChangedEventArgs e)
{
XmlNode xml = e.DataHandler.XmlData;
XmlNode updated = xml.SelectSingleNode("records/Updated");
if (updated != null)
{
XmlNodeList uRecords = updated.SelectNodes("record");
if (uRecords.Count > 0)
{
foreach (XmlNode record in uRecords)
{
if (record != null)
{
DBSCMDataContext dc1 = new DBSCMDataContext();
var rd = dc1.SqsResultDetail.Where(p => p.Jcid == decimal.Parse(record.SelectSingleNode("Jcid").InnerText) && p.Rid == decimal.Parse(hdnId.Value.ToString()));
if (rd.Count() == 0)
{
SqsResultDetail rk = new SqsResultDetail
{
Jcid = decimal.Parse(record.SelectSingleNode("Jcid").InnerText.Trim().Substring(1)),
Jeom = record.SelectSingleNode("Jeom").InnerText.Trim() == "" ? 0 : decimal.Parse(record.SelectSingleNode("Jeom").InnerText),
Remark = record.SelectSingleNode("Remark").InnerText.Trim(),
Rid = decimal.Parse(hdnId.Value.ToString())
};
dc1.SqsResultDetail.InsertOnSubmit(rk);
dc1.SubmitChanges();
}
else
{
var r = rd.First();
r.Jeom = record.SelectSingleNode("Jeom").InnerText.Trim() == "" ? 0 : decimal.Parse(record.SelectSingleNode("Jeom").InnerText);
r.Remark = record.SelectSingleNode("Remark").InnerText.Trim();
dc1.SubmitChanges();
}
}
}
e.Cancel = true;
}
}
}
protected void SubmitData(object sender, StoreSubmitDataEventArgs e)
{
XmlNode xml = e.Xml;
XmlNode rxml = xml.SelectSingleNode("records");
XmlNodeList uRecords = rxml.SelectNodes("record");
if (uRecords.Count > 0)
{
decimal[] Yh = new decimal[uRecords.Count]; int i = 0;
foreach (XmlNode record in uRecords)
{
if (record != null)
{
Yh[i] = decimal.Parse(record.SelectSingleNode("Yhid").InnerText.Trim());
i++;
}
}
var deldata = dc.Yhmatchup.Where(p => Yh.Contains(p.Yhid));
dc.Yhmatchup.DeleteAllOnSubmit(deldata);
dc.SubmitChanges();
foreach (XmlNode record in uRecords)
{
if (record != null)
{
DBSCMDataContext db = new DBSCMDataContext();
Yhmatchup ym = new Yhmatchup
{
Yhid = decimal.Parse(record.SelectSingleNode("Yhid").InnerText.Trim()),
Hazardsid = decimal.Parse(record.SelectSingleNode("Hazardsid").InnerText.Trim())
};
db.Yhmatchup.InsertOnSubmit(ym);
db.SubmitChanges();
}
}
Ext.Msg.Alert("提示", "对应成功！").Show();
}
else
{
Ext.Msg.Alert("提示", "请选择需要对应的信息！").Show();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!SessionBox.CheckUserSession())
{
Response.Redirect("~/Login.aspx");
}
else
{
adsSWPointSet.Where = "Deptnumber ==\"" + SessionBox.GetUserSession().DeptNumber + "\"";
if (!this.IsPostBack)
{
DBSCMDataContext db = new DBSCMDataContext();
var warn = db.Swwarningset.Where(p => p.Deptnumber == SessionBox.GetUserSession().DeptNumber);
if (warn.Count() > 0)
{
txtScore.Text = warn.First().Maxscore.ToString();
txtCount.Text = warn.First().Maxcount.ToString();
}
}
}
}
///// <summary>
///// 获取首页隐患信息--责任部门:复查未通过
///// </summary>
///// <param name="PerID">登陆账号人员ID</param>
///// <param name="DepID">登陆账号部门ID</param>
///// <returns>返回行数</returns>
///// <summary>
//public static string[] getYHFCWTG_zrbmf(string PerID, string DepID)
//{
// DBSCMDataContext dc = new DBSCMDataContext();
// int count = 0;
// string group = "";
// var q = from yh in dc.Yhinput
// //from yhNum in dc.YinHuanNumber
// from yc in dc.Yinhuancheck
// where //yh.YHNumber == yhNum.YHNumber &&
// yc.Responsibledept == DepID &&
// yh.Yhputinid == yc.Yhputinid && yh.Status == "复查未通过"
// select yh.Yhputinid;
// count = q.Count();
// foreach (var r in q)
// {
// group += r.ToString() + ",";
// }
// group = count > 0 ? group.Substring(0, group.Length - 1) : "";
// return new string[] { count.ToString(), group };
//}
/// <summary>
/// 获取首页隐患信息--责任部门:隐患未整改/整改反馈（已用）
/// </summary>
/// <param name="PerID">登陆账号人员ID</param>
/// <param name="DepID">登陆账号部门ID</param>
/// <returns>返回行数</returns>
/// <summary>
public static string[] getYHWZG_zrbmw(string PerID, string DepID)
{
DBSCMDataContext dc = new DBSCMDataContext();
int count = 0;
string group = "";
var q = from yh in dc.Getyhinput
//from yhNum in dc.YinHuanNumber
from yc in dc.Nyinhuancheck
where //yh.YHNumber == yhNum.YHNumber &&
yc.Responsibledept == DepID &&
yh.Yhputinid == yc.Yhputinid && yh.Status == "隐患未整改"
select yh.Yhputinid;
count = q.Count();
foreach (var r in q)
{
group += r.ToString() + ",";
}
group = count > 0 ? group.Substring(0, group.Length - 1) : "";
return(new string[] { count.ToString(), group });
}
protected void SaveD(object sender, BeforeStoreChangedEventArgs e)
{
XmlNode xml = e.DataHandler.XmlData;
XmlNode updated = xml.SelectSingleNode("records/Updated");
if (updated != null)
{
XmlNodeList uRecords = updated.SelectNodes("record");
if (uRecords.Count > 0)
{
foreach (XmlNode record in uRecords)
{
if (record != null)
{
DBSCMDataContext dc1 = new DBSCMDataContext();
var rd = dc1.SqsDemotiondetail.Where(p => p.Deid == decimal.Parse(record.SelectSingleNode("Deid").InnerText) && p.Rid == decimal.Parse(hdnId.Value.ToString()));
if (record.SelectSingleNode("isCheck").InnerText.Trim() == "false")
{
dc1.SqsDemotiondetail.DeleteOnSubmit(rd.First());
dc1.SubmitChanges();
}
else
{
if (rd.Count() == 0)
{
SqsDemotiondetail ra = new SqsDemotiondetail
{
Deid = decimal.Parse(record.SelectSingleNode("Deid").InnerText),
Rid = decimal.Parse(hdnId.Value.ToString())
};
dc1.SqsDemotiondetail.InsertOnSubmit(ra);
dc1.SubmitChanges();
}
}
}
}
}
}
}
/// <summary>
/// 获取首页隐患信息--走动干部:待复查（已用）
/// </summary>
/// <param name="PerID">登陆账号人员ID</param>
/// <param name="DepID">登陆账号部门ID</param>
/// <returns>返回行数</returns>
public static string[] getYHDFC_zdgb(string PerID, string DepID)
{
DBSCMDataContext dc = new DBSCMDataContext();
int count = 0;
string group = "";
var q = from yh in dc.Getyhinput
//from yhNum in dc.YinHuanNumber
from MP in dc.Moveplan
where //yh.YHNumber == yhNum.YHNumber
//MP.Personid == PerID &&
yh.Placeid == MP.Placeid && yh.Status == "隐患已整改" && yh.Unitid == DepID &&
MP.Starttime <= System.DateTime.Today && MP.Endtime >= System.DateTime.Today && MP.Movestate.Trim() == "未走动" &&
MP.Personid == PerID//add by xl
select yh.Yhputinid;
count = q.Count();
foreach (var r in q)
{
group += r.ToString() + ",";
}
group = count > 0 ? group.Substring(0, group.Length - 1) : "";
return(new string[] { count.ToString(), group });
}
//下面的可以优化
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()));
}
}
}
private static string GetPhone(string personnumber)
{
DBSCMDataContext dc = new DBSCMDataContext();
var phone = from psn in dc.Person
where psn.Personnumber == personnumber
select psn.Tel;
if (phone.Count() > 0)
{
try
{
return(phone.First().Trim());
}
catch
{
return("0");
}
}
else
{
return("0");
}
}
public void hazDel()
{
RowSelectionModel sm = gpSearchBL.SelectionModel.Primary as RowSelectionModel;
if (sm.SelectedRows.Count == 0)
{
Ext.Msg.Alert("提示", "请选择删除危险源！").Show();
return;
}
RowSelectionModel sm1 = GridPanel3.SelectionModel.Primary as RowSelectionModel;
var yh = dc.Swbase.First(p => p.Swid == decimal.Parse(sm1.SelectedRow.RecordID));
foreach (var r in sm.SelectedRows)
{
DBSCMDataContext dc1 = new DBSCMDataContext();
var y2h = dc1.Shmatchup.First(p => p.Swid == yh.Swid && p.Hazardsid == decimal.Parse(r.RecordID));
dc1.Shmatchup.DeleteOnSubmit(y2h);
dc1.SubmitChanges();
}
Ext.Msg.Alert("提示", "删除成功，共计删除" + sm.SelectedRows.Count.ToString() + "条危险源!").Show();
SearchBLLoad();
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (txtScore.Text.Trim() == "" || txtCount.Text.Trim() == "")
{
JSHelper.Alert("请填写分值与次数!");
return;
}
try
{
DBSCMDataContext db = new DBSCMDataContext();
var warn = db.Swwarningset.Where(p => p.Deptnumber == SessionBox.GetUserSession().DeptNumber);
if (warn.Count() > 0)
{
Swwarningset war = db.Swwarningset.First(p => p.Deptnumber == SessionBox.GetUserSession().DeptNumber);
war.Maxcount = decimal.Parse(txtCount.Text.Trim());
war.Maxscore = decimal.Parse(txtScore.Text.Trim());
db.SubmitChanges();
}
else
{
Swwarningset war = new Swwarningset
{
Deptnumber = SessionBox.GetUserSession().DeptNumber,
Maxcount = decimal.Parse(txtCount.Text.Trim()),
Maxscore = decimal.Parse(txtScore.Text.Trim()),
Intime = System.DateTime.Today
};
db.Swwarningset.InsertOnSubmit(war);
db.SubmitChanges();
}
JSHelper.Alert("保存成功!");
}
catch
{
JSHelper.Alert("保存失败，请检查填写是否正确!");
}
}
public void PlanCreate(decimal[,] place, List <string> perids)
{
int count = 0;
int countPsn = 0;
foreach (var perid in perids)
{
count = 0;
for (int i = 0; i < place.Length / 2; i++)
{
int rate = (int)(((dfend.SelectedDate - dfbegin.SelectedDate).Days + 1) / place[i, 1]);
//rate = rate == 0 ? 1 : rate;
DateTime begin = dfbegin.SelectedDate;
DateTime end = dfend.SelectedDate;
int make = 0;
for (; (begin <= end && make < place[i, 1]); begin = begin.AddDays(rate))//begin.AddDays(rate) <= end
{
DBSCMDataContext dc1 = new DBSCMDataContext();
Moveplan mp1 = new Moveplan
{
Personid = perid,
Placeid = place[i, 0],
Starttime = begin,
Endtime = begin > end ? end : (begin.AddDays(rate) > end ? end : begin.AddDays(rate - 1)),
Movestate = "未走动",
Maindept = SessionBox.GetUserSession().DeptNumber
};
dc1.Moveplan.InsertOnSubmit(mp1);
dc1.SubmitChanges();
count++;
make++;
}
}
countPsn++;
}
Ext.Msg.Alert("提示", string.Format("添加完成，共添加{0}人。其中每人添加{1}条计划！", countPsn.ToString(), count.ToString())).Show();
}
public void PlaceDel()
{
RowSelectionModel sm = this.GridPanel2.SelectionModel.Primary as RowSelectionModel;
if (sm.SelectedRows.Count > 0)
{
RowSelectionModel sm1 = this.GridPanel1.SelectionModel.Primary as RowSelectionModel;
foreach (var r in sm.SelectedRows)
{
DBSCMDataContext db = new DBSCMDataContext();
var pp = db.YPlanplace.First(p => p.Ctid == Decimal.Parse(sm1.SelectedRecordID) && p.Id == decimal.Parse(r.RecordID));
db.YPlanplace.DeleteOnSubmit(pp);
db.SubmitChanges();
}
ReSortPlanPlace(Decimal.Parse(sm1.SelectedRecordID));
RecordAction(Decimal.Parse(sm1.SelectedRecordID), "删除地点");
Ext.Msg.Alert("提示", "删除成功!").Show();
PlanPlaceStoreLoad(Decimal.Parse(sm1.SelectedRecordID));
}
else
{
Ext.Msg.Alert("提示", "没有选择需要删除信息!").Show();
}
}
public static string GetKQdeptNumber(string personnumber)
{
DBSCMDataContext dc = new DBSCMDataContext();
return(dc.Person.Where(p => p.Personnumber == personnumber).First().Areadeptid);
}
private string GetDataXML()
{
DBSCMDataContext dc = new DBSCMDataContext();
if (cbbKind.SelectedItem.Value == "1" || cbbKind.SelectedItem.Value == "")
{
var table = GetSafeInfo.GetAllSafetyCountByDept(cbbUnit.SelectedItem.Value, dfBegin.SelectedDate, dfEnd.SelectedDate).Tables[0];
try
{
//var group = from t in table.AsEnumerable()
// where (t["YHALL"].ToString() != "0" || t["YHYZG"].ToString() != "0" || t["YHWZG"].ToString()!="0")
// orderby int.Parse(t["YHALL"].ToString()) descending
// select new
// {
// Key = t["DEPTNAME"].ToString(),
// Total = t["YHALL"].ToString(),
// Pass = t["YHYZG"].ToString(),
// NPass = t["YHWZG"].ToString()
// };
var data = (from sw in dc.Getyhinput
where sw.Unitid == cbbUnit.SelectedItem.Value &&
sw.Pctime >= dfBegin.SelectedDate && sw.Pctime <= dfEnd.SelectedDate
select sw).ToList();
var group = from sw in data
group sw by sw.Deptname into g
select new
{
Key = g.Key,
Total = g.Count(),
Pass = g.Count(p => p.Status == "复查通过" || p.Status == "现场整改"),
NPass = g.Count(p => p.Status != "复查通过" && p.Status != "现场整改")
};
GridPanel1.ColumnModel.SetColumnHeader(0, cbbKind.SelectedItem.Text.Trim() == "" ? "隐患部门" : cbbKind.SelectedItem.Text);
Store1.DataSource = group;
Store1.DataBind();
if (group.Count() == 0)
{
return("<chart />");
}
StringBuilder chartBuilder = new StringBuilder();
chartBuilder.Append("<chart caption='隐患分析' xAxisName='" + (cbbKind.SelectedItem.Text.Trim() == "" ? "隐患部门" : cbbKind.SelectedItem.Text) + "' yAxisName='数量' showValues='0' palette='2' shownames='1' legendBorderAlpha='0' useRoundEdges='1' animation='1' decimalPrecision='0' formatNumberScale='0' baseFont='Arial' baseFontSize='12'>");
string categories = "<categories>";
string dataset1 = "<dataset seriesName='隐患数量' color='AFD8F8' showValues='1'>";
string dataset2 = "<dataset seriesName='已解决' color='8BBA00' showValues='1'>";
string dataset3 = "<dataset seriesName='未解决' color='8B0000' showValues='1'>";
foreach (var r in group)
{
categories += "<category label='" + r.Key + "' />";
dataset1 += "<set value='" + r.Total + "' />";
dataset2 += "<set value='" + r.Pass + "' />";
dataset3 += "<set value='" + r.NPass + "' />";
}
categories += "</categories>";
dataset1 += "</dataset>";
dataset2 += "</dataset>";
dataset3 += "</dataset>";
chartBuilder.Append(categories);
chartBuilder.Append(dataset1);
chartBuilder.Append(dataset2);
chartBuilder.Append(dataset3);
chartBuilder.Append("</chart>");
return(chartBuilder.ToString());
}
catch
{
Store1.DataSource = null;
Store1.DataBind();
return("<chart />");
}
}
else
{
var date = (from sw in dc.Getyhinput
where sw.Unitid == cbbUnit.SelectedItem.Value &&
sw.Pctime >= dfBegin.SelectedDate && sw.Pctime <= dfEnd.SelectedDate
select sw).ToList();
var group = from sw in date
group sw by sw.Placename into g
orderby g.Count() descending
select new
{
Key = g.Key,
Total = g.Count(),
Pass = g.Count(p => p.Status == "复查通过" || p.Status == "现场整改"),
NPass = g.Count(p => p.Status != "复查通过" && p.Status != "现场整改")
};
GridPanel1.ColumnModel.SetColumnHeader(0, cbbKind.SelectedItem.Text.Trim() == "" ? "隐患部门" : cbbKind.SelectedItem.Text);
Store1.DataSource = group;
Store1.DataBind();
if (group.Count() == 0)
{
return("<chart />");
}
StringBuilder chartBuilder = new StringBuilder();
chartBuilder.Append("<chart caption='隐患分析' xAxisName='" + (cbbKind.SelectedItem.Text.Trim() == "" ? "隐患部门" : cbbKind.SelectedItem.Text) + "' yAxisName='数量' showValues='0' palette='2' shownames='1' legendBorderAlpha='0' useRoundEdges='1' animation='1' decimalPrecision='0' formatNumberScale='0' baseFont='Arial' baseFontSize='12'>");
string categories = "<categories>";
string dataset1 = "<dataset seriesName='隐患数量' color='AFD8F8' showValues='1'>";
string dataset2 = "<dataset seriesName='已解决' color='8BBA00' showValues='1'>";
string dataset3 = "<dataset seriesName='未解决' color='8B0000' showValues='1'>";
foreach (var r in group)
{
categories += "<category label='" + r.Key + "' />";
dataset1 += "<set value='" + r.Total + "' />";
dataset2 += "<set value='" + r.Pass + "' />";
dataset3 += "<set value='" + r.NPass + "' />";
}
categories += "</categories>";
dataset1 += "</dataset>";
dataset2 += "</dataset>";
dataset3 += "</dataset>";
chartBuilder.Append(categories);
chartBuilder.Append(dataset1);
chartBuilder.Append(dataset2);
chartBuilder.Append(dataset3);
chartBuilder.Append("</chart>");
return(chartBuilder.ToString());
}
//GridPanel1.ColumnModel.SetColumnHeader(0, cbbKind.SelectedItem.Text.Trim() == "" ? "隐患部门" : cbbKind.SelectedItem.Text);
//Store1.DataSource = group;
//Store1.DataBind();
//if (group.Count() == 0)
//{
// return "<chart />";
//}
//StringBuilder chartBuilder = new StringBuilder();
//chartBuilder.Append("<chart caption='隐患分析' xAxisName='" + (cbbKind.SelectedItem.Text.Trim() == "" ? "隐患部门" : cbbKind.SelectedItem.Text) + "' yAxisName='数量' showValues='0' palette='2' shownames='1' legendBorderAlpha='0' useRoundEdges='1' animation='1' decimalPrecision='0' formatNumberScale='0' baseFont='Arial' baseFontSize='12'>");
//string categories = "<categories>";
//string dataset1 = "<dataset seriesName='隐患数量' color='AFD8F8' showValues='0'>";
//string dataset2 = "<dataset seriesName='已解决' color='8BBA00' showValues='0'>";
//string dataset3 = "<dataset seriesName='未解决' color='8B0000' showValues='0'>";
//foreach (var r in group)
//{
// categories += "<category label='" + r.Key + "' />";
// dataset1 += "<set value='" + r.Total + "' />";
// dataset2 += "<set value='" + r.Pass + "' />";
// dataset3 += "<set value='" + r.NPass + "' />";
//}
//categories += "</categories>";
//dataset1 += "</dataset>";
//dataset2 += "</dataset>";
//dataset3 += "</dataset>";
//chartBuilder.Append(categories);
//chartBuilder.Append(dataset1);
//chartBuilder.Append(dataset2);
//chartBuilder.Append(dataset3);
//chartBuilder.Append("</chart>");
//return chartBuilder.ToString();
}
private string GetDataXML()
{
DBSCMDataContext dc = new DBSCMDataContext();
var data = (from sw in dc.Nswinput
from sb in dc.Swbase
from c in dc.CsBaseinfoset
from p in dc.Person
from d in dc.Department
from pl in dc.Place
where sw.Swid == sb.Swid && sb.Levelid == c.Infoid && sw.Swpersonid == p.Personnumber && p.Areadeptid == d.Deptnumber &&
sw.Placeid == pl.Placeid &&
sw.Pctime >= dfBegin.SelectedDate && sw.Pctime <= dfEnd.SelectedDate && sw.Maindeptid == cbbUnit.SelectedItem.Value
select new
{
sw.Id,
c.Infoname,
sw.Fine,
d.Deptname,
pl.Placename
}).ToList();
var group = from sw in data
group sw by sw.Infoname into g
select new
{
Key = g.Key,
Total = g.Count(),
Fine = g.Sum(p => p.Fine).GetValueOrDefault(0)
};
switch (cbbKind.SelectedItem.Value)
{
case "1":
group = from sw in data
group sw by sw.Deptname into g
select new
{
Key = g.Key,
Total = g.Count(),
Fine = g.Sum(p => p.Fine).GetValueOrDefault(0)
};
break;
case "2":
group = from sw in data
group sw by sw.Placename into g
select new
{
Key = g.Key,
Total = g.Count(),
Fine = g.Sum(p => p.Fine).GetValueOrDefault(0)
};
break;
}
group = group.OrderByDescending(p => p.Total);
GridPanel1.ColumnModel.SetColumnHeader(0, cbbKind.SelectedItem.Text.Trim() == "" ? "三违级别" : cbbKind.SelectedItem.Text);
Store1.DataSource = group;
Store1.DataBind();
string labelFormatting = " labelDisplay='WRAP' ";
if (group.Count() == 0)
{
return("<chart />");
}
else if (group.Count() > 10)
{
labelFormatting = " labelDisplay='ROTATE' slantLabels='1' ";
}
StringBuilder chartBuilder = new StringBuilder();
chartBuilder.Append("<chart caption='三违分析' xAxisName='" + (cbbKind.SelectedItem.Text.Trim() == "" ? "三违级别" : cbbKind.SelectedItem.Text) + "' sYAxisValuesDecimals='2' connectNullData='0' PYAxisName='三违数量' SYAxisName='罚款金额(元)' showValues='0' palette='2' shownames='1' legendBorderAlpha='0' useRoundEdges='1' animation='1' decimalPrecision='0' formatNumberScale='0' baseFont='Arial' baseFontSize='12' " + labelFormatting + ">");
string categories = "<categories>";
string dataset1 = "<dataset seriesName='三违数量' color='AFD8F8' showValues='1'>";
string dataset2 = "<dataset seriesName='罚款金额' color='8BBA00' showValues='1' parentYAxis='S'>";
foreach (var r in group)
{
categories += "<category label='" + r.Key + "' />";
dataset1 += "<set value='" + r.Total + "' />";
dataset2 += "<set value='" + r.Fine + "' />";
}
categories += "</categories>";
dataset1 += "</dataset>";
dataset2 += "</dataset>";
chartBuilder.Append(categories);
chartBuilder.Append(dataset1);
chartBuilder.Append(dataset2);
chartBuilder.Append("</chart>");
return(chartBuilder.ToString());
}
private string GetDataXMLYH()
{
DBSCMDataContext dc = new DBSCMDataContext();
string year = cbbKind.SelectedItem.Text.Trim() == "" ? System.DateTime.Today.Year.ToString() : cbbKind.SelectedItem.Text;
var yh = from y in dc.Nyhinput
from c in dc.CsBaseinfoset
where y.Levelid == c.Infoid
select new
{
y.Maindeptid,
y.Pctime,
c.Infoname
};
var group = from sw in yh
where sw.Maindeptid == SessionBox.GetUserSession().DeptNumber&&
sw.Pctime.Value.Year == int.Parse(year)
group sw by sw.Infoname into g
select new
{
Key = g.Key,
Total = g.Count()
};
if (group.Count() == 0)
{
return("<chart />");
}
StringBuilder chartBuilder = new StringBuilder();
chartBuilder.Append("<chart caption='隐患信息' palette='" + Functions.GetPalette() + "' animation='" + Functions.GetAnimationState() + "' subCaption='(" + year + "年度)' showValues='0' formatNumberScale='0' showPercentInToolTip='0' baseFont='Arial' baseFontSize='12'>");
foreach (var r in group)
{
string color = "";
switch (r.Key.Trim().ToUpper())
{
case "A":
color = "FF0000";
break;
case "B":
color = "FFA500";
break;
case "C":
color = "000000";
break;
case "D":
color = "0000FF";
break;
default:
color = "C0C0C0";
break;
}
chartBuilder.Append("<set label='" + r.Key + "' value='" + r.Total + "' color='" + color + "' />");
}
chartBuilder.Append("<styles><definition><style type='font' name='CaptionFont' size='15' color='" + Functions.getCaptionFontColor + "' /><style type='font' name='SubCaptionFont' bold='0' /></definition><application><apply toObject='caption' styles='CaptionFont' /><apply toObject='SubCaption' styles='SubCaptionFont' /></application></styles>");
chartBuilder.Append("<styles><definition><style type='font' name='CaptionFont' size='15' /><style type='font' name='SubCaptionFont' bold='0' /></definition><application><apply toObject='caption' styles='CaptionFont' /><apply toObject='SubCaption' styles='SubCaptionFont' /></application></styles>");
chartBuilder.Append("</chart>");
return(chartBuilder.ToString());
}
/// <summary>
/// 发送短信息
/// </summary>
/// <param name="personnumber">人员编码</param>
/// <param name="content">短信内容</param>
/// <param name="type">发送类型</param>
/// <param name="msgid">隐患，三违，走动等ID信息。需要就写入。</param>
/// <param name="sender">发送者</param>
/// <returns>成功返回"1"</returns>
public static string Send(string personnumber, string content, SmsType type, string msgid, string sender)
{
string phone = GetPhone(personnumber).Trim() == "" ? "0" : GetPhone(personnumber);
if (VerifyNumber(phone))
{
DBSCMDataContext dc = new DBSCMDataContext();
TblSmsendtask sms = new TblSmsendtask();
sms.Count = 1;
sms.Creatorid = "000";
sms.Destaddr = phone;
sms.Destaddrtype = 0;
sms.Feecode = 0;
sms.Feetype = "01";
sms.Messageid = 0;
sms.Msgid = "";
sms.Needstatereport = 0;
sms.Operationtype = "WAS";
sms.Orgaddr = "1065730615390000";
sms.Reserve1 = "";
sms.Reserve2 = "";
sms.Sendlevel = 0;
sms.Sendstate = 0;
sms.Sendtime = DateTime.Now.AddSeconds(2);
sms.Sendtype = 1;
sms.Serviceid = "MAH0510101";
sms.SmContent = GetSmsType(type) + content + "\n" + sender;
sms.Smsendednum = 0;
sms.Smtype = 0;
sms.Suboperationtype = 66;
sms.Subtime = DateTime.Now;
sms.Successid = 0;
sms.Taskname = "";
sms.Taskstatus = 0;
sms.Trytimes = 3;
string strSql = "INSERT INTO [tbl_SMSendTask]( [CreatorID], [TaskName], [SmSendedNum], [OperationType], [SuboperationType], [SendType], [OrgAddr], [DestAddr], [SM_Content], [SendTime], [NeedStateReport], [ServiceID], [FeeType], [FeeCode], [MsgID], [SMType], [MessageID], [DestAddrType], [SubTime], [TaskStatus], [SendLevel], [SendState], [TryTimes], [Count], [SuccessID], [Reserve1], [Reserve2]) values ('" + sms.Creatorid + "','" + sms.Taskname + "'," + sms.Smsendednum.Value.ToString() + ",'" + sms.Operationtype + "'," + sms.Suboperationtype.Value.ToString() + "," + sms.Sendtype.Value.ToString() + ",'" + sms.Orgaddr + "','" + sms.Destaddr + "','" + sms.SmContent + "','" + sms.Sendtime.Value + "'," + sms.Needstatereport.Value.ToString() + ",'" + sms.Serviceid + "','" + sms.Feetype + "'," + sms.Feecode.Value.ToString() + ",'" + sms.Msgid + "'," + sms.Smtype.Value.ToString() + "," + sms.Messageid.Value.ToString() + "," + sms.Destaddrtype.Value.ToString() + ",'" + sms.Subtime.Value + "'," + sms.Taskstatus.Value.ToString() + "," + sms.Sendlevel.Value.ToString() + "," + sms.Sendstate.Value.ToString() + "," + sms.Trytimes.Value.ToString() + "," + sms.Count.Value.ToString() + "," + sms.Successid.Value.ToString() + ",'" + sms.Reserve1 + "','" + sms.Reserve2 + "')";
try
{
if (SQLHelper.ExecuteSql(strSql) >= 1)
{
sms.Successid = 1;
sms.Taskname = GetSmsType(type);
sms.Msgid = msgid;
dc.TblSmsendtask.Insert(sms);
dc.SubmitChanges();
return("1");
}
else
{
dc.TblSmsendtask.Insert(sms);
dc.SubmitChanges();
return("0");
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
else
{
return("非法的手机号码！");
}
}
public static string Send(string txt, ListBox lstPerson, string sender)
{
string phone = "";
string errmsg = "";
int failcount = 0;
for (int i = 0; i < lstPerson.Items.Count; i++)
{
phone = VerifyNumber(lstPerson.Items[i].Text.Trim()) ? lstPerson.Items[i].Text.Trim() : GetPhoneViaName(lstPerson.Items[i].Text.Trim());
if (VerifyNumber(phone))
{
DBSCMDataContext dc = new DBSCMDataContext();
TblSmsendtask sms = new TblSmsendtask();
sms.Count = 1;
sms.Creatorid = "000";
sms.Destaddr = phone;
sms.Destaddrtype = 0;
sms.Feecode = 0;
sms.Feetype = "01";
sms.Messageid = 0;
sms.Msgid = "";
sms.Needstatereport = 0;
sms.Operationtype = "WAS";
sms.Orgaddr = "1065730615390000";
sms.Reserve1 = "";
sms.Reserve2 = "";
sms.Sendlevel = 0;
sms.Sendstate = 0;
sms.Sendtime = DateTime.Now.AddSeconds(2);
sms.Sendtype = 1;
sms.Serviceid = "MAH0510101";
sms.SmContent = GetSmsType(SmsType.None) + txt + "\n" + sender;
sms.Smsendednum = 0;
sms.Smtype = 0;
sms.Suboperationtype = 66;
sms.Subtime = DateTime.Now;
sms.Successid = 0;
sms.Taskname = "";
sms.Taskstatus = 0;
sms.Trytimes = 3;
string strSql = "INSERT INTO [tbl_SMSendTask]( [CreatorID], [TaskName], [SmSendedNum], [OperationType], [SuboperationType], [SendType], [OrgAddr], [DestAddr], [SM_Content], [SendTime], [NeedStateReport], [ServiceID], [FeeType], [FeeCode], [MsgID], [SMType], [MessageID], [DestAddrType], [SubTime], [TaskStatus], [SendLevel], [SendState], [TryTimes], [Count], [SuccessID], [Reserve1], [Reserve2]) values ('" + sms.Creatorid + "','" + sms.Taskname + "'," + sms.Smsendednum.Value.ToString() + ",'" + sms.Operationtype + "'," + sms.Suboperationtype.Value.ToString() + "," + sms.Sendtype.Value.ToString() + ",'" + sms.Orgaddr + "','" + sms.Destaddr + "','" + sms.SmContent + "','" + sms.Sendtime.Value + "'," + sms.Needstatereport.Value.ToString() + ",'" + sms.Serviceid + "','" + sms.Feetype + "'," + sms.Feecode.Value.ToString() + ",'" + sms.Msgid + "'," + sms.Smtype.Value.ToString() + "," + sms.Messageid.Value.ToString() + "," + sms.Destaddrtype.Value.ToString() + ",'" + sms.Subtime.Value + "'," + sms.Taskstatus.Value.ToString() + "," + sms.Sendlevel.Value.ToString() + "," + sms.Sendstate.Value.ToString() + "," + sms.Trytimes.Value.ToString() + "," + sms.Count.Value.ToString() + "," + sms.Successid.Value.ToString() + ",'" + sms.Reserve1 + "','" + sms.Reserve2 + "')";
try
{
if (SQLHelper.ExecuteSql(strSql) >= 1)
{
sms.Successid = 1;
sms.Taskname = GetSmsType(SmsType.Other);
dc.TblSmsendtask.Insert(sms);
dc.SubmitChanges();
}
else
{
dc.TblSmsendtask.Insert(sms);
dc.SubmitChanges();
failcount++;
}
}
catch (Exception ex)
{
failcount++;
errmsg += ex.Message + "\n";
}
}
else
{
failcount++;
errmsg += lstPerson.Items[i].Text.Trim() + "的手机号码非法！\n";
}
}
if (failcount > 0 || errmsg != "")
{
return(string.Format("共有{0}条短信未发送！原因如下：\n{1}", failcount, errmsg));
}
else
{
return("1");
}
}
