/// <summary> /// 获取点数据类型 /// </summary> /// <param name="mingc"></param> /// <returns></returns> public QY_DIANBMB GetDataType(string mingc) { try { string sql = "select * from qy_dianbmb where mingc='" + mingc + "'"; DataTable dt = DbHelperOra.Query(sql).Tables[0]; QY_DIANBMB model = new QY_DIANBMB(); if (dt.Rows.Count != 0) { model.BEIZ = dt.Rows[0]["BEIZ"].ToString(); model.BIEM = dt.Rows[0]["BIEM"].ToString(); model.QY_DIANBMBOID = dt.Rows[0]["QY_DIANBMBOID"].ToString(); model.DATATYPE = dt.Rows[0]["DATATYPE"].ToString(); model.MINGC = dt.Rows[0]["MINGC"].ToString(); return(model); } else { return(null); } } catch (Exception ex) { logs.writelog("别名表GetDataType方法" + ex.Message); throw; } }
/// <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); }