/// <summary> /// 获取设备编码 /// </summary> /// <param name="codetype">设备类型 1是站 2是设备 3是传感器</param> public static long GetEquipmentCode(int codetype) { //最大范围值 long maxtemp = 0; if (codetype == 1) { maxtemp = 2000000000; } else if (codetype == 2) { maxtemp = 3000000000; } else if (codetype == 3) { maxtemp = 9000000000; } long code = 0; pdermsWebEntities bll = new pdermsWebEntities(); List <t_Sys_EquipmentCode> list = bll.t_Sys_EquipmentCode.Where(d => d.EquipmentCode < maxtemp).ToList(); if (list.Count > 0) { // 最大设备编码加上1 string equipmentcode = list.Max(m => m.EquipmentCode).ToString(); long ecode = Convert.ToInt64(equipmentcode.Substring(1, 9)) + 1; code = Convert.ToInt64(codetype.ToString() + ecode.ToString("000000000")); } return(code); }
public static Result smsOrderAdd(string handler, string OrderName, pdermsWebEntities bll) { try { string sql = "SELECT * FROM t_CM_UserInfo WHERE UserName='******'"; List <t_CM_UserInfo> listUsers = bll.ExecuteStoreQuery <t_CM_UserInfo>(sql).ToList(); if (listUsers != null && listUsers.Count > 0) { string mobile = listUsers.First().Mobilephone; Config config = new Config(key); Dictionary <string, string> data = new Dictionary <string, string>(); Result result = null; SmsOperator sms = new SmsOperator(config); data.Clear(); data.Add("mobile", mobile); data.Add("text", "【" + company + "】您有一个工单名称为[" + subString(OrderName) + "]的待处理工单,请及时处理!"); return(sms.singleSend(data)); } else { string rm = "{\"code\":2,\"msg\":\"" + "查找不到" + handler + "的手机号" + "\",\"count\":1,\"fee\":0.05,\"unit\":\"RMB\",\"mobile\":\"13681206520\",\"sid\":22927664130}"; return(new Result(-1, rm)); } } catch (Exception e) { string rm = "{\"code\":2,\"msg\":\"" + "发送短信出错:" + e.Message + "\",\"count\":1,\"fee\":0.05,\"unit\":\"RMB\",\"mobile\":\"13681206520\",\"sid\":22927664130}"; return(new Result(-1, rm)); } }
// 递归树形 public static string ComboPdrList(t_CM_PDRInfo model) { pdermsWebEntities bll = new pdermsWebEntities(); string res_s = ""; //你想要在视图中得到的值 res_s += "{\"id\":\"" + model.PID + "\",\"text\":\"" + model.Name + "\""; IList <t_CM_PDRInfo> list = bll.t_CM_PDRInfo.Where(c => c.ParentID == model.PID).ToList(); if (list != null && list.Count > 0) { res_s += "," + "\"children\":["; for (int i = 0; i < list.Count; i++) { if (i > 0) { res_s += ","; } res_s += ComboPdrList(list[i]); } res_s += "]"; } ; res_s += "}"; return(res_s); }
// 递归树形 public static string ComboRecursion(t_CM_Module model) { pdermsWebEntities bll = new pdermsWebEntities(); string res_s = ""; //你想要在视图中得到的值 res_s += "{\"id\":\"" + model.ModuleID + "\",\"text\":\"" + model.ModuleName + "\""; IList <t_CM_Module> list = bll.t_CM_Module.Where(c => c.ParentID == model.ModuleID && c.ModuleType != 3).ToList(); if (list != null && list.Count > 0) { res_s += "," + "\"children\":["; for (int i = 0; i < list.Count; i++) { if (i > 0) { res_s += ","; } res_s += ComboRecursion(list[i]); } res_s += "]"; } ; res_s += "}"; return(res_s); }
// 递归树形 public static string Recursion(t_CM_Module model) { pdermsWebEntities bll = new pdermsWebEntities(); string res_s = ""; //你想要在视图中得到的值 string icon = "book_open.png"; if (!string.IsNullOrEmpty(model.Icon)) { icon = model.Icon; } res_s += "{\"ModuleID\":\"" + model.ModuleID + "\",\"ModuleName\":\"" + model.ModuleName + "\",\"ParentID\":\"" + model.ParentID + "\",\"Icon\":\"" + icon + "\",\"Location\":\"" + model.Location + "\""; IList <t_CM_Module> list = bll.t_CM_Module.Where(c => c.ParentID == model.ModuleID && c.ModuleType != 3).ToList(); list = list.OrderBy(m => m.SN).ToList(); if (list != null && list.Count > 0) { res_s += "," + "\"children\":["; for (int i = 0; i < list.Count; i++) { if (i > 0) { res_s += ","; } res_s += Recursion(list[i]); } res_s += "]"; } ; res_s += "}"; return(res_s); }
public static string List2Json <T>(IList <T> list, int total, List <t_CM_PointsInfo> listPar) { pdermsWebEntities b = new pdermsWebEntities(); StringBuilder json = new StringBuilder(); //{"total":5,"rows":[ //int total = list.Count; json.Append("{\"total\":"); json.Append(total); json.Append(",\"rows\":["); for (int i = 0; i < list.Count; i++) { T obj = Activator.CreateInstance <T>(); Type type = obj.GetType(); PropertyInfo[] pis = type.GetProperties(); json.Append("{"); for (int j = 0; j < pis.Length; j++) { json.Append("\"" + pis[j].Name.ToString() + "\":\"" + pis[j].GetValue(list[i], null) + "\""); if ("TagID" == pis[j].Name.ToString()) { int tagid = Convert.ToInt32(pis[j].GetValue(list[i], null)); var pointInf = listPar.Where(o => o.TagID == tagid); if (pointInf.Count() > 0) { t_CM_PointsInfo poinf = pointInf.First(); json.Append(","); json.Append("\"" + "TagName" + "\":\"" + poinf.TagName + "\""); json.Append(","); json.Append("\"" + "Remarks" + "\":\"" + poinf.Remarks + "\""); b.t_DM_CircuitInfo.Where(p => p.CID == poinf.CID).FirstOrDefault(); if (b.t_DM_CircuitInfo.Where(p => p.CID == poinf.CID).FirstOrDefault() != null) { json.Append(","); json.Append("\"" + "CName" + "\":\"" + b.t_DM_CircuitInfo.Where(p => p.CID == poinf.CID && p.PID == poinf.PID).FirstOrDefault().CName + "\""); } else { json.Append(","); json.Append("\"" + "CName" + "\":\"--\""); } } } if (j < pis.Length - 1) { json.Append(","); } } json.Append("}"); if (i < list.Count - 1) { json.Append(","); } } json.Append("]}"); return(json.ToString()); }
//获取事项列表 public ActionResult GetDefaultTemp(int type) { List <t_ES_DefaultTemplet> list = new List <t_ES_DefaultTemplet>(); using (var bll = new pdermsWebEntities()) { list = bll.t_ES_DefaultTemplet.Where(p => p.Type == type).ToList(); } return(Json(list)); }
/// <summary> /// 记录日志 /// </summary> /// <param name="logType">日志类型</param> /// <param name="username">操作人</param> /// <param name="contents">日志描述</param> public static void InsertLog(string logType, string username, string contents) { pdermsWebEntities bll = new pdermsWebEntities(); t_CM_Log log = new t_CM_Log(); log.LogDate = DateTime.Now; log.LogType = logType; log.UserName = username; log.Contents = contents; log.IPAddress = "";// GetIPAddress(); bll.t_CM_Log.AddObject(log); bll.SaveChanges(); }
public static void smsOrderCancel(string handler, string OrderName, pdermsWebEntities bll) { try { string sql = "SELECT * FROM t_CM_UserInfo WHERE UserName='******'"; List <t_CM_UserInfo> listUsers = bll.ExecuteStoreQuery <t_CM_UserInfo>(sql).ToList(); if (listUsers != null && listUsers.Count > 0) { string mobile = listUsers.First().Mobilephone; Config config = new Config(key); Dictionary <string, string> data = new Dictionary <string, string>(); SmsOperator sms = new SmsOperator(config); data.Clear(); data.Add("mobile", mobile); data.Add("text", "【" + company + "】您的一个待处理工单[" + subString(OrderName) + "],已取消!"); sms.singleSend(data); } }catch (Exception e) { } }
public static List <T> SelectPageList <T>(string tbName, int pageIndex, int pagesize, string orderByField, ref int totalCount, int orderby, string strWhere, string SelectFieldName) where T : class { pdermsWebEntities bll = new pdermsWebEntities(); SqlParameter[] spm = new SqlParameter[5]; spm[0] = new SqlParameter("@tblName", tbName); spm[1] = new SqlParameter("@SelectFieldName", SelectFieldName); spm[2] = new SqlParameter("@strWhere", strWhere); spm[3] = new SqlParameter("@OrderFieldName", orderByField); spm[4] = new SqlParameter("@PageSize", pagesize); spm[5] = new SqlParameter("@PageIndex", pageIndex); spm[6] = new SqlParameter("@iRowCount", totalCount); spm[7] = new SqlParameter("@OrderType", orderby); spm[7].Direction = ParameterDirection.Output; var data = bll.ExecuteStoreQuery <T>("exec AspNetPage @tblName,@SelectFieldName,@strWhere,@OrderByField,@PageSize,@PageIndex,@iRowCount out,@OrderType", spm).ToList(); totalCount = Convert.ToInt32(spm[4].Value.ToString()); return(data); }
public static string doImport2003(DataSet tDS, int Mode) { StringBuilder Result = new StringBuilder(); string TagIDs = ""; int errorCount = 0; try { pdermsWebEntities bll = new pdermsWebEntities(); //检验excel表格中的数据是否符合格式 //检查列数是否与数据库一致 if (tDS.Tables[0].Columns.Count == 42) { for (int i = 0; i < tDS.Tables[0].Rows.Count; i++) { string MDate = tDS.Tables[0].Rows[i][1].ToString(); string Val = tDS.Tables[0].Rows[i][2].ToString(); for (int j = 0; j < tDS.Tables[0].Columns.Count; j++) { //检查TagID if (tDS.Tables[0].Rows[i][0].ToString() == "") { Result.Append("错误:第" + i + "列,缺少TagID。<br>"); errorCount++; } else { TagIDs += tDS.Tables[0].Rows[i][0].ToString() + ","; } //检查DID if (tDS.Tables[0].Rows[i][2].ToString() == "") { Result.Append("错误:第" + i + "列,缺少DID。<br>"); errorCount++; } //检查实时库索引 if (tDS.Tables[0].Rows[i][14].ToString() == "") { Result.Append("错误:第" + i + "列,缺少实时库索引。<br>"); errorCount++; } //检查PID if (tDS.Tables[0].Rows[i][15].ToString() == "") { Result.Append("错误:第" + i + "列,缺少PID。<br>"); errorCount++; } } } } else { Result.Append("错误:列数错误。\r"); errorCount++; } string pointSQL = "SELECT * FROM t_CM_PointsInfo WHERE TagID in (" + TagIDs.TrimEnd(',') + ")"; List <t_CM_PointsInfo> list = bll.ExecuteStoreQuery <t_CM_PointsInfo>(pointSQL).ToList(); if (list.Count > 0) { //覆盖模式下删除重复数据 if (Mode > 0) { list.ForEach(i => { bll.AttachTo("t_CM_PointsInfo", i); bll.t_CM_PointsInfo.DeleteObject(i); }); bll.SaveChanges(); } else { foreach (t_CM_PointsInfo p in list) { Result.Append("错误:数据库中已经存在 TagID = " + p.TagID + "的行。<br>"); errorCount++; } } } StringBuilder strSQL = new StringBuilder(); if (errorCount < 1) { //关闭标识 strSQL.Append("set IDENTITY_INSERT t_CM_PointsInfo ON "); //插入数据库 for (int i = 0; i < tDS.Tables[0].Rows.Count; i++) { strSQL.Append("insert into t_CM_PointsInfo (TagID,TagName,DID,DataTypeID,Position,MPID,UseState,PIOID,ABCID,Remarks,数据类型,设备点名,中文描述,站内点号,实时库索引,PID,通信地址,例外报告死区,工程下限,工程上限,码值下限,码值上限,远动数据类型,报警下限1,报警上限1,报警定义,置0说明,置1说明,单位,分组,最大间隔时间,小信号切除值,报警下限2,报警上限2,报警下限3,报警上限3,报警死区,报警级别,报警方式,速率报警限制,初始值,传感器SN编码) "); strSQL.Append("values (" + "" + tDS.Tables[0].Rows[i][0] + "," + "'" + tDS.Tables[0].Rows[i][1] + "'," + "" + tDS.Tables[0].Rows[i][2] + "," + "" + tDS.Tables[0].Rows[i][3] + "," + "'" + tDS.Tables[0].Rows[i][4] + "'," + "" + tDS.Tables[0].Rows[i][5] + "," + "" + tDS.Tables[0].Rows[i][6] + "," + "" + tDS.Tables[0].Rows[i][7] + "," + "" + tDS.Tables[0].Rows[i][8] + "," + "'" + tDS.Tables[0].Rows[i][9] + "'," + "'" + tDS.Tables[0].Rows[i][10] + "'," + "'" + tDS.Tables[0].Rows[i][11] + "'," + "'" + tDS.Tables[0].Rows[i][12] + "'," + "'" + tDS.Tables[0].Rows[i][13] + "'," + "" + tDS.Tables[0].Rows[i][14] + "," + "" + tDS.Tables[0].Rows[i][15] + "," + "" + tDS.Tables[0].Rows[i][16] + "," + "" + tDS.Tables[0].Rows[i][17] + "," + "" + tDS.Tables[0].Rows[i][18] + "," + "" + tDS.Tables[0].Rows[i][19] + "," + "" + tDS.Tables[0].Rows[i][20] + "," + "" + tDS.Tables[0].Rows[i][21] + "," + "'" + tDS.Tables[0].Rows[i][22] + "'," + "" + tDS.Tables[0].Rows[i][23] + "," + "" + tDS.Tables[0].Rows[i][24] + "," + "" + tDS.Tables[0].Rows[i][25] + "," + "'" + tDS.Tables[0].Rows[i][26] + "'," + "'" + tDS.Tables[0].Rows[i][27] + "'," + "'" + tDS.Tables[0].Rows[i][28] + "'," + "" + tDS.Tables[0].Rows[i][29] + "," + "" + tDS.Tables[0].Rows[i][30] + "," + "" + tDS.Tables[0].Rows[i][31] + "," + "" + tDS.Tables[0].Rows[i][32] + "," + "" + tDS.Tables[0].Rows[i][33] + "," + "" + tDS.Tables[0].Rows[i][34] + "," + "" + tDS.Tables[0].Rows[i][35] + "," + "" + tDS.Tables[0].Rows[i][36] + "," + "" + tDS.Tables[0].Rows[i][37] + "," + "" + tDS.Tables[0].Rows[i][38] + "," + "" + tDS.Tables[0].Rows[i][39] + "," + "" + tDS.Tables[0].Rows[i][40] + "," + "'" + tDS.Tables[0].Rows[i][41] + "')"); } strSQL.Append("set IDENTITY_INSERT t_CM_PointsInfo OFF"); bll.ExecuteStoreCommand(strSQL.ToString()); Result.Append("OK"); } return(Result.ToString()); } catch (Exception e) { string a = e.ToString(); return(a); } }