void BindPackage(ItemPackageEntity packageFrame) { var list = new List <AdminItemInfoEntity>(); var packageData = SerializationHelper.FromByte <ItemPackageItemsEntity>(packageFrame.ItemString); if (packageData.Items != null) { foreach (var itemInfo in packageData.Items) { AdminItemInfoEntity entity = new AdminItemInfoEntity(); entity.GridIndex = itemInfo.GridIndex; entity.IsBinding = itemInfo.IsBinding; entity.IsBindingV = itemInfo.IsDeal; entity.ItemCode = itemInfo.ItemCode; entity.ItemCount = itemInfo.ItemCount; entity.Strength = itemInfo.GetStrength(); entity.ItemId = itemInfo.ItemId; entity.ItemType = itemInfo.ItemType; entity.ItemTypeV = CacheDataHelper.Instance.GetEnumDescription("EnumItemType", itemInfo.ItemType); entity.ItemProperty = itemInfo.ItemProperty; entity.Status = itemInfo.Status; entity.StatusV = CacheDataHelper.Instance.GetEnumDescription("EnumItemStatus", itemInfo.Status); BuildItemInfo(itemInfo, entity); if (list.Exists(d => d.ItemId == itemInfo.ItemId)) { entity.IsRepeat = true; } list.Add(entity); } lblPackageGrid.Text = string.Format("格数:{0}/{1}", packageData.Items.Count, packageFrame.PackageSize); } dgPackage.DataSource = list; dgPackage.DataBind(); }
/// <summary> /// 带事务的Update /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/1/19 10:29:04</remarks> public bool Update(ItemPackageEntity entity, DbTransaction trans = null) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_ItemPackage_Update"); database.AddInParameter(commandWrapper, "@ManagerId", DbType.Guid, entity.ManagerId); database.AddInParameter(commandWrapper, "@PackageSize", DbType.Int32, entity.PackageSize); database.AddInParameter(commandWrapper, "@ItemVersion", DbType.Byte, entity.ItemVersion); database.AddInParameter(commandWrapper, "@ItemString", DbType.Binary, entity.ItemString); database.AddInParameter(commandWrapper, "@Status", DbType.Int32, entity.Status); database.AddInParameter(commandWrapper, "@RowTime", DbType.DateTime, entity.RowTime); database.AddInParameter(commandWrapper, "@RowVersion", DbType.Binary, entity.RowVersion); int results = 0; if (trans != null) { results = database.ExecuteNonQuery(commandWrapper, trans); } else { results = database.ExecuteNonQuery(commandWrapper); } entity.ManagerId = (System.Guid)database.GetParameterValue(commandWrapper, "@ManagerId"); return(Convert.ToBoolean(results)); }
/// <summary> /// 将IDataReader的当前记录读取到ItemPackageEntity 对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> public ItemPackageEntity LoadSingleRow(IDataReader reader) { var obj = new ItemPackageEntity(); obj.ManagerId = (System.Guid)reader["ManagerId"]; obj.PackageSize = (System.Int32)reader["PackageSize"]; obj.ItemVersion = (System.Byte)reader["ItemVersion"]; obj.ItemString = (System.Byte[])reader["ItemString"]; obj.Status = (System.Int32)reader["Status"]; obj.RowTime = (System.DateTime)reader["RowTime"]; obj.RowVersion = (System.Byte[])reader["RowVersion"]; return(obj); }
/// <summary> /// GetById /// </summary> /// <param name="managerId">managerId</param> /// <returns>ItemPackageEntity</returns> /// <remarks>2016/1/19 10:29:03</remarks> public ItemPackageEntity GetById(System.Guid managerId) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("P_ItemPackage_GetById"); database.AddInParameter(commandWrapper, "@ManagerId", DbType.Guid, managerId); ItemPackageEntity obj = null; using (IDataReader reader = database.ExecuteReader(commandWrapper)) { if (reader.Read()) { obj = LoadSingleRow(reader); } } return(obj); }
public static bool Insert(ItemPackageEntity itemPackageEntity, DbTransaction trans = null, string zoneId = "") { var provider = new ItemPackageProvider(zoneId); return(provider.Insert(itemPackageEntity, trans)); }