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