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"); } }