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