/// <summary>
/// 通过主键得到实体对象
/// </summary>
/// <param name="MainID">主键</param>
/// <param name="SetSnapShot">是否设置测点实时值</param>
/// <returns></returns>
public static bool Delete(string TagID)
{
Race_TagEntity entity = new Race_TagEntity();
string sql = "select * from Race_Tag where TagID='{0}'";
sql = string.Format(sql, TagID);
DataTable dt = DBAccess.GetRelation().ExecuteDataset(sql).Tables[0];
if (dt.Rows.Count > 0)
{
entity.DrToMember(dt.Rows[0]);
}
return(Race_TagDal.Delete(entity));
}
/// <summary>
///
/// </summary>
/// <param name="UnitID"></param>
/// <returns></returns>
public static DataTable GetSearchListC(string UnitID, string StartTime, string EndTime)
{
DataTable dt = null;
string WorkID = KPI_UnitDal.GetWorkIDByID(UnitID);
DataTable dtItems = Race_TagDal.GetTags(UnitID);
if (dtItems == null && dtItems.Rows.Count <= 0)
{
return(dt);
}
string condition = "";
for (int i = 0; i < dtItems.Rows.Count; i++)
{
string ItemID = dtItems.Rows[i]["TagID"].ToString();
string ItemDesc = dtItems.Rows[i]["TagDesc"].ToString();
string ItemEngunit = dtItems.Rows[i]["TagEngunit"].ToString();
condition += "cast(avg(case TagID when '" + ItemID + "' then TagValue else null end) as numeric(18,4)) as '" + ItemDesc + "[" + ItemEngunit + "]', ";
}
condition = condition.Remove(condition.LastIndexOf(','));
string where = " where UnitID= '" + UnitID + "' and TagStartTime >='" + StartTime + "' and TagStartTime <'" + EndTime + "'";
string sql = @"select TagShift As '运行值', {0}
from Race_Archive
{1}
group by TagShift";
sql = string.Format(sql, condition, where);
dt = DBAccess.GetRelation().ExecuteDataset(sql).Tables[0];
return(dt);
}