/// <summary> /// 得到一个对象实体,从缓存中 /// </summary> public TDTK.PlatForm.MVC4.Model.TT_Room GetModelByCache(string RoomCode) { TT_Room r = new TT_Room(); r.RoomCode = RoomCode; string CacheKey = "TT_RoomModel-" + RoomCode; object objModel = Maticsoft.Common.DataCache.GetCache(CacheKey); if (objModel == null) { try { objModel = dal.GetModel(r); if (objModel != null) { int ModelCache = Maticsoft.Common.ConfigHelper.GetConfigInt("ModelCache"); Maticsoft.Common.DataCache.SetCache(CacheKey, objModel, DateTime.Now.AddMinutes(ModelCache), TimeSpan.Zero); } } catch { } } return (TDTK.PlatForm.MVC4.Model.TT_Room)objModel; }
public bool Delete(TT_Room t) { return dal.Delete(t); }
public TT_Room GetModel(TT_Room t) { return dal.GetModel(t); }
public bool Update(TT_Room t) { return dal.Update(t); }
public int Add(TT_Room t) { return dal.Add(t); }
public bool Exists(TT_Room t) { return dal.Exists(t); }
public Model.TT_Room DataRowToModel(DataRow row) { TDTK.PlatForm.MVC4.Model.TT_Room model = new TDTK.PlatForm.MVC4.Model.TT_Room(); if (row != null) { if (row["RoomCode"] != null) { model.RoomCode = row["RoomCode"].ToString(); } if (row["VillageCode"] != null) { model.VillageCode = row["VillageCode"].ToString(); } if (row["RoomName"] != null) { model.RoomName = row["RoomName"].ToString(); } if (row["Principal"] != null) { model.Principal = row["Principal"].ToString(); } if (row["Telephone"] != null) { model.Telephone = row["Telephone"].ToString(); } if (row["TransportModel"] != null) { model.TransportModel = row["TransportModel"].ToString(); } if (row["RoomType"] != null) { model.RoomType = row["RoomType"].ToString(); } if (row["RoomIp"] != null) { model.RoomIp = row["RoomIp"].ToString(); } if (row["OnOff"] != null) { model.OnOff = row["OnOff"].ToString(); } if (row["OffLineTime"] != null && row["OffLineTime"].ToString() != "") { model.OffLineTime = decimal.Parse(row["OffLineTime"].ToString()); } if (row["OffLineBegin"] != null && row["OffLineBegin"].ToString() != "") { model.OffLineBegin = DateTime.Parse(row["OffLineBegin"].ToString()); } if (row["CollCode"] != null) { model.CollCode = row["CollCode"].ToString(); } if (row["IsForbid"] != null) { model.IsForbid = row["IsForbid"].ToString(); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } } return model; }
public Model.TT_Room GetModel(Model.TT_Room t) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 RoomCode,VillageCode,RoomName,Principal,Telephone,TransportModel,RoomType,RoomIp,OnOff,OffLineTime,OffLineBegin,CollCode,IsForbid,Remark from TT_Room "); strSql.Append(" where RoomCode=@RoomCode "); SqlParameter[] parameters = { new SqlParameter("@RoomCode", SqlDbType.VarChar,10) }; parameters[0].Value = t.RoomCode; TDTK.PlatForm.MVC4.Model.TT_Room model = new TDTK.PlatForm.MVC4.Model.TT_Room(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }