/// <summary> /// 获取设备类型下拉列表 /// </summary> /// <returns></returns> public APIResult GetMeterTypeComBox() { APIResult rst = new APIResult(); try { DataTable dtSource = XMLCofig.GetDrive(); var res1 = from s1 in dtSource.AsEnumerable() select new { Id = CommFunc.ConvertDBNullToString(s1["type"]), Text = CommFunc.ConvertDBNullToString(s1["type"]), }; rst.Code = 0; rst.Msg = ""; rst.Data = new { total = dtSource.Rows.Count, rows = res1.ToList() }; } catch (Exception ex) { rst.Code = -1; rst.Msg = ex.Message; FileLog.WriteLog("获取设备类型数据信息错误(GetModuleTypeData):" + ex.Message + ex.StackTrace); } return(rst); }
/// <summary> /// 获取设备类型采集码列表 /// </summary> /// <returns></returns> public APIResult GetMmFunTypeList(int mm_id) { APIResult rst = new APIResult(); try { string moduleType = bll.GetMmType(mm_id); DataTable dtSource = XMLCofig.GetDrive(moduleType); dtSource.Columns.Add("Fun_id", typeof(System.Int32)); dtSource.Columns.Add("Mm_id", typeof(System.Int32)); dtSource.Columns.Add("DataValue", typeof(System.String)); dtSource.Columns.Add("Disabled", typeof(System.Int32)); DataTable dtDb = bll.GetMmFunTypeList(mm_id); foreach (DataRow dr in dtSource.Rows) { dr["Fun_id"] = 0; dr["Mm_id"] = mm_id; foreach (DataRow drDb in dtDb.Select("FunType='" + CommFunc.ConvertDBNullToString(dr["FunType"]) + "'")) { dr["Fun_id"] = drDb["Fun_id"]; dr["DataValue"] = drDb["DataValue"]; dr["Disabled"] = drDb["Disabled"]; } } var res1 = from s1 in dtSource.AsEnumerable() select new { RowId = dtSource.Rows.IndexOf(s1) + 1, Fun_id = CommFunc.ConvertDBNullToInt32(s1["Fun_id"]), Mm_id = CommFunc.ConvertDBNullToInt32(s1["Mm_id"]), FunName = CommFunc.ConvertDBNullToString(s1["FunName"]), FunType = CommFunc.ConvertDBNullToString(s1["FunType"]), Disabled = CommFunc.ConvertDBNullToInt32(s1["Disabled"]), }; rst.Code = 0; rst.Msg = ""; rst.Data = new { total = dtSource.Rows.Count, rows = res1.ToList() }; } catch (Exception ex) { rst.Code = -1; rst.Msg = ex.Message; FileLog.WriteLog("获取设备类型采集码列表信息错误(GetMmFunTypeList):" + ex.Message + ex.StackTrace); } return(rst); }
private DataTable GetMmFunTypeList(int mm_id, string moduleType) { DataTable dtSource = XMLCofig.GetDrive(moduleType); dtSource.Columns.Add("Fun_id", typeof(System.Int32)); dtSource.Columns.Add("Mm_id", typeof(System.Int32)); dtSource.Columns.Add("DataValue", typeof(System.String)); dtSource.Columns.Add("Disabled", typeof(System.Int32)); DataTable dtDb = bll.GetMmFunTypeList(mm_id); foreach (DataRow dr in dtSource.Rows) { dr["Fun_id"] = 0; dr["Mm_id"] = mm_id; foreach (DataRow drDb in dtDb.Select("FunType='" + CommFunc.ConvertDBNullToString(dr["FunType"]) + "'")) { dr["Fun_id"] = drDb["Fun_id"]; dr["DataValue"] = drDb["DataValue"]; dr["Disabled"] = drDb["Disabled"]; } } return(dtSource); }
/// <summary> /// 修改设备型号 /// </summary> /// <returns></returns> public APIRst GetYdModelsOfEditOnModelList() { APIRst rst = new APIRst(); try { DataTable dt = XMLCofig.GetDrive(); var dtsource = from s1 in dt.AsEnumerable() select new { id = CommFunc.ConvertDBNullToString(s1["type"]), text = CommFunc.ConvertDBNullToString(s1["type"]), }; rst.data = dtsource.ToList(); } catch (Exception ex) { rst.rst = false; rst.err.code = (int)ResultCodeDefine.Error; rst.err.msg = ex.Message; FileLog.WriteLog("获取充值参数信息错误:" + ex.Message + ex.StackTrace); } return(rst); }
/// <summary> /// 获取采集信息 /// </summary> /// <param name="mm_id">类型ID号</param> /// <param name="ModuleType">设备类型</param> /// <returns></returns> public APIRst GetYdModelsOfEditOnList(int mm_id, string ModuleType) { APIRst rst = new APIRst(); try { DataTable dtSource = XMLCofig.GetDrive(ModuleType); dtSource.Clear(); dtSource.Columns.Add("RowId", typeof(System.Int32)); dtSource.Columns.Add("Fun_id", typeof(System.Int32)); dtSource.Columns.Add("Mm_id", typeof(System.Int32)); dtSource.Columns.Add("DataValue", typeof(System.String)); dtSource.Columns.Add("Disabled", typeof(System.Int32)); DataTable dtDb = bll.GetYdModelsOfEditOnList(mm_id); int rowId = 0; foreach (DataRow dr in dtSource.Rows) { dr["RowId"] = ++rowId; dr["Fun_id"] = 0; dr["Mm_id"] = mm_id; foreach (DataRow drDb in dtDb.Select("FunType='" + CommFunc.ConvertDBNullToString(dr["FunType"]) + "'")) { drDb["nAct"] = 2; dr["Fun_id"] = drDb["Fun_id"]; dr["FunName"] = drDb["FunName"]; dr["DataValue"] = drDb["DataValue"]; dr["Disabled"] = drDb["Disabled"]; } } foreach (DataRow dr in dtDb.Select("nAct=0")) { DataRow addDr = dtSource.NewRow(); addDr["RowId"] = ++rowId; addDr["Type"] = ModuleType; foreach (DataColumn dc in dtDb.Columns) { if (dtSource.Columns.Contains(dc.ColumnName)) { addDr[dc.ColumnName] = dr[dc.ColumnName]; } } dtSource.Rows.Add(addDr); } int total = dtSource.Rows.Count; var res1 = from s1 in dtSource.AsEnumerable() select new { RowId = CommFunc.ConvertDBNullToInt32(s1["RowId"]), Fun_id = CommFunc.ConvertDBNullToInt32(s1["Fun_id"]), Mm_id = CommFunc.ConvertDBNullToInt32(s1["Mm_id"]), FunName = CommFunc.ConvertDBNullToString(s1["FunName"]), FunType = CommFunc.ConvertDBNullToString(s1["FunType"]), DataValue = CommFunc.ConvertDBNullToString(s1["DataValue"]), Disabled = CommFunc.ConvertDBNullToInt32(s1["Disabled"]), Action = CommFunc.ConvertDBNullToInt32(s1["Action"]), DataType = CommFunc.ConvertDBNullToInt32(s1["DataType"]), Scale = CommFunc.ConvertDBNullToInt32(s1["Scale"]), OrdNo = CommFunc.ConvertDBNullToInt32(s1["OrdNo"]), @checked = CommFunc.ConvertDBNullToInt32(s1["Disabled"]), Protocol = CommFunc.ConvertDBNullToString(s1["Protocol"]), OrdGrp = CommFunc.ConvertDBNullToInt32(s1["OrdGrp"]), Unit = CommFunc.ConvertDBNullToString(s1["Unit"]), PointType = CommFunc.ConvertDBNullToInt32(s1["PointType"]), AlarmModel = CommFunc.ConvertDBNullToInt32(s1["AlarmModel"]), SubTab = CommFunc.ConvertDBNullToString(s1["SubTab"]), }; rst.data = res1.ToList(); } catch (Exception ex) { rst.rst = false; rst.err.code = (int)ResultCodeDefine.Error; rst.err.msg = ex.Message; FileLog.WriteLog("获取充值参数信息错误:" + ex.Message + ex.StackTrace); } return(rst); }