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