/// <summary>
/// 创建相应要保存的数据类
/// </summary>
/// <returns></returns>
private List <ModelDEVRelationComm> PrepareModels()
{
try
{
Log.Info(GetType() + "->" + ApplicationCommon.GetMethodName() + "---START");
List <ModelDEVRelationComm> modelDevRelationComms = new List <ModelDEVRelationComm>();
DateTime optDateTime = DateTime.Now;
foreach (DataRow dataRow in dtRelation.Rows)
{
if (dataRow["F_CHECK"].ToString() == "1")
{
ModelDEVRelationComm model = new ModelDEVRelationComm();
//负载电源
if (cbbDevType.SelectedIndex == 0)
{
model.F_MASTER_ID = gvDevice.GetFocusedRowCellValue("F_LOADPOWER_ID").ToString();
model.F_MASTER_NAME = gvDevice.GetFocusedRowCellValue("F_LOADPOWER_NAME").ToString();
}
//负载
else if (cbbDevType.SelectedIndex == 1)
{
model.F_MASTER_ID = gvDevice.GetFocusedRowCellValue("F_LOAD_ID").ToString();
model.F_MASTER_NAME = gvDevice.GetFocusedRowCellValue("F_LOAD_NAME").ToString();
}
model.F_AFFILIATION_ID = dataRow["F_POWER_SWITCH_ID"].ToString();
model.F_CREATE_TIME = optDateTime;
//操作员
model.F_OPERATOR_ID = AppGlobal.GUserId;
//操作时间
model.F_OPERATIONTIME = optDateTime;
//是否删除
model.F_DEL = 0;
modelDevRelationComms.Add(model);
}
}
return(modelDevRelationComms);
}
catch (Exception ex)
{
Log.Error(GetType() + "->" + ApplicationCommon.GetMethodName() + "---FAILED", ex);
throw ex;
}
}
/// <summary>
/// 创建相应要保存的数据类
/// </summary>
/// <returns></returns>
private List <ModelDEVRelationComm> PrepareModels()
{
try
{
Log.Info(GetType() + "->" + ApplicationCommon.GetMethodName() + "---START");
List <ModelDEVRelationComm> modelDevRelationComms = new List <ModelDEVRelationComm>();
DateTime optDateTime = DateTime.Now;
foreach (DataRow dataRow in dtRelation.Rows)
{
if (dataRow["F_CHECK"].ToString() == "1")
{
ModelDEVRelationComm model = new ModelDEVRelationComm();
model.F_MASTER_ID = gvWorkstation.GetFocusedRowCellValue("F_WORKSTATION_ID").ToString();
model.F_MASTER_NAME = gvWorkstation.GetFocusedRowCellValue("F_WORKSTATION_NAME").ToString();
model.F_AFFILIATION_ID = dataRow["F_DEVID"].ToString();
model.F_AFFILIATION_NAME = dataRow["F_DEVNAME"].ToString();
model.F_MEMO = dataRow["F_MEMO"].ToString();
model.F_CREATE_TIME = optDateTime;
//操作员
model.F_OPERATOR_ID = AppGlobal.GUserId;
//操作时间
model.F_OPERATIONTIME = optDateTime;
//是否删除
model.F_DEL = 0;
modelDevRelationComms.Add(model);
}
}
return(modelDevRelationComms);
}
catch (Exception ex)
{
Log.Error(GetType() + "->" + ApplicationCommon.GetMethodName() + "---FAILED", ex);
throw ex;
}
}
/// <summary>
/// 保存关系
/// </summary>
/// <param name="relationType">关系类型0：下位机，1：线圈电源</param>
/// <param name="model"></param>
public void AddRelation(int relationType, ModelDEVRelationComm model)
{
try
{
Log.Info("DalDEV_LOAD_INFO->AddRelation---START");
StringBuilder strSql = new StringBuilder();
switch (relationType)
{
case 0:
{
strSql.Append(" INSERT INTO T_DEV_LOAD_TO_SUB ( ");
break;
}
case 1:
{
strSql.Append(" INSERT INTO T_DEV_COILPOWER_TO_LOAD ( ");
break;
}
}
strSql.Append(" F_LOAD_ID , ");
strSql.Append(" F_LOAD_NAME , ");
switch (relationType)
{
case 0:
{
strSql.Append(" F_SUBORDINATE_ID , ");
strSql.Append(" F_SUBORDINATE_NAME , ");
break;
}
case 1:
{
strSql.Append(" F_COILPOWER_ID , ");
strSql.Append(" F_COILPOWER_NAME , ");
break;
}
}
strSql.Append(" F_MEMO , ");
strSql.Append(" F_CREATE_TIME , ");
strSql.Append(" F_OPERATOR_ID , ");
strSql.Append(" F_OPERATIONTIME , ");
strSql.Append(" F_DEL ) ");
strSql.Append(" values (");
strSql.Append(":F_LOAD_ID,:F_LOAD_NAME,");
strSql.Append(":F_POWER_ID,");
strSql.Append(":F_POWER_NAME,");
strSql.Append(":F_MEMO,:F_CREATE_TIME,:F_OPERATOR_ID,:F_OPERATIONTIME,:F_DEL");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":F_LOAD_ID", OracleType.VarChar, 20),
new OracleParameter(":F_LOAD_NAME", OracleType.VarChar, 100),
new OracleParameter(":F_POWER_ID", OracleType.VarChar, 20),
new OracleParameter(":F_POWER_NAME", OracleType.VarChar, 100),
new OracleParameter(":F_MEMO", OracleType.VarChar, 500),
new OracleParameter(":F_CREATE_TIME", OracleType.DateTime),
new OracleParameter(":F_OPERATOR_ID", OracleType.VarChar, 10),
new OracleParameter(":F_OPERATIONTIME", OracleType.DateTime),
new OracleParameter(":F_DEL", OracleType.Number, 4)
};
if (model.F_MASTER_ID == null)
{
parameters[0].Value = DBNull.Value;
}
else
{
parameters[0].Value = model.F_MASTER_ID;
}
if (model.F_MASTER_NAME == null)
{
parameters[1].Value = DBNull.Value;
}
else
{
parameters[1].Value = model.F_MASTER_NAME;
}
if (model.F_AFFILIATION_ID == null)
{
parameters[2].Value = DBNull.Value;
}
else
{
parameters[2].Value = model.F_AFFILIATION_ID;
}
if (model.F_AFFILIATION_NAME == null)
{
parameters[3].Value = DBNull.Value;
}
else
{
parameters[3].Value = model.F_AFFILIATION_NAME;
}
if (model.F_MEMO == null)
{
parameters[4].Value = DBNull.Value;
}
else
{
parameters[4].Value = model.F_MEMO;
}
if (model.F_CREATE_TIME == null)
{
parameters[5].Value = DBNull.Value;
}
else
{
parameters[5].Value = model.F_CREATE_TIME;
}
if (model.F_OPERATOR_ID == null)
{
parameters[6].Value = DBNull.Value;
}
else
{
parameters[6].Value = model.F_OPERATOR_ID;
}
if (model.F_OPERATIONTIME == null)
{
parameters[7].Value = DBNull.Value;
}
else
{
parameters[7].Value = model.F_OPERATIONTIME;
}
if (model.F_DEL == null)
{
parameters[8].Value = DBNull.Value;
}
else
{
parameters[8].Value = model.F_DEL;
}
ExecuteSql(strSql.ToString(), parameters);
}
catch (Exception ex)
{
Log.Error("DalDEV_LOAD_INFO->AddRelation---FAILED", ex);
throw ex;
}
}
