/// <summary>
/// 得到一个对象实体，从缓存中
/// </summary>
public TDTK.PlatForm.MVC4.Model.TT_WaterBook GetModelByCache(string CollCode, int JournalCode)
{
TT_WaterBook wb = new TT_WaterBook();
wb.CollCode = CollCode;
wb.JournalCode = JournalCode;
string CacheKey = "TT_WaterBookModel-" + CollCode + JournalCode;
object objModel = Maticsoft.Common.DataCache.GetCache(CacheKey);
if (objModel == null)
{
try
{
objModel = dal.GetModel(wb);
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_WaterBook)objModel;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TDTK.PlatForm.MVC4.Model.TT_WaterBook DataRowToModel(DataRow row)
{
TDTK.PlatForm.MVC4.Model.TT_WaterBook model = new TDTK.PlatForm.MVC4.Model.TT_WaterBook();
if (row != null)
{
if (row["TradeCode"] != null)
{
model.TradeCode = row["TradeCode"].ToString();
}
if (row["CollCode"] != null)
{
model.CollCode = row["CollCode"].ToString();
}
if (row["JournalCode"] != null && row["JournalCode"].ToString() != "")
{
model.JournalCode = int.Parse(row["JournalCode"].ToString());
}
if (row["StartMoney"] != null && row["StartMoney"].ToString() != "")
{
model.StartMoney = decimal.Parse(row["StartMoney"].ToString());
}
if (row["TradeMoney"] != null && row["TradeMoney"].ToString() != "")
{
model.TradeMoney = decimal.Parse(row["TradeMoney"].ToString());
}
if (row["EndMoney"] != null && row["EndMoney"].ToString() != "")
{
model.EndMoney = decimal.Parse(row["EndMoney"].ToString());
}
if (row["Operator"] != null)
{
model.Operator = row["Operator"].ToString();
}
if (row["TradeDate"] != null && row["TradeDate"].ToString() != "")
{
model.TradeDate = DateTime.Parse(row["TradeDate"].ToString());
}
if (row["TradeKind"] != null)
{
model.TradeKind = row["TradeKind"].ToString();
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["WeightCode"] != null)
{
model.WeightCode = row["WeightCode"].ToString();
}
if (row["AuditUser"] != null)
{
model.AuditUser = row["AuditUser"].ToString();
}
if (row["AuditDate"] != null && row["AuditDate"].ToString() != "")
{
model.AuditDate = DateTime.Parse(row["AuditDate"].ToString());
}
}
return model;
}
public Model.TT_WaterBook GetModel(Model.TT_WaterBook t)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 TradeCode,CollCode,JournalCode,StartMoney,TradeMoney,EndMoney,Operator,TradeDate,TradeKind,Remark,WeightCode,AuditUser,AuditDate from TT_WaterBook ");
strSql.Append(" where CollCode=@CollCode and JournalCode=@JournalCode ");
SqlParameter[] parameters = {
new SqlParameter("@CollCode", SqlDbType.VarChar,10),
new SqlParameter("@JournalCode", SqlDbType.Int,4) };
parameters[0].Value =t.CollCode;
parameters[1].Value =t.JournalCode;
TDTK.PlatForm.MVC4.Model.TT_WaterBook model = new TDTK.PlatForm.MVC4.Model.TT_WaterBook();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
public TT_WaterBook GetModel(TT_WaterBook t)
{
return dal.GetModel(t);
}
public bool Delete(TT_WaterBook t)
{
return dal.Delete(t);
}
public bool Update(TT_WaterBook t)
{
return dal.Update(t);
}
public int Add(TT_WaterBook t)
{
return dal.Add(t);
}
public bool Exists(TT_WaterBook t)
{
return dal.Exists(t);
}
