/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static DeliverTypeEntity GetEntityFromrdr(NullableDataReader rdr) { DeliverTypeEntity info = new DeliverTypeEntity(); info.TypeID = rdr.GetInt32("TypeID"); info.TypeName = rdr.GetString("TypeName"); info.Intro = rdr.GetString("Intro"); info.ChargeType = rdr.GetInt32("ChargeType"); info.IsDefault = rdr.GetBoolean("IsDefault"); info.IsDisabled = rdr.GetBoolean("IsDisabled"); info.OrderSort = rdr.GetInt32("OrderSort"); info.ReleaseType = rdr.GetInt32("ReleaseType"); info.MinMoney1 = rdr.GetDecimal("MinMoney1"); info.ReleaseCharge = rdr.GetDecimal("ReleaseCharge"); info.Minmoney2 = rdr.GetDecimal("Minmoney2"); info.MaxCharge = rdr.GetDecimal("MaxCharge"); info.MinMoney3 = rdr.GetDecimal("MinMoney3"); info.Charge_Min = rdr.GetDecimal("Charge_Min"); info.Charge_Max = rdr.GetDecimal("Charge_Max"); info.Charge_Percent = rdr.GetInt16("Charge_Percent"); info.IncludeTax = rdr.GetInt32("IncludeTax"); info.TaxRate = rdr.GetDouble("TaxRate"); info.StoreID = rdr.GetInt32("StoreID"); return(info); }
/// <summary> /// 增加一条记录,返回新的ID号。需要有一个单一主键,并且开启有标识符属性(异步方式) /// </summary> /// <param name="entity">实体模型</param> /// <returns></returns> public virtual async Task <int> InsertAsync(DeliverTypeEntity entity) { if (entity.TypeID <= 0) { entity.TypeID = GetNewID(); } Dictionary <string, object> dict = new Dictionary <string, object>(); GetParameters(entity, dict); string strSQL = "insert into DeliverType (" + "TypeID," + "TypeName," + "Intro," + "ChargeType," + "IsDefault," + "IsDisabled," + "OrderSort," + "ReleaseType," + "MinMoney1," + "ReleaseCharge," + "Minmoney2," + "MaxCharge," + "MinMoney3," + "Charge_Min," + "Charge_Max," + "Charge_Percent," + "IncludeTax," + "TaxRate," + "StoreID) " + "values(" + "@TypeID," + "@TypeName," + "@Intro," + "@ChargeType," + "@IsDefault," + "@IsDisabled," + "@OrderSort," + "@ReleaseType," + "@MinMoney1," + "@ReleaseCharge," + "@Minmoney2," + "@MaxCharge," + "@MinMoney3," + "@Charge_Min," + "@Charge_Max," + "@Charge_Percent," + "@IncludeTax," + "@TaxRate," + "@StoreID)"; if (await Task.Run(() => _DB.ExeSQLResult(strSQL, dict))) { return(DataConverter.CLng(entity.TypeID)); } return(-1); }
/// <summary> /// 增加一条记录 /// </summary> /// <param name="entity">实体模型</param> /// <returns></returns> public virtual bool Add(DeliverTypeEntity entity) { if (entity.TypeID <= 0) { entity.TypeID = GetNewID(); } Dictionary <string, object> dict = new Dictionary <string, object>(); GetParameters(entity, dict); string strSQL = "insert into DeliverType (" + "TypeID," + "TypeName," + "Intro," + "ChargeType," + "IsDefault," + "IsDisabled," + "OrderSort," + "ReleaseType," + "MinMoney1," + "ReleaseCharge," + "Minmoney2," + "MaxCharge," + "MinMoney3," + "Charge_Min," + "Charge_Max," + "Charge_Percent," + "IncludeTax," + "TaxRate," + "StoreID) " + "values(" + "@TypeID," + "@TypeName," + "@Intro," + "@ChargeType," + "@IsDefault," + "@IsDisabled," + "@OrderSort," + "@ReleaseType," + "@MinMoney1," + "@ReleaseCharge," + "@Minmoney2," + "@MaxCharge," + "@MinMoney3," + "@Charge_Min," + "@Charge_Max," + "@Charge_Percent," + "@IncludeTax," + "@TaxRate," + "@StoreID)"; return(_DB.ExeSQLResult(strSQL, dict)); }
/// <summary> /// 获取实体(异步方式) /// </summary> /// <param name="strWhere">参数化查询条件(例如: and Name = @Name )</param> /// <param name="dict">参数的名/值集合</param> /// <returns></returns> public virtual async Task <DeliverTypeEntity> GetEntityAsync(string strWhere, Dictionary <string, object> dict = null) { DeliverTypeEntity obj = null; string strSQL = "select top 1 * from DeliverType where 1=1 " + strWhere; using (NullableDataReader reader = await Task.Run(() => _DB.GetDataReader(strSQL, dict))) { if (reader.Read()) { obj = GetEntityFromrdr(reader); } } return(obj); }
/// <summary> /// 把实体类转换成键/值对集合 /// </summary> /// <param name="entity"></param> /// <param name="dict"></param> private static void GetParameters(DeliverTypeEntity entity, Dictionary <string, object> dict) { dict.Add("TypeID", entity.TypeID); dict.Add("TypeName", entity.TypeName); dict.Add("Intro", entity.Intro); dict.Add("ChargeType", entity.ChargeType); dict.Add("IsDefault", entity.IsDefault); dict.Add("IsDisabled", entity.IsDisabled); dict.Add("OrderSort", entity.OrderSort); dict.Add("ReleaseType", entity.ReleaseType); dict.Add("MinMoney1", entity.MinMoney1); dict.Add("ReleaseCharge", entity.ReleaseCharge); dict.Add("Minmoney2", entity.Minmoney2); dict.Add("MaxCharge", entity.MaxCharge); dict.Add("MinMoney3", entity.MinMoney3); dict.Add("Charge_Min", entity.Charge_Min); dict.Add("Charge_Max", entity.Charge_Max); dict.Add("Charge_Percent", entity.Charge_Percent); dict.Add("IncludeTax", entity.IncludeTax); dict.Add("TaxRate", entity.TaxRate); dict.Add("StoreID", entity.StoreID); }
/// <summary> /// 增加或更新一条记录(异步方式) /// </summary> /// <param name="entity">实体模型</param> /// <param name="IsSave">是否增加</param> /// <returns></returns> public virtual async Task <bool> AddOrUpdateAsync(DeliverTypeEntity entity, bool IsSave) { return(IsSave ? await AddAsync(entity) : await UpdateAsync(entity)); }
/// <summary> /// 增加或更新一条记录 /// </summary> /// <param name="entity">实体模型</param> /// <param name="IsSave">是否增加</param> /// <returns></returns> public virtual bool AddOrUpdate(DeliverTypeEntity entity, bool IsSave) { return(IsSave ? Add(entity) : Update(entity)); }