internal static int SetShopRegion(ShopRegion item) { if (item == null) { return(-1); } SafeProcedure.ExecuteNonQuery( Database.GetDatabase(JaneDefine.DBInstanceName), "dbo.Shop_region_Set", delegate(IParameterSet parameters) { parameters.AddWithValue("@id", item.Id); parameters.AddWithValue("@Name", item.Name); parameters.AddWithValue("@ParentId", item.ParentId); parameters.AddWithValue("@TransferPrice", item.TransferPrice); parameters.AddWithValue("@TransferPrice1", item.TransferPrice1); parameters.AddWithValue("@TransferPrice2", item.TransferPrice2); parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue); }, delegate(IParameterSet outputParameters) { item.Id = Convert.ToInt32(outputParameters.GetValue("@RetVal")); }); return(item.Id); }
internal static void MapList(IRecord record, List <ShopRegion> list) { ShopRegion m = new ShopRegion(); m.Id = record.GetInt32OrDefault(0, 0); m.Name = record.GetStringOrEmpty(1); m.ParentId = record.GetInt32OrDefault(2, 0); m.TransferPrice = record.GetDouble(3); m.TransferPrice1 = record.GetDouble(4); m.TransferPrice2 = record.GetDouble(5); list.Add(m); }
internal static ShopRegion GetShopRegion(int id) { ShopRegion m = new ShopRegion(id); if (id > 0) { SafeProcedure.ExecuteAndMapRecords( Database.GetDatabase(JaneDefine.DBInstanceName), "dbo.Shop_region_Get", delegate(IRecord record) { m.Id = record.GetInt32OrDefault(0, 0); m.Name = record.GetStringOrEmpty(1); m.ParentId = record.GetInt32OrDefault(2, 0); m.TransferPrice = record.GetDouble(3); m.TransferPrice1 = record.GetDouble(4); m.TransferPrice2 = record.GetDouble(5); }, id); } return(m); }
internal static Dictionary <int, ShopRegion> GetShopRegions20(List <int> ids) { Dictionary <int, ShopRegion> dic = new Dictionary <int, ShopRegion>(); if (ids != null && ids.Count > 0) { SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Shop_region_Get20", delegate(IParameterSet parameters) { int maxCount = ids.Count > 20 ? 20 : ids.Count; for (int i = 0; i < maxCount; i++) { parameters.AddWithValue("@tid" + (i + 1).ToString(), ids[i]); } }, delegate(IRecord record) { ShopRegion m = new ShopRegion(); m.Id = record.GetInt32OrDefault(0, 0); m.Name = record.GetStringOrEmpty(1); m.ParentId = record.GetInt32OrDefault(2, 0); m.TransferPrice = record.GetDouble(3); m.TransferPrice1 = record.GetDouble(4); m.TransferPrice2 = record.GetDouble(5); if (!dic.ContainsKey(m.Id)) { dic.Add(m.Id, m); } } ); } return(dic); }
//订单列表 //收货地址信息 #region 送货地域 public int SetShopRegion(ShopRegion item) { return(JaneShopRegionDao.SetShopRegion(item)); }