/// <summary>
/// 将IDataReader的当前记录读取到DicMallitemEntity 对象
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public DicMallitemEntity LoadSingleRow(IDataReader reader)
{
var obj = new DicMallitemEntity();
obj.MallCode = (System.Int32)reader["MallCode"];
obj.Name = (System.String)reader["Name"];
obj.MallType = (System.Int32)reader["MallType"];
obj.Quality = (System.Int32)reader["Quality"];
obj.ShowOrder = (System.Int32)reader["ShowOrder"];
obj.ImageId = (System.Int32)reader["ImageId"];
obj.ItemIntro = (System.String)reader["ItemIntro"];
obj.ItemTip = (System.String)reader["ItemTip"];
obj.UseNote = (System.String)reader["UseNote"];
obj.UseMsg = (System.String)reader["UseMsg"];
obj.UseLevel = (System.Int32)reader["UseLevel"];
obj.ShowUse = (System.Boolean)reader["ShowUse"];
obj.CurrencyType = (System.Int32)reader["CurrencyType"];
obj.CurrencyCount = (System.Int32)reader["CurrencyCount"];
obj.CurrencyDiscount = (System.String)reader["CurrencyDiscount"];
obj.EffectType = (System.Int32)reader["EffectType"];
obj.EffectValue = (System.Int32)reader["EffectValue"];
obj.ShowFlag = (System.Boolean)reader["ShowFlag"];
obj.HotFlag = (System.Boolean)reader["HotFlag"];
obj.PackageFlag = (System.Boolean)reader["PackageFlag"];
obj.ShowBatch = (System.Boolean)reader["ShowBatch"];
return(obj);
}
List <PointInTime> CalDiscount(DicMallitemEntity entity)
{
if (string.IsNullOrEmpty(entity.CurrencyDiscount))
{
return(new List <PointInTime>(0));
}
else
{
//0,0~100&1000,2000~60
string[] commandValues = entity.CurrencyDiscount.Split('&');
var pointInTimes = new List <PointInTime>(commandValues.Length);
foreach (var commandValue in commandValues)
{
string[] rateInTimes = commandValue.Split('~');
string[] times = rateInTimes[0].Split(',');
int discount = Convert.ToInt32(rateInTimes[1]);
var pointEntity = new PointInTime();
pointEntity.Point = entity.CurrencyCount * discount / 100;
pointEntity.StartTime = ShareUtil.BaseTime.AddMinutes(Convert.ToInt32(times[0]));
pointEntity.EndTime = ShareUtil.BaseTime.AddMinutes(Convert.ToInt32(times[1]));
pointInTimes.Add(pointEntity);
}
return(pointInTimes);
}
}
/// <summary>
/// 带事务的Update
/// </summary>
/// <param name="entity"></param>
/// <param name="trans">The trans.</param>
/// <returns></returns>
/// <remarks>2015/10/19 15:57:49</remarks>
public bool Update(DicMallitemEntity entity, DbTransaction trans)
{
var database = new SqlDatabase(this.ConnectionString);
DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_DicMallitem_Update");
database.AddInParameter(commandWrapper, "@MallCode", DbType.Int32, entity.MallCode);
database.AddInParameter(commandWrapper, "@Name", DbType.String, entity.Name);
database.AddInParameter(commandWrapper, "@MallType", DbType.Int32, entity.MallType);
database.AddInParameter(commandWrapper, "@Quality", DbType.Int32, entity.Quality);
database.AddInParameter(commandWrapper, "@ShowOrder", DbType.Int32, entity.ShowOrder);
database.AddInParameter(commandWrapper, "@ImageId", DbType.Int32, entity.ImageId);
database.AddInParameter(commandWrapper, "@ItemIntro", DbType.String, entity.ItemIntro);
database.AddInParameter(commandWrapper, "@ItemTip", DbType.String, entity.ItemTip);
database.AddInParameter(commandWrapper, "@UseNote", DbType.String, entity.UseNote);
database.AddInParameter(commandWrapper, "@UseMsg", DbType.String, entity.UseMsg);
database.AddInParameter(commandWrapper, "@UseLevel", DbType.Int32, entity.UseLevel);
database.AddInParameter(commandWrapper, "@ShowUse", DbType.Boolean, entity.ShowUse);
database.AddInParameter(commandWrapper, "@CurrencyType", DbType.Int32, entity.CurrencyType);
database.AddInParameter(commandWrapper, "@CurrencyCount", DbType.Int32, entity.CurrencyCount);
database.AddInParameter(commandWrapper, "@CurrencyDiscount", DbType.AnsiString, entity.CurrencyDiscount);
database.AddInParameter(commandWrapper, "@EffectType", DbType.Int32, entity.EffectType);
database.AddInParameter(commandWrapper, "@EffectValue", DbType.Int32, entity.EffectValue);
database.AddInParameter(commandWrapper, "@ShowFlag", DbType.Boolean, entity.ShowFlag);
database.AddInParameter(commandWrapper, "@HotFlag", DbType.Boolean, entity.HotFlag);
database.AddInParameter(commandWrapper, "@PackageFlag", DbType.Boolean, entity.PackageFlag);
database.AddInParameter(commandWrapper, "@ShowBatch", DbType.Boolean, entity.ShowBatch);
int results = 0;
if (trans != null)
{
results = database.ExecuteNonQuery(commandWrapper, trans);
}
else
{
results = database.ExecuteNonQuery(commandWrapper);
}
return(Convert.ToBoolean(results));
}
/// <summary>
/// GetById
/// </summary>
/// <param name="mallCode">mallCode</param>
/// <returns>DicMallitemEntity</returns>
/// <remarks>2015/10/19 15:57:49</remarks>
public DicMallitemEntity GetById(System.Int32 mallCode)
{
var database = new SqlDatabase(this.ConnectionString);
DbCommand commandWrapper = database.GetStoredProcCommand("P_DicMallitem_GetById");
database.AddInParameter(commandWrapper, "@MallCode", DbType.Int32, mallCode);
DicMallitemEntity obj = null;
using (IDataReader reader = database.ExecuteReader(commandWrapper))
{
if (reader.Read())
{
obj = LoadSingleRow(reader);
}
}
return(obj);
}
public static bool Update(DicMallitemEntity dicMallitemEntity, DbTransaction trans = null, string zoneId = "")
{
var provider = new DicMallitemProvider(zoneId);
return(provider.Update(dicMallitemEntity, trans));
}
private string SaveBuyPointShipmentsTx(NbManagerEntity manager, int point, int bonus,
PayChargehistoryEntity payEntity, ManagerMonthcardEntity monthcardEntity, MailBuilder mail,
ManagerChargenumberEntity buyRecord, DicMallitemEntity mallConfig, string zoneId)
{
if (point > 0 || bonus > 0)
{
var messCode1 = PayCore.Instance.AddPoint(payEntity.Account, point, bonus, EnumChargeSourceType.GmCharge,
payEntity.BillingId, null, zoneId);
if (messCode1 != MessageCode.Success)
{
return("增加钻石失败" + point + "," + bonus + "," + (int)messCode1);
}
PayChargehistoryMgr.Insert(payEntity, null, zoneId);
}
if (monthcardEntity != null)
{
if (monthcardEntity.BuyNumber == 1)
{
if (!ManagerMonthcardMgr.Insert(monthcardEntity, null, zoneId))
{
return("月卡发送失败");
}
}
else
{
if (!ManagerMonthcardMgr.Update(monthcardEntity, null, zoneId))
{
return("月卡发送失败");
}
}
}
if (!mail.Save(zoneId))
{
return("邮件发送失败");
}
if (buyRecord.Idx == 0)
{
ManagerChargenumberMgr.Insert(buyRecord, null, zoneId);
}
else
{
ManagerChargenumberMgr.Update(buyRecord, null, zoneId);
}
try
{
if (manager != null)
{
var curScore = mallConfig.EffectValue * 10;
var vipManager = VipManagerMgr.GetById(manager.Idx, zoneId);
if (vipManager != null)
{
curScore += vipManager.VipExp;
vipManager.VipExp = curScore;
VipManagerMgr.Update(vipManager, null, zoneId);
}
else
{
vipManager = new VipManagerEntity(manager.Idx, curScore, DateTime.Now, DateTime.Now,
DateTime.Now);
VipManagerMgr.Insert(vipManager, null, zoneId);
}
var newlevel = CacheFactory.VipdicCache.GetVipLevel(curScore);
if (newlevel > manager.VipLevel)
{
manager.VipLevel = newlevel;
ManagerUtil.SaveManagerData(manager, null, null, zoneId);
}
}
}
catch (Exception ex)
{
SystemlogMgr.Error("ChargeUpVip", ex);
return(ex.Message);
}
return("");
}
/// <summary>
/// Update
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
/// <remarks>2015/10/19 15:57:49</remarks>
public bool Update(DicMallitemEntity entity)
{
return(Update(entity, null));
}
/// <summary>
/// Insert
/// </summary>
/// <param name="entity"></param>
/// <param name="trans">The trans.</param>
/// <returns></returns>
/// <remarks>2015/10/19 15:57:49</remarks>
public bool Insert(DicMallitemEntity entity)
{
return(Insert(entity, null));
}
static MallItemDescriptionEntity BuildMallDescription(DicItemEntity itemEntity, DicMallitemEntity mallEntity)
{
var entity = new MallItemDescriptionEntity();
entity.ItemCode = itemEntity.ItemCode;
entity.ItemType = itemEntity.ItemType;
entity.Name = itemEntity.ItemName;
entity.ImageId = itemEntity.ImageId;
entity.Idx = mallEntity.MallCode;
entity.ItemIntro = mallEntity.ItemIntro;
entity.ItemTip = mallEntity.ItemTip;
entity.UseMsg = mallEntity.UseMsg;
entity.UseNote = mallEntity.UseNote;
entity.Quality = mallEntity.Quality;
entity.UseLevel = mallEntity.UseLevel;
entity.ImageId = itemEntity.ImageId;
entity.ShowUse = mallEntity.ShowUse ? 1 : 0;
entity.ShowBatch = mallEntity.ShowBatch ? 1 : 0;
return(entity);
}