public ADeeWu.HuoBi3J.Model.Coupons_CashWhenFee_Code GetEntity(string where) { DataTable dt = this.Select(where,""); if(dt.Rows.Count==0) return null; DataRow dr = dt.Rows[0]; ADeeWu.HuoBi3J.Model.Coupons_CashWhenFee_Code Entity = new ADeeWu.HuoBi3J.Model.Coupons_CashWhenFee_Code(); Entity.ID = int.Parse(dr["ID"].ToString()); Entity.Fee = dr["Fee"] as decimal?; Entity.Money = dr["Money"] as decimal?; Entity.Count = dr["Count"] as int?; Entity.UseCount = dr["UseCount"] as int?; Entity.UserID = dr["UserID"] as int?; Entity.SaleManUserID = dr["SaleManUserID"] as int?; Entity.StartDate = dr["StartDate"] as DateTime?; Entity.EndDate = dr["EndDate"] as DateTime?; Entity.CreateTime = dr["CreateTime"] as DateTime?; Entity.OriginalMoney = decimal.Parse(dr["OriginalMoney"].ToString()); Entity.ParentCodeID = int.Parse(dr["ParentCodeID"].ToString()); return Entity; }
public ADeeWu.HuoBi3J.Model.Coupons_CashWhenFee_Code[] GetEntityList(string orderBy,string[] columns,params object[] values) { StringBuilder builder = new StringBuilder(); builder.Append("select * from [Coupons_CashWhenFee_Code] where 1=1"); db.Parameters.Clear(); for(int i=0;i<columns.Length;i++) { builder.AppendFormat(" and [{0}]=@{0}", columns[i]); db.Parameters.Append("@"+columns[i],values[i]); } if (!string.IsNullOrEmpty(orderBy)) { builder.AppendFormat(" order by {0}", orderBy); } DataTable dt = db.Select(builder.ToString()); ADeeWu.HuoBi3J.Model.Coupons_CashWhenFee_Code[] EntityList = new ADeeWu.HuoBi3J.Model.Coupons_CashWhenFee_Code[dt.Rows.Count]; if (dt.Rows.Count == 0) return EntityList; for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; ADeeWu.HuoBi3J.Model.Coupons_CashWhenFee_Code Entity = new ADeeWu.HuoBi3J.Model.Coupons_CashWhenFee_Code(); Entity.ID = int.Parse(dr["ID"].ToString()); Entity.Fee = dr["Fee"] as decimal?; Entity.Money = dr["Money"] as decimal?; Entity.Count = dr["Count"] as int?; Entity.UseCount = dr["UseCount"] as int?; Entity.UserID = dr["UserID"] as int?; Entity.SaleManUserID = dr["SaleManUserID"] as int?; Entity.StartDate = dr["StartDate"] as DateTime?; Entity.EndDate = dr["EndDate"] as DateTime?; Entity.CreateTime = dr["CreateTime"] as DateTime?; Entity.OriginalMoney = decimal.Parse(dr["OriginalMoney"].ToString()); Entity.ParentCodeID = dr["ParentCodeID"].ToInt(); EntityList[i] = Entity; } return EntityList; }
public ADeeWu.HuoBi3J.Model.Coupons_CashWhenFee_Code GetEntity(int ID) { db.Parameters.Clear(); db.Parameters.Append("@ID",ID); DataTable dt = db.Select("select * from [Coupons_CashWhenFee_Code] where 1=1 and [ID]=@ID"); if(dt.Rows.Count==0) return null; DataRow dr = dt.Rows[0]; ADeeWu.HuoBi3J.Model.Coupons_CashWhenFee_Code Entity = new ADeeWu.HuoBi3J.Model.Coupons_CashWhenFee_Code(); Entity.ID = int.Parse(dr["ID"].ToString()); Entity.Fee = dr["Fee"] as decimal?; Entity.Money = dr["Money"] as decimal?; Entity.Count = dr["Count"] as int?; Entity.UseCount = dr["UseCount"] as int?; Entity.UserID = dr["UserID"] as int?; Entity.SaleManUserID = dr["SaleManUserID"] as int?; Entity.StartDate = dr["StartDate"] as DateTime?; Entity.EndDate = dr["EndDate"] as DateTime?; Entity.CreateTime = dr["CreateTime"] as DateTime?; Entity.OriginalMoney = decimal.Parse(dr["OriginalMoney"].ToString()); Entity.ParentCodeID = dr["ParentCodeID"].ToInt(); return Entity; }