/// <summary>
/// 得到一个对象实体，从缓存中
/// </summary>
public TDTK.PlatForm.MVC4.Model.TT_BadRecord GetModelByCache(string RecordID)
{
TT_BadRecord tb = new TT_BadRecord();
tb.RecordID = RecordID;
string CacheKey = "TT_BadRecordModel-" + RecordID;
object objModel = Maticsoft.Common.DataCache.GetCache(CacheKey);
if (objModel == null)
{
try
{
objModel = dal.GetModel(tb);
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_BadRecord)objModel;
}
public bool Delete(TT_BadRecord t)
{
return dal.Delete(t);
}
public TT_BadRecord GetModel(TT_BadRecord t)
{
return dal.GetModel(t);
}
public bool Update(TT_BadRecord t)
{
return dal.Update(t);
}
public int Add(TT_BadRecord t)
{
return dal.Add(t);
}
public bool Exists(TT_BadRecord t)
{
return dal.Exists(t);
}
public Model.TT_BadRecord DataRowToModel(System.Data.DataRow row)
{
TDTK.PlatForm.MVC4.Model.TT_BadRecord model = new TDTK.PlatForm.MVC4.Model.TT_BadRecord();
if (row != null)
{
if (row["RecordID"] != null)
{
model.RecordID = row["RecordID"].ToString();
}
if (row["NavicertCode"] != null)
{
model.NavicertCode = row["NavicertCode"].ToString();
}
if (row["RoomCode"] != null)
{
model.RoomCode = row["RoomCode"].ToString();
}
if (row["CarNo"] != null)
{
model.CarNo = row["CarNo"].ToString();
}
if (row["Decript"] != null)
{
model.Decript = row["Decript"].ToString();
}
if (row["BreakDate"] != null && row["BreakDate"].ToString() != "")
{
model.BreakDate = DateTime.Parse(row["BreakDate"].ToString());
}
if (row["AlarmType"] != null)
{
model.AlarmType = row["AlarmType"].ToString();
}
if (row["AlarmStatus"] != null)
{
model.AlarmStatus = row["AlarmStatus"].ToString();
}
if (row["CollCode"] != null)
{
model.CollCode = row["CollCode"].ToString();
}
if (row["FrontImage"] != null)
{
model.FrontImage = row["FrontImage"].ToString();
}
if (row["BackImage"] != null)
{
model.BackImage = row["BackImage"].ToString();
}
if (row["UpImage"] != null)
{
model.UpImage = row["UpImage"].ToString();
}
if (row["RoomImage"] != null)
{
model.RoomImage = row["RoomImage"].ToString();
}
}
return model;
}
public Model.TT_BadRecord GetModel(Model.TT_BadRecord t)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 RecordID,NavicertCode,RoomCode,CarNo,Decript,BreakDate,AlarmType,AlarmStatus,CollCode,FrontImage,BackImage,UpImage,RoomImage from TT_BadRecord ");
strSql.Append(" where RecordID=@RecordID ");
SqlParameter[] parameters = {
new SqlParameter("@RecordID", SqlDbType.VarChar,32) };
parameters[0].Value = t.RecordID;
TDTK.PlatForm.MVC4.Model.TT_BadRecord model = new TDTK.PlatForm.MVC4.Model.TT_BadRecord();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
