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