/// <summary> /// 添加点名表数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(QY_DIANMB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into QY_DIANMB("); strSql.Append("MINGC,DATATIME,DATAVALUE,QY_DIANBMB_FK)"); strSql.Append(" values ("); strSql.Append(":MINGC,:DATATIME,:DATAVALUE,:QY_DIANBMB_FK)"); OracleParameter[] para = { new OracleParameter(":MINGC", OracleType.VarChar, 50), new OracleParameter(":DATATIME", OracleType.DateTime), new OracleParameter(":DATAVALUE", OracleType.VarChar, 36), new OracleParameter(":QY_DIANBMB_FK", OracleType.VarChar, 36) }; para[0].Value = model.MINGC; para[1].Value = model.DATATIME; para[2].Value = model.DATAVALUE; para[3].Value = model.QY_DIANBMB_FK; int row = DbHelperOra.ExecuteSql(strSql.ToString(), para); if (row > 0) { string los = "点名表新增数据: 点名:" + model.MINGC + " " + "时间:" + model.DATATIME + " " + "值:" + model.DATAVALUE + " " + "别名外键:" + model.QY_DIANBMB_FK; logs.writelog(los); return(true); } else { logs.writelog("点名表新增数据失败"); return(false); } }
/// <summary> /// 数据添加 /// </summary> /// <param name="name">点名</param> /// <param name="shuj">数据</param> /// <param name="type">1:OPC,0:PI</param> /// <returns></returns> public bool OPCAdd(string name, string shuj, string type) { bool result = false; try { string biemid = GetIDbyBM(name); QY_DIANMB model = new QY_DIANMB(); model.DATATIME = DateTime.Now; model.DATAVALUE = shuj; model.MINGC = name; if (biemid == "") { model.QY_DIANBMB_FK = "0"; } model.QY_DIANBMB_FK = biemid; //lock lock (this) { int count = CheckCount(model.DATATIME.ToString("yyyy-MM-dd HH:mm:ss"), model.MINGC, model.DATAVALUE); if (count == 0) { QY_DIANBMB dianbm = GetDataType(name); if (dianbm.DATATYPE == "B") { if (Exists(name)) { result = Update(model); } else { result = Add(model); } } if (dianbm.DATATYPE == "S") { result = Add(model); } //if (type == "1") 取煤批次 //{ // QUMPCAdd(name, shuj); //} //else //{ // RLPCAdd(name, shuj); //} } } } catch (Exception ex) { logs.writelog("添加错误" + ex.Message); throw; } return(result); }
/// <summary> /// 更新数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(QY_DIANMB model) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("update qy_dianmb set"); strSql.Append(" MINGC=:MINGC,"); strSql.Append(" DATATIME=:DATATIME,"); strSql.Append(" DATAVALUE=:DATAVALUE"); strSql.Append(" where QY_DIANBMB_FK=:QY_DIANBMB_FK"); OracleParameter[] para = { new OracleParameter(":QY_DIANBMB_FK", OracleType.VarChar, 36), new OracleParameter(":MINGC", OracleType.VarChar, 50), new OracleParameter(":DATATIME", OracleType.DateTime), new OracleParameter(":DATAVALUE", OracleType.VarChar, 36) }; para[0].Value = model.QY_DIANBMB_FK; para[1].Value = model.MINGC; para[2].Value = model.DATATIME; para[3].Value = model.DATAVALUE; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), para); if (rows > 0) { string los = "更新点名表数据: 点名:" + model.MINGC + " " + "时间:" + model.DATATIME + " " + "值:" + model.DATAVALUE; logs.writelog(los); return(true); } else { logs.writelog("点名表没有可以更新的数据"); return(false); } } catch (Exception ex) { logs.writelog("update点名表出错" + ex.Message); throw; } }