/// <summary> /// 得到一个对象实体 /// </summary> public XCLCMS.Data.Model.View.v_Merchant GetModel(long MerchantID) { XCLCMS.Data.Model.View.v_Merchant model = new XCLCMS.Data.Model.View.v_Merchant(); Database db = base.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand("select * from v_Merchant WITH(NOLOCK) where MerchantID=@MerchantID"); db.AddInParameter(dbCommand, "MerchantID", DbType.Int64, MerchantID); using (var dr = db.ExecuteReader(dbCommand)) { return(XCLNetTools.DataSource.DataReaderHelper.DataReaderToEntity <XCLCMS.Data.Model.View.v_Merchant>(dr)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public XCLCMS.Data.Model.View.v_Merchant GetModel(long MerchantID) { XCLCMS.Data.Model.View.v_Merchant model = new XCLCMS.Data.Model.View.v_Merchant(); Database db = base.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand("select * from v_Merchant where MerchantID=@MerchantID"); db.AddInParameter(dbCommand, "MerchantID", DbType.Int64, MerchantID); DataSet ds = db.ExecuteDataSet(dbCommand); var lst = XCLNetTools.Generic.ListHelper.DataTableToList <XCLCMS.Data.Model.View.v_Merchant>(ds.Tables[0]); return(null != lst && lst.Count > 0 ? lst[0] : null); }