private void SaveDiscountProductInfo(HttpContext context)
{
decimal num3;
decimal num4;
decimal num5;
int num = Globals.RequestFormNum("ProductId");
int num2 = Globals.RequestFormNum("LimitedTimeDiscountId");
decimal.TryParse(Globals.RequestFormStr("Discount"), out num3);
decimal.TryParse(Globals.RequestFormStr("Minus"), out num4);
decimal.TryParse(Globals.RequestFormStr("FinalPrice"), out num5);
LimitedTimeDiscountProductInfo info = new LimitedTimeDiscountProductInfo {
ProductId = num,
LimitedTimeDiscountId = num2,
Discount = num3,
Minus = num4,
FinalPrice = num5
};
if (LimitedTimeDiscountHelper.UpdateLimitedTimeDiscountProduct(info))
{
context.Response.Write("{\"msg\":\"success\"}");
}
else
{
context.Response.Write("{\"msg\":\"fial\"}");
}
}
private void grdProducts_ItemCommand(object sender, System.Web.UI.WebControls.RepeaterCommandEventArgs e)
{
if (e.CommandName == "MoveProduct")
{
object commandArgument = e.CommandArgument;
if (!string.IsNullOrEmpty(commandArgument.ToString()))
{
bool flag = LimitedTimeDiscountHelper.DeleteDiscountProduct(commandArgument.ToString());
if (flag)
{
this.ShowMsgAndReUrl("移除成功", true, "LimitedTimeDiscountProduct.aspx?id=" + Globals.RequestQueryNum("id"));
}
}
}
if (e.CommandName == "Stop")
{
int num = 0;
if (int.TryParse(e.CommandArgument.ToString(), out num))
{
LimitedTimeDiscountProductInfo discountProductInfoById = LimitedTimeDiscountHelper.GetDiscountProductInfoById(num);
int status = (discountProductInfoById.Status == 3) ? 1 : 3;
if (!string.IsNullOrEmpty(num.ToString()))
{
bool flag2 = LimitedTimeDiscountHelper.ChangeDiscountProductStatus(num.ToString(), status);
if (flag2)
{
this.ShowMsgAndReUrl("状态修改成功", true, "LimitedTimeDiscountProduct.aspx?id=" + Globals.RequestQueryNum("id"));
}
}
}
}
}
private void IsDiscountProduct(System.Web.HttpContext context)
{
int num = Globals.RequestFormNum("productId");
if (num > 0)
{
LimitedTimeDiscountProductInfo discountProductInfoByProductId = LimitedTimeDiscountHelper.GetDiscountProductInfoByProductId(num);
if (discountProductInfoByProductId != null)
{
LimitedTimeDiscountInfo discountInfo = LimitedTimeDiscountHelper.GetDiscountInfo(discountProductInfoByProductId.LimitedTimeDiscountId);
MemberInfo currentMember = MemberProcessor.GetCurrentMember();
int num2 = 0;
int num3 = discountInfo.LimitNumber;
if (discountInfo != null)
{
if (currentMember != null)
{
if (MemberHelper.CheckCurrentMemberIsInRange(discountInfo.ApplyMembers, discountInfo.DefualtGroup, discountInfo.CustomGroup, currentMember.UserId))
{
int limitedTimeDiscountUsedNum = ShoppingCartProcessor.GetLimitedTimeDiscountUsedNum(discountProductInfoByProductId.LimitedTimeDiscountId, null, num, currentMember.UserId, false);
if (discountInfo.LimitNumber == 0)
{
num2 = discountInfo.LimitedTimeDiscountId;
}
else if (discountInfo.LimitNumber - limitedTimeDiscountUsedNum > 0)
{
num2 = discountInfo.LimitedTimeDiscountId;
num3 = discountInfo.LimitNumber - limitedTimeDiscountUsedNum;
}
else
{
num3 = 0;
}
}
}
else
{
num2 = discountInfo.LimitedTimeDiscountId;
}
}
if (discountInfo != null)
{
context.Response.Write(string.Concat(new object[]
{
"{\"msg\":\"success\",\"ActivityName\":\"",
Globals.String2Json(discountInfo.ActivityName),
"\",\"FinalPrice\":\"",
discountProductInfoByProductId.FinalPrice.ToString("f2"),
"\",\"LimitedTimeDiscountId\":\"",
num2,
"\",\"LimitNumber\":\"",
discountInfo.LimitNumber,
"\",\"RemainNumber\":\"",
num3,
"\"}"
}));
}
}
}
}
private void SaveDiscountProduct(HttpContext context)
{
Globals.RequestFormNum("id");
foreach (string str2 in Globals.RequestFormStr("discountProductList").Trim(new char[] { ',' }).Split(new char[] { ',' }))
{
string[] strArray2 = str2.Split(new char[] { '^' });
LimitedTimeDiscountProductInfo info = new LimitedTimeDiscountProductInfo();
if (((!string.IsNullOrEmpty(strArray2[0]) && !string.IsNullOrEmpty(strArray2[1])) && !string.IsNullOrEmpty(strArray2[4])) && (!string.IsNullOrEmpty(strArray2[2]) || !string.IsNullOrEmpty(strArray2[3])))
{
int id = Globals.ToNum(strArray2[0]);
LimitedTimeDiscountInfo discountInfo = LimitedTimeDiscountHelper.GetDiscountInfo(id);
info.LimitedTimeDiscountId = id;
info.ProductId = Globals.ToNum(strArray2[1]);
info.Discount = (string.IsNullOrEmpty(strArray2[2]) || (strArray2[2] == "undefined")) ? 0M : decimal.Parse(strArray2[2]);
info.Minus = (string.IsNullOrEmpty(strArray2[3]) || (strArray2[2] == "undefined")) ? 0M : decimal.Parse(strArray2[3]);
info.FinalPrice = decimal.Parse(strArray2[4]);
if (discountInfo != null)
{
info.BeginTime = discountInfo.BeginTime;
info.EndTime = discountInfo.EndTime;
}
info.CreateTime = DateTime.Now;
info.Status = 1;
LimitedTimeDiscountHelper.AddLimitedTimeDiscountProduct(info);
}
}
context.Response.Write("{\"msg\":\"success\"}");
}
public bool UpdateLimitedTimeDiscountProductById(LimitedTimeDiscountProductInfo info)
{
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("UPDATE [Hishop_LimitedTimeDiscountProduct] SET [Discount]=@Discount,[Minus]=@Minus,[IsDehorned]=@IsDehorned,[IsChamferPoint]=@IsChamferPoint,[FinalPrice]=@FinalPrice WHERE LimitedTimeDiscountProductId=@LimitedTimeDiscountProductId");
this.database.AddInParameter(sqlStringCommand, "Discount", System.Data.DbType.Decimal, info.Discount);
this.database.AddInParameter(sqlStringCommand, "Minus", System.Data.DbType.Decimal, info.Minus);
this.database.AddInParameter(sqlStringCommand, "IsDehorned", System.Data.DbType.Int32, info.IsDehorned);
this.database.AddInParameter(sqlStringCommand, "IsChamferPoint", System.Data.DbType.Int32, info.IsChamferPoint);
this.database.AddInParameter(sqlStringCommand, "FinalPrice", System.Data.DbType.Decimal, info.FinalPrice);
this.database.AddInParameter(sqlStringCommand, "LimitedTimeDiscountProductId", System.Data.DbType.Int32, info.LimitedTimeDiscountProductId);
return(this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
public LimitedTimeDiscountProductInfo GetDiscountProductInfoById(int id)
{
LimitedTimeDiscountProductInfo result = null;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_LimitedTimeDiscountProduct WHERE LimitedTimeDiscountProductId = @LimitedTimeDiscountProductId");
this.database.AddInParameter(sqlStringCommand, "LimitedTimeDiscountProductId", System.Data.DbType.Int32, id);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToModel <LimitedTimeDiscountProductInfo>(dataReader);
}
return(result);
}
public LimitedTimeDiscountProductInfo GetDiscountProductInfoByProductId(int productId)
{
LimitedTimeDiscountProductInfo result = null;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_LimitedTimeDiscountProduct WHERE ProductId = @productId and Status=1 and BeginTime <=GETDATE() and EndTime>=GETDATE() ");
this.database.AddInParameter(sqlStringCommand, "productId", System.Data.DbType.Int32, productId);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToModel <LimitedTimeDiscountProductInfo>(dataReader);
}
return(result);
}
public LimitedTimeDiscountProductInfo GetLimitedTimeDiscountProductByLimitIdAndProductId(int limitedTimeDiscountId, int productId)
{
LimitedTimeDiscountProductInfo result = null;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT top 1 * FROM Hishop_LimitedTimeDiscountProduct WHERE LimitedTimeDiscountId = @LimitedTimeDiscountId and ProductId=@ProductId and Status=1 and BeginTime<=getdate() and getdate()< EndTime order by LimitedTimeDiscountProductId desc");
this.database.AddInParameter(sqlStringCommand, "LimitedTimeDiscountId", System.Data.DbType.Int32, limitedTimeDiscountId);
this.database.AddInParameter(sqlStringCommand, "ProductId", System.Data.DbType.Int32, productId);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToModel <LimitedTimeDiscountProductInfo>(dataReader);
}
return(result);
}
public LimitedTimeDiscountProductInfo GetLimitedTimeDiscountProductByLimitIdAndProductIdAndUserId(int limitedTimeDiscountId, int productId, int userId)
{
LimitedTimeDiscountProductInfo info = null;
LimitedTimeDiscountProductInfo limitedTimeDiscountProductByLimitIdAndProductId = this.GetLimitedTimeDiscountProductByLimitIdAndProductId(limitedTimeDiscountId, productId);
if (limitedTimeDiscountProductByLimitIdAndProductId != null)
{
LimitedTimeDiscountInfo discountInfo = this.GetDiscountInfo(limitedTimeDiscountProductByLimitIdAndProductId.LimitedTimeDiscountId);
if ((discountInfo != null) && new MemberDao().CheckCurrentMemberIsInRange(discountInfo.ApplyMembers, discountInfo.DefualtGroup, discountInfo.CustomGroup, userId))
{
info = limitedTimeDiscountProductByLimitIdAndProductId;
}
}
return(info);
}
public bool AddLimitedTimeDiscountProduct(LimitedTimeDiscountProductInfo info)
{
this.DeleteDiscountProduct(info.LimitedTimeDiscountId, info.ProductId);
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO [Hishop_LimitedTimeDiscountProduct] ([LimitedTimeDiscountId],[ProductId],[Discount],[Minus],[IsDehorned],[IsChamferPoint],[FinalPrice],[CreateTime],[BeginTime],[EndTime],[Status]) VALUES (@LimitedTimeDiscountId,@ProductId,@Discount,@Minus,@IsDehorned,@IsChamferPoint,@FinalPrice,@CreateTime,@BeginTime,@EndTime,@Status);");
this.database.AddInParameter(sqlStringCommand, "LimitedTimeDiscountId", System.Data.DbType.Int32, info.LimitedTimeDiscountId);
this.database.AddInParameter(sqlStringCommand, "ProductId", System.Data.DbType.Int32, info.ProductId);
this.database.AddInParameter(sqlStringCommand, "Discount", System.Data.DbType.Decimal, info.Discount);
this.database.AddInParameter(sqlStringCommand, "Minus", System.Data.DbType.Decimal, info.Minus);
this.database.AddInParameter(sqlStringCommand, "IsDehorned", System.Data.DbType.Int32, info.IsDehorned);
this.database.AddInParameter(sqlStringCommand, "IsChamferPoint", System.Data.DbType.Int32, info.IsChamferPoint);
this.database.AddInParameter(sqlStringCommand, "FinalPrice", System.Data.DbType.Decimal, info.FinalPrice);
this.database.AddInParameter(sqlStringCommand, "CreateTime", System.Data.DbType.DateTime, info.CreateTime);
this.database.AddInParameter(sqlStringCommand, "BeginTime", System.Data.DbType.DateTime, info.BeginTime);
this.database.AddInParameter(sqlStringCommand, "EndTime", System.Data.DbType.DateTime, info.EndTime);
this.database.AddInParameter(sqlStringCommand, "Status", System.Data.DbType.Int32, info.Status);
return(this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
private void SaveDiscountProduct(System.Web.HttpContext context)
{
Globals.RequestFormNum("id");
string text = Globals.RequestFormStr("discountProductList").Trim(new char[]
{
','
});
string[] array = text.Split(new char[]
{
','
});
string[] array2 = array;
for (int i = 0; i < array2.Length; i++)
{
string text2 = array2[i];
string[] array3 = text2.Split(new char[]
{
'^'
});
LimitedTimeDiscountProductInfo limitedTimeDiscountProductInfo = new LimitedTimeDiscountProductInfo();
if (!string.IsNullOrEmpty(array3[0]) && !string.IsNullOrEmpty(array3[1]) && !string.IsNullOrEmpty(array3[4]) && (!string.IsNullOrEmpty(array3[2]) || !string.IsNullOrEmpty(array3[3])))
{
int num = Globals.ToNum(array3[0]);
LimitedTimeDiscountInfo discountInfo = LimitedTimeDiscountHelper.GetDiscountInfo(num);
limitedTimeDiscountProductInfo.LimitedTimeDiscountId = num;
limitedTimeDiscountProductInfo.ProductId = Globals.ToNum(array3[1]);
limitedTimeDiscountProductInfo.Discount = ((string.IsNullOrEmpty(array3[2]) || array3[2] == "undefined") ? 0m : decimal.Parse(array3[2]));
limitedTimeDiscountProductInfo.Minus = ((string.IsNullOrEmpty(array3[3]) || array3[2] == "undefined") ? 0m : decimal.Parse(array3[3]));
limitedTimeDiscountProductInfo.FinalPrice = decimal.Parse(array3[4]);
if (discountInfo != null)
{
limitedTimeDiscountProductInfo.BeginTime = discountInfo.BeginTime;
limitedTimeDiscountProductInfo.EndTime = discountInfo.EndTime;
}
limitedTimeDiscountProductInfo.CreateTime = System.DateTime.Now;
limitedTimeDiscountProductInfo.Status = 1;
LimitedTimeDiscountHelper.AddLimitedTimeDiscountProduct(limitedTimeDiscountProductInfo);
}
}
context.Response.Write("{\"msg\":\"success\"}");
}
private void UpdateDiscountProductList(System.Web.HttpContext context)
{
int id = Globals.RequestFormNum("LimitedTimeDiscountId");
string text = Globals.RequestFormStr("discountProductList").Trim(new char[]
{
','
});
string[] array = text.Split(new char[]
{
','
});
string[] array2 = array;
for (int i = 0; i < array2.Length; i++)
{
string text2 = array2[i];
string[] array3 = text2.Split(new char[]
{
'^'
});
for (int j = 0; j < array3.Length; j++)
{
if (!string.IsNullOrEmpty(array3[0]) && !string.IsNullOrEmpty(array3[1]) && !string.IsNullOrEmpty(array3[4]) && (!string.IsNullOrEmpty(array3[2]) || !string.IsNullOrEmpty(array3[3])))
{
LimitedTimeDiscountProductInfo limitedTimeDiscountProductInfo = new LimitedTimeDiscountProductInfo();
int limitedTimeDiscountProductId = Globals.ToNum(array3[0]);
LimitedTimeDiscountHelper.GetDiscountInfo(id);
limitedTimeDiscountProductInfo.LimitedTimeDiscountProductId = limitedTimeDiscountProductId;
limitedTimeDiscountProductInfo.Discount = ((string.IsNullOrEmpty(array3[2]) || array3[2] == "undefined") ? 0m : decimal.Parse(array3[2]));
limitedTimeDiscountProductInfo.Minus = ((string.IsNullOrEmpty(array3[3]) || array3[2] == "undefined") ? 0m : decimal.Parse(array3[3]));
limitedTimeDiscountProductInfo.FinalPrice = decimal.Parse(array3[4]);
LimitedTimeDiscountHelper.UpdateLimitedTimeDiscountProductById(limitedTimeDiscountProductInfo);
}
}
}
context.Response.Write("{\"msg\":\"success\"}");
}
private void IsDiscountProduct(HttpContext context)
{
int productId = Globals.RequestFormNum("productId");
if (productId > 0)
{
LimitedTimeDiscountProductInfo discountProductInfoByProductId = LimitedTimeDiscountHelper.GetDiscountProductInfoByProductId(productId);
if (discountProductInfoByProductId != null)
{
LimitedTimeDiscountInfo discountInfo = LimitedTimeDiscountHelper.GetDiscountInfo(discountProductInfoByProductId.LimitedTimeDiscountId);
MemberInfo currentMember = MemberProcessor.GetCurrentMember();
int limitedTimeDiscountId = 0;
if (discountInfo != null)
{
if (currentMember != null)
{
if (MemberHelper.CheckCurrentMemberIsInRange(discountInfo.ApplyMembers, discountInfo.DefualtGroup, discountInfo.CustomGroup, currentMember.UserId))
{
int num3 = ShoppingCartProcessor.GetLimitedTimeDiscountUsedNum(limitedTimeDiscountId, null, productId, currentMember.UserId, false);
if ((discountInfo.LimitNumber - num3) > 0)
{
limitedTimeDiscountId = discountInfo.LimitedTimeDiscountId;
}
}
}
else
{
limitedTimeDiscountId = discountInfo.LimitedTimeDiscountId;
}
}
if (discountInfo != null)
{
context.Response.Write(string.Concat(new object[] { "{\"msg\":\"success\",\"ActivityName\":\"", discountInfo.ActivityName, "\",\"FinalPrice\":\"", discountProductInfoByProductId.FinalPrice.ToString("f2"), "\",\"LimitedTimeDiscountId\":\"", limitedTimeDiscountId, "\",\"LimitNumber\":\"", discountInfo.LimitNumber, "\"}" }));
}
}
}
}
private void UpdateDiscountProductList(HttpContext context)
{
int id = Globals.RequestFormNum("LimitedTimeDiscountId");
foreach (string str2 in Globals.RequestFormStr("discountProductList").Trim(new char[] { ',' }).Split(new char[] { ',' }))
{
string[] strArray2 = str2.Split(new char[] { '^' });
for (int i = 0; i < strArray2.Length; i++)
{
if (((!string.IsNullOrEmpty(strArray2[0]) && !string.IsNullOrEmpty(strArray2[1])) && !string.IsNullOrEmpty(strArray2[4])) && (!string.IsNullOrEmpty(strArray2[2]) || !string.IsNullOrEmpty(strArray2[3])))
{
LimitedTimeDiscountProductInfo info = new LimitedTimeDiscountProductInfo();
int num3 = Globals.ToNum(strArray2[0]);
LimitedTimeDiscountHelper.GetDiscountInfo(id);
info.LimitedTimeDiscountProductId = num3;
info.Discount = (string.IsNullOrEmpty(strArray2[2]) || (strArray2[2] == "undefined")) ? 0M : decimal.Parse(strArray2[2]);
info.Minus = (string.IsNullOrEmpty(strArray2[3]) || (strArray2[2] == "undefined")) ? 0M : decimal.Parse(strArray2[3]);
info.FinalPrice = decimal.Parse(strArray2[4]);
LimitedTimeDiscountHelper.UpdateLimitedTimeDiscountProductById(info);
}
}
}
context.Response.Write("{\"msg\":\"success\"}");
}
public string GetLimitedTimeDiscountIdByProductId(int userid, string skuId, int productId)
{
int num = 0;
LimitedTimeDiscountProductInfo limitedTimeDiscountProductByProductId = this.GetLimitedTimeDiscountProductByProductId(productId);
if (limitedTimeDiscountProductByProductId != null)
{
int limitedTimeDiscountId = limitedTimeDiscountProductByProductId.LimitedTimeDiscountId;
LimitedTimeDiscountInfo discountInfo = new LimitedTimeDiscountDao().GetDiscountInfo(limitedTimeDiscountId);
if (discountInfo != null)
{
bool flag = false;
if (new MemberDao().CheckCurrentMemberIsInRange(discountInfo.ApplyMembers, discountInfo.DefualtGroup, discountInfo.CustomGroup, userid))
{
int limitNumber = discountInfo.LimitNumber;
if (limitNumber != 0)
{
int num4 = limitNumber - new ShoppingCartDao().GetLimitedTimeDiscountUsedNum(limitedTimeDiscountId, skuId, productId, userid, true);
if (num4 > 0)
{
flag = true;
}
}
else
{
flag = true;
}
}
if (flag)
{
num = limitedTimeDiscountId;
}
}
}
return(num.ToString());
}
public static bool UpdateLimitedTimeDiscountProduct(LimitedTimeDiscountProductInfo info)
{
return(LimitedTimeDiscountHelper._act.UpdateLimitedTimeDiscountProduct(info));
}
public static bool AddLimitedTimeDiscountProduct(LimitedTimeDiscountProductInfo info)
{
return(_act.AddLimitedTimeDiscountProduct(info));
}
public static bool UpdateLimitedTimeDiscountProductById(LimitedTimeDiscountProductInfo info)
{
return(_act.UpdateLimitedTimeDiscountProductById(info));
}
