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