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