private DataGridViewModel <Dictionary <string, object> > GetShippingTemplates(Pagination query)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
if (query != null)
{
DbQueryResult shippingTemplates = SalesHelper.GetShippingTemplates(query);
List <Dictionary <string, object> > list = DataHelper.DataTableToDictionary(shippingTemplates.Data);
foreach (Dictionary <string, object> item in list)
{
ShippingTemplateInfo shippingTemplateInfo = item.ToObject <ShippingTemplateInfo>();
item.Add("ShowNumberAndUnit", SalesHelper.GetShowNumberAndUnit((int)shippingTemplateInfo.ValuationMethod, shippingTemplateInfo.DefaultNumber));
item.Add("AddNumberStr", SalesHelper.GetShowNumberAndUnit(shippingTemplateInfo.ValuationMethod.ToInt(0), shippingTemplateInfo.AddNumber));
if (shippingTemplateInfo.IsFreeShipping)
{
item.Add("IsFreeShippingImg", "<img src=\"../images/da.gif\" />");
}
else
{
item.Add("IsFreeShippingImg", "<img src=\"../images/del.png\" style=\"margin-left:7px;\" />");
}
if (shippingTemplateInfo.ValuationMethod == ValuationMethods.Number)
{
item.Add("ValuationMethodStr", "按件数");
}
else
{
item.Add("ValuationMethodStr", "按重量");
}
}
dataGridViewModel.rows = list;
dataGridViewModel.total = shippingTemplates.TotalRecords;
}
return(dataGridViewModel);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!int.TryParse(this.Page.Request.QueryString["TemplateId"], out this.templateId))
{
base.GotoResourceNotFound();
}
else
{
this.btnUpdate.Click += this.btnUpdate_Click;
if (!this.Page.IsPostBack)
{
if (this.Page.Request.QueryString["isUpdate"] != null && this.Page.Request.QueryString["isUpdate"] == "true")
{
this.ShowMsg("成功修改了一个配送方式", true);
}
ShippingTemplateInfo shippingTemplate = SalesHelper.GetShippingTemplate(this.templateId, true);
if (shippingTemplate == null)
{
base.GotoResourceNotFound();
}
else
{
this.BindControl(shippingTemplate);
}
}
}
}
public static ShippingTemplateGroupMode GetShippingTemplateParam_RegionId(ShippingTemplateInfo shippingTemplateInfo, int provinceRegionId, int cityRegionid, int regionId)
{
ShippingTemplateGroupMode shippingTemplateGroupMode = null;
if (shippingTemplateInfo.ModeGroup != null && shippingTemplateInfo.ModeGroup.Count > 0)
{
foreach (ShippingTemplateGroupInfo item in shippingTemplateInfo.ModeGroup)
{
if (item.ModeRegions != null && item.ModeRegions.Count > 0)
{
foreach (ShippingRegionInfo modeRegion in item.ModeRegions)
{
if (modeRegion.RegionId == regionId || modeRegion.RegionId == provinceRegionId || modeRegion.RegionId == cityRegionid)
{
shippingTemplateGroupMode = new ShippingTemplateGroupMode();
shippingTemplateGroupMode.DefaultNumber = item.DefaultNumber;
shippingTemplateGroupMode.AddNumber = (item.AddNumber.HasValue ? item.AddNumber.Value : decimal.Zero);
shippingTemplateGroupMode.DefaultPrice = item.Price;
shippingTemplateGroupMode.AddPrice = (item.AddPrice.HasValue ? item.AddPrice.Value : decimal.Zero);
return(shippingTemplateGroupMode);
}
}
}
}
}
return(shippingTemplateGroupMode);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsPostBack)
{
this.templateId = base.Request.QueryString["TemplateId"].ToInt(0);
ShippingTemplateInfo shippingTemplate = SalesHelper.GetShippingTemplate(this.templateId, true);
if (shippingTemplate == null)
{
base.Response.Redirect("ManageShippingTemplates.aspx");
}
else
{
this.BindControl(shippingTemplate);
}
}
}
public bool CreateShippingTemplate(ShippingTemplateInfo shippingMode)
{
bool flag = false;
StringBuilder stringBuilder = new StringBuilder();
StringBuilder stringBuilder2 = new StringBuilder();
using (DbConnection dbConnection = base.database.CreateConnection())
{
dbConnection.Open();
DbTransaction dbTransaction = dbConnection.BeginTransaction();
try
{
int num = (int)this.Add(shippingMode, dbTransaction);
flag = (num > 0);
if (flag)
{
DbCommand sqlStringCommand = base.database.GetSqlStringCommand(" ");
base.database.AddInParameter(sqlStringCommand, "TemplateId", DbType.Int32, num);
if (shippingMode.ModeGroup != null && shippingMode.ModeGroup.Count > 0)
{
int num2 = 0;
stringBuilder.Append("DECLARE @ERR INT; Set @ERR =0;");
stringBuilder.Append(" DECLARE @GroupId Int;");
foreach (ShippingTemplateGroupInfo item in shippingMode.ModeGroup)
{
stringBuilder.Append(" INSERT INTO Hishop_ShippingTypeGroups(TemplateId,Price,AddPrice,DefaultNumber,AddNumber) VALUES( @TemplateId,").Append("@Price").Append(num2)
.Append(",@AddPrice")
.Append(num2)
.Append(",@DefaultNumber")
.Append(num2)
.Append(",@AddNumber")
.Append(num2)
.Append("); SELECT @ERR=@ERR+@@ERROR;");
base.database.AddInParameter(sqlStringCommand, "Price" + num2, DbType.Currency, item.Price);
base.database.AddInParameter(sqlStringCommand, "AddPrice" + num2, DbType.Currency, item.AddPrice);
base.database.AddInParameter(sqlStringCommand, "DefaultNumber" + num2, DbType.Currency, item.DefaultNumber);
base.database.AddInParameter(sqlStringCommand, "AddNumber" + num2, DbType.Currency, item.AddNumber);
stringBuilder.Append("Set @GroupId =@@identity;");
foreach (ShippingRegionInfo modeRegion in item.ModeRegions)
{
stringBuilder.Append(" INSERT INTO Hishop_ShippingRegions(TemplateId,GroupId,RegionId) VALUES(@TemplateId,@GroupId," + modeRegion.RegionId + "); SELECT @ERR=@ERR+@@ERROR;");
}
num2++;
}
sqlStringCommand.CommandText = stringBuilder.Append("SELECT @ERR;").ToString();
if ((int)base.database.ExecuteScalar(sqlStringCommand, dbTransaction) != 0)
{
dbTransaction.Rollback();
flag = false;
}
}
if (shippingMode.FreeGroup != null && shippingMode.FreeGroup.Count > 0)
{
int num3 = 0;
stringBuilder2.Append("DECLARE @FreeERR INT; Set @FreeERR =0;");
stringBuilder2.Append(" DECLARE @FreeGroupId Int;");
foreach (ShippingTemplateFreeGroupInfo item2 in shippingMode.FreeGroup)
{
stringBuilder2.Append(" INSERT INTO Hishop_ShippingFreeGroups(TemplateId,ConditionType,ConditionNumber) VALUES( @TemplateId,").Append("@ConditionType").Append(num3)
.Append(",@ConditionNumber")
.Append(num3)
.Append("); SELECT @FreeERR=@FreeERR+@@ERROR;");
base.database.AddInParameter(sqlStringCommand, "ConditionType" + num3, DbType.Int32, item2.ConditionType);
base.database.AddInParameter(sqlStringCommand, "ConditionNumber" + num3, DbType.String, item2.ConditionNumber);
stringBuilder2.Append("Set @FreeGroupId =@@identity;");
foreach (ShippingFreeRegionInfo modeRegion2 in item2.ModeRegions)
{
stringBuilder2.Append(" INSERT INTO Hishop_ShippingFreeRegions(TemplateId,GroupId,RegionId) VALUES(@TemplateId,@FreeGroupId," + modeRegion2.RegionId + "); SELECT @FreeERR=@FreeERR+@@ERROR;");
}
num3++;
}
sqlStringCommand.CommandText = stringBuilder2.Append("SELECT @FreeERR;").ToString();
if ((int)base.database.ExecuteScalar(sqlStringCommand, dbTransaction) != 0)
{
dbTransaction.Rollback();
flag = false;
}
}
}
dbTransaction.Commit();
}
catch (Exception ex)
{
IDictionary <string, string> dictionary = new Dictionary <string, string>();
dictionary.Add("sql", stringBuilder.ToString());
Globals.WriteExceptionLog(ex, dictionary, "AdminError");
if (dbTransaction.Connection != null)
{
dbTransaction.Rollback();
}
flag = false;
}
finally
{
dbConnection.Close();
}
}
return(flag);
}
public static bool UpdateShippingTemplate(ShippingTemplateInfo shippingMode)
{
HiCache.Remove($"DataCache-ShippingModeInfoCacheKey-{shippingMode.TemplateId}");
return(new ShippingModeDao().UpdateShippingTemplate(shippingMode));
}
public static bool CreateShippingTemplate(ShippingTemplateInfo shippingMode)
{
return(new ShippingModeDao().CreateShippingTemplate(shippingMode));
}
protected void DoCallback()
{
base.Response.Clear();
base.Response.ContentType = "application/json";
string text = base.Request.QueryString["action"];
if (text.Equals("getPrepareData"))
{
int typeId = int.Parse(base.Request.QueryString["typeId"]);
IList <AttributeInfo> attributes = ProductTypeHelper.GetAttributes(typeId);
DataTable dataTable = ProductTypeHelper.GetBrandCategoriesByTypeId(typeId);
if (dataTable.Rows.Count == 0)
{
dataTable = CatalogHelper.GetBrandCategories(0);
}
base.Response.Write(this.GenerateJsonString(attributes, dataTable));
attributes.Clear();
}
else if (text.Equals("getMemberGradeList"))
{
IList <MemberGradeInfo> memberGrades = MemberHelper.GetMemberGrades();
if (memberGrades == null || memberGrades.Count == 0)
{
base.Response.Write("{\"Status\":\"0\"}");
}
else
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("{\"Status\":\"OK\",\"MemberGrades\":[");
foreach (MemberGradeInfo item in memberGrades)
{
stringBuilder.Append("{");
stringBuilder.AppendFormat("\"GradeId\":\"{0}\",", item.GradeId);
stringBuilder.AppendFormat("\"Name\":\"{0}\",", item.Name);
stringBuilder.AppendFormat("\"Discount\":\"{0}\"", item.Discount);
stringBuilder.Append("},");
}
stringBuilder.Remove(stringBuilder.Length - 1, 1);
stringBuilder.Append("]}");
base.Response.Write(stringBuilder.ToString());
}
}
else if (text.Equals("checkProductCode"))
{
string productCode = Globals.StripAllTags(base.Request.QueryString["productCode"].ToNullString());
int productId = 0;
int.TryParse(base.Request.QueryString["productId"], out productId);
ProductDao productDao = new ProductDao();
if (productDao.IsExistsProductCode(productCode, productId))
{
base.Response.Write(true);
}
else
{
base.Response.Write(false);
}
}
else if (text.Equals("checkSkuCode"))
{
string skuCode = Globals.StripAllTags(base.Request.QueryString["skuCode"].ToNullString());
int productId2 = 0;
int.TryParse(base.Request.QueryString["productId"], out productId2);
ProductDao productDao2 = new ProductDao();
if (productDao2.IsExistsSkuCode(skuCode, productId2))
{
base.Response.Write(true);
}
else
{
base.Response.Write(false);
}
}
else if (text.Equals("getShippingTemplatesValuationMethod"))
{
int num = base.Request.QueryString["shippingTemplatesId"].ToInt(0);
if (num > 0)
{
ShippingTemplateInfo shippingTemplate = SalesHelper.GetShippingTemplate(num, false);
if (shippingTemplate != null)
{
StringBuilder stringBuilder2 = new StringBuilder();
stringBuilder2.Append("{\"Status\":\"OK\",\"ValuationMethod\":\"" + (int)shippingTemplate.ValuationMethod + "\"}");
base.Response.Write(stringBuilder2.ToString());
base.Response.End();
}
}
base.Response.Write("{\"Status\":\"FAIL\"}");
base.Response.End();
}
base.Response.End();
}
private void btnCreate_Click(object sender, EventArgs e)
{
decimal defaultNumber = default(decimal);
decimal? addNumber = default(decimal?);
decimal price = default(decimal);
decimal? addPrice = default(decimal?);
ValuationMethods valuationMethod = default(ValuationMethods);
if (this.ValidateRegionValues(out defaultNumber, out addNumber, out price, out addPrice, out valuationMethod))
{
IList <ShippingTemplateGroupInfo> list = new List <ShippingTemplateGroupInfo>();
string value = this.hidRegionJson.Value;
if (!string.IsNullOrEmpty(value))
{
IList <ShippingTemplateGroupMode> list2 = new List <ShippingTemplateGroupMode>();
list2 = JsonHelper.ParseFormJson <List <ShippingTemplateGroupMode> >(value);
if (list2 != null && list2.Count > 0)
{
foreach (ShippingTemplateGroupMode item in list2)
{
ShippingTemplateGroupInfo shippingTemplateGroupInfo = new ShippingTemplateGroupInfo();
shippingTemplateGroupInfo.AddPrice = item.AddPrice;
shippingTemplateGroupInfo.AddNumber = item.AddNumber;
shippingTemplateGroupInfo.DefaultNumber = item.DefaultNumber;
shippingTemplateGroupInfo.Price = item.DefaultPrice;
string safeIDList = Globals.GetSafeIDList(item.RegionIds, ',', true);
string[] array = safeIDList.Split(',');
foreach (string obj in array)
{
ShippingRegionInfo shippingRegionInfo = new ShippingRegionInfo();
shippingRegionInfo.RegionId = obj.ToInt(0);
shippingTemplateGroupInfo.ModeRegions.Add(shippingRegionInfo);
}
list.Add(shippingTemplateGroupInfo);
}
}
}
IList <ShippingTemplateFreeGroupInfo> list3 = new List <ShippingTemplateFreeGroupInfo>();
string value2 = this.hidFreeJson.Value;
if (!string.IsNullOrEmpty(value2))
{
IList <ShippingTemplateFreeGroupMode> list4 = new List <ShippingTemplateFreeGroupMode>();
list4 = JsonHelper.ParseFormJson <List <ShippingTemplateFreeGroupMode> >(value2);
if (list4 != null && list4.Count > 0)
{
foreach (ShippingTemplateFreeGroupMode item2 in list4)
{
ShippingTemplateFreeGroupInfo shippingTemplateFreeGroupInfo = new ShippingTemplateFreeGroupInfo();
shippingTemplateFreeGroupInfo.ConditionType = item2.ConditionType;
shippingTemplateFreeGroupInfo.ConditionNumber = item2.ConditionNumber;
string safeIDList2 = Globals.GetSafeIDList(item2.RegionIds, ',', true);
string[] array2 = safeIDList2.Split(',');
foreach (string obj2 in array2)
{
ShippingFreeRegionInfo shippingFreeRegionInfo = new ShippingFreeRegionInfo();
shippingFreeRegionInfo.RegionId = obj2.ToInt(0);
shippingTemplateFreeGroupInfo.ModeRegions.Add(shippingFreeRegionInfo);
}
list3.Add(shippingTemplateFreeGroupInfo);
}
}
}
string text = Globals.StripAllTags(this.txtModeName.Text.Trim()).Replace("\\", "").Replace("<", "")
.Replace(">", "");
if (text == "" || text.Length > 20)
{
this.ShowMsg("模板名称不能为空，长度限制在20字符以内,不允许包含脚本标签和特殊字符,系统会自动过滤", false);
}
else if (SalesHelper.IsExistTemplateName(text, 0))
{
this.ShowMsg("模板名称重复,请重新输入", false);
}
else
{
ShippingTemplateInfo shippingTemplateInfo = new ShippingTemplateInfo();
shippingTemplateInfo.ModeGroup = list;
shippingTemplateInfo.FreeGroup = list3;
shippingTemplateInfo.IsFreeShipping = (this.radIsFreeShipping.SelectedIndex != 0 && true);
shippingTemplateInfo.ValuationMethod = valuationMethod;
shippingTemplateInfo.TemplateName = Globals.HtmlEncode(text);
shippingTemplateInfo.DefaultNumber = defaultNumber;
shippingTemplateInfo.AddNumber = addNumber;
shippingTemplateInfo.Price = price;
shippingTemplateInfo.AddPrice = addPrice;
if (SalesHelper.CreateShippingTemplate(shippingTemplateInfo))
{
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["source"]) && this.Page.Request.QueryString["source"] == "add")
{
this.CloseWindow();
}
else
{
this.ClearControlValue();
this.ShowMsg("成功添加了一个配送方式模板", true, "ManageShippingTemplates.aspx");
}
}
else
{
this.ShowMsg("您添加的地区有重复", false);
}
}
}
}
private bool ValidateValues(out decimal?costPrice, out decimal?marketPrice, out int needPoint, out int shippingTemplateId, out decimal weight, out decimal volume, out bool isFreeShipping)
{
string text = string.Empty;
costPrice = null;
marketPrice = null;
shippingTemplateId = 0;
weight = default(decimal);
volume = default(decimal);
isFreeShipping = false;
if (!string.IsNullOrEmpty(this.txtCostPrice.Text.Trim()))
{
decimal value = default(decimal);
if (decimal.TryParse(this.txtCostPrice.Text.Trim(), out value))
{
costPrice = value;
}
else
{
text += Formatter.FormatErrorMessage("成本价金额无效，大小在10000000以内");
}
}
if (!string.IsNullOrEmpty(this.txtMarketPrice.Text.Trim()))
{
decimal value2 = default(decimal);
if (decimal.TryParse(this.txtMarketPrice.Text.Trim(), out value2))
{
marketPrice = value2;
}
else
{
text += Formatter.FormatErrorMessage("市场参考价金额无效，大小在10000000以内");
}
}
if (this.onoffIsPointExchange.SelectedValue)
{
needPoint = this.txtNeedPoint.Text.ToInt(0);
if (needPoint <= 0)
{
text += Formatter.FormatErrorMessage("兑换所需积分不能为空，大小1-10000000之间");
}
}
else
{
needPoint = 0;
}
ValuationMethods valuationMethods = (ValuationMethods)0;
shippingTemplateId = this.ShippingTemplatesDropDownList.SelectedValue.ToInt(0);
ShippingTemplateInfo shippingTemplateInfo = null;
if (shippingTemplateId < 0)
{
text += Formatter.FormatErrorMessage("请选择运费模板");
}
else
{
shippingTemplateInfo = SalesHelper.GetShippingTemplate(shippingTemplateId, false);
}
if (shippingTemplateInfo == null)
{
text += Formatter.FormatErrorMessage("请选择运费模板");
}
else
{
valuationMethods = shippingTemplateInfo.ValuationMethod;
isFreeShipping = shippingTemplateInfo.IsFreeShipping;
}
if (valuationMethods == ValuationMethods.Weight && !shippingTemplateInfo.IsFreeShipping)
{
decimal num = default(decimal);
if (decimal.TryParse(this.txtWeight.Text, out num))
{
weight = num;
}
else
{
text += Formatter.FormatErrorMessage("请正确填写商品的重量");
}
}
if (valuationMethods == ValuationMethods.Volume && !shippingTemplateInfo.IsFreeShipping)
{
decimal num2 = default(decimal);
if (decimal.TryParse(this.txtVolume.Text, out num2))
{
volume = num2;
}
else
{
text += Formatter.FormatErrorMessage("请正确填写商品的体积");
}
}
if (!string.IsNullOrEmpty(text))
{
this.ShowMsg(text, false);
return(false);
}
return(true);
}
private void LoadGift()
{
GiftInfo giftDetails = GiftHelper.GetGiftDetails(this.giftId);
if (giftDetails == null)
{
base.GotoResourceNotFound();
}
else
{
Globals.EntityCoding(giftDetails, false);
this.txtGiftName.Text = Globals.HtmlDecode(giftDetails.Name);
this.txtNeedPoint.Text = giftDetails.NeedPoint.ToString();
this.ShippingTemplatesDropDownList.DataBind();
this.ShippingTemplatesDropDownList.SelectedValue = giftDetails.ShippingTemplateId;
if (!string.IsNullOrEmpty(giftDetails.Unit))
{
this.txtUnit.Text = giftDetails.Unit;
}
if (giftDetails.CostPrice.HasValue)
{
this.txtCostPrice.Text = $"{giftDetails.CostPrice:F2}";
}
if (giftDetails.MarketPrice.HasValue)
{
this.txtMarketPrice.Text = $"{giftDetails.MarketPrice:F2}";
}
if (!string.IsNullOrEmpty(giftDetails.ShortDescription))
{
this.txtShortDescription.Text = Globals.HtmlDecode(giftDetails.ShortDescription);
}
if (!string.IsNullOrEmpty(giftDetails.LongDescription))
{
this.fcDescription.Text = giftDetails.LongDescription;
}
if (!string.IsNullOrEmpty(giftDetails.Title))
{
this.txtGiftTitle.Text = Globals.HtmlDecode(giftDetails.Title);
}
if (!string.IsNullOrEmpty(giftDetails.Meta_Description))
{
this.txtTitleDescription.Text = Globals.HtmlDecode(giftDetails.Meta_Description);
}
if (!string.IsNullOrEmpty(giftDetails.Meta_Keywords))
{
this.txtTitleKeywords.Text = Globals.HtmlDecode(giftDetails.Meta_Keywords);
}
if (!string.IsNullOrEmpty(giftDetails.ImageUrl))
{
HiddenField hiddenField = this.hidUploadImages;
HiddenField hiddenField2 = this.hidOldImages;
string text2 = hiddenField.Value = (hiddenField2.Value = giftDetails.ImageUrl);
}
this.chkPromotion.SelectedValue = giftDetails.IsPromotion;
this.chkIsExemptionPostage.SelectedValue = giftDetails.IsExemptionPostage;
this.onoffIsPointExchange.SelectedValue = giftDetails.IsPointExchange;
int shippingTemplateId = giftDetails.ShippingTemplateId;
ShippingTemplateInfo shippingTemplate = SalesHelper.GetShippingTemplate(shippingTemplateId, false);
if (shippingTemplate != null)
{
if (shippingTemplate.ValuationMethod != ValuationMethods.Weight)
{
this.weightRow.Style.Add("display", "none");
}
if (shippingTemplate.ValuationMethod != ValuationMethods.Volume)
{
this.volumeRow.Style.Add("display", "none");
}
if (shippingTemplate.ValuationMethod == ValuationMethods.Number)
{
this.volumeRow.Style.Add("display", "none");
this.weightRow.Style.Add("display", "none");
}
}
else
{
this.volumeRow.Style.Add("display", "none");
this.weightRow.Style.Add("display", "none");
}
this.txtVolume.Text = giftDetails.Volume.F2ToString("f2");
this.txtWeight.Text = giftDetails.Weight.F2ToString("f2");
}
}
public ShippingTemplateInfo GetShippingTemplate(int templateId, bool includeDetail)
{
ShippingTemplateInfo shippingTemplateInfo = null;
DbCommand sqlStringCommand = base.database.GetSqlStringCommand(" SELECT * FROM Hishop_ShippingTemplates Where TemplateId =@TemplateId");
if (includeDetail)
{
DbCommand dbCommand = sqlStringCommand;
dbCommand.CommandText += " SELECT GroupId,TemplateId,Price,AddPrice,DefaultNumber,AddNumber FROM Hishop_ShippingTypeGroups Where TemplateId =@TemplateId";
DbCommand dbCommand2 = sqlStringCommand;
dbCommand2.CommandText += " SELECT sr.TemplateId,sr.GroupId,sr.RegionId FROM Hishop_ShippingRegions sr Where sr.TemplateId =@TemplateId";
DbCommand dbCommand3 = sqlStringCommand;
dbCommand3.CommandText += " SELECT GroupId,TemplateId,ConditionType,ConditionNumber FROM Hishop_ShippingFreeGroups Where TemplateId =@TemplateId";
DbCommand dbCommand4 = sqlStringCommand;
dbCommand4.CommandText += " SELECT sr.TemplateId,sr.GroupId,sr.RegionId FROM Hishop_ShippingFreeRegions sr Where sr.TemplateId =@TemplateId";
}
base.database.AddInParameter(sqlStringCommand, "TemplateId", DbType.Int32, templateId);
using (IDataReader dataReader = base.database.ExecuteReader(sqlStringCommand))
{
shippingTemplateInfo = DataHelper.ReaderToModel <ShippingTemplateInfo>(dataReader);
if (shippingTemplateInfo == null)
{
return(null);
}
if (includeDetail && shippingTemplateInfo != null)
{
dataReader.NextResult();
shippingTemplateInfo.ModeGroup = DataHelper.ReaderToList <ShippingTemplateGroupInfo>(dataReader);
dataReader.NextResult();
while (dataReader.Read())
{
foreach (ShippingTemplateGroupInfo item in shippingTemplateInfo.ModeGroup)
{
if (item.GroupId == (int)((IDataRecord)dataReader)["GroupId"])
{
ShippingRegionInfo shippingRegionInfo = new ShippingRegionInfo();
shippingRegionInfo.TemplateId = (int)((IDataRecord)dataReader)["TemplateId"];
shippingRegionInfo.GroupId = (int)((IDataRecord)dataReader)["GroupId"];
shippingRegionInfo.RegionId = (int)((IDataRecord)dataReader)["RegionId"];
item.ModeRegions.Add(shippingRegionInfo);
}
}
}
dataReader.NextResult();
shippingTemplateInfo.FreeGroup = DataHelper.ReaderToList <ShippingTemplateFreeGroupInfo>(dataReader);
dataReader.NextResult();
while (dataReader.Read())
{
foreach (ShippingTemplateFreeGroupInfo item2 in shippingTemplateInfo.FreeGroup)
{
if (item2.GroupId == (int)((IDataRecord)dataReader)["GroupId"])
{
ShippingFreeRegionInfo shippingFreeRegionInfo = new ShippingFreeRegionInfo();
shippingFreeRegionInfo.TemplateId = (int)((IDataRecord)dataReader)["TemplateId"];
shippingFreeRegionInfo.GroupId = (int)((IDataRecord)dataReader)["GroupId"];
shippingFreeRegionInfo.RegionId = (int)((IDataRecord)dataReader)["RegionId"];
item2.ModeRegions.Add(shippingFreeRegionInfo);
}
}
}
}
}
return(shippingTemplateInfo);
}
private void BindControl(ShippingTemplateInfo modeItem)
{
if (SalesHelper.ShippingTemplateIsExistProdcutRelation(this.templateId))
{
this.radValuationMethods.Enabled = false;
if (modeItem.IsFreeShipping)
{
this.radIsFreeShipping.Enabled = false;
}
}
this.txtModeName.Text = Globals.HtmlDecode(modeItem.TemplateName);
if (modeItem.ValuationMethod == ValuationMethods.Number)
{
TextBox textBox = this.txtDefaultNumber;
decimal num = modeItem.DefaultNumber;
textBox.Text = num.ToString("f0");
TextBox textBox2 = this.txtAddNumber;
object text;
if (!modeItem.AddNumber.HasValue)
{
text = "0";
}
else
{
num = modeItem.AddNumber.Value;
text = num.ToString("f0");
}
textBox2.Text = (string)text;
}
else if (modeItem.ValuationMethod == ValuationMethods.Volume)
{
this.txtDefaultNumber.Text = modeItem.DefaultNumber.F2ToString("f2");
this.txtAddNumber.Text = (modeItem.AddNumber.HasValue ? modeItem.AddNumber.Value.F2ToString("f2") : "0");
}
else
{
this.txtDefaultNumber.Text = modeItem.DefaultNumber.F2ToString("f2");
this.txtAddNumber.Text = (modeItem.AddNumber.HasValue ? modeItem.AddNumber.Value.F2ToString("f2") : "0");
}
if (modeItem.AddPrice.HasValue)
{
this.txtAddPrice.Text = modeItem.AddPrice.Value.F2ToString("f2");
}
this.txtDefaultPrice.Text = modeItem.Price.F2ToString("f2");
this.radIsFreeShipping.SelectedIndex = (modeItem.IsFreeShipping ? 1 : 0);
this.radValuationMethods.SelectedValue = modeItem.ValuationMethod;
IList <ShippingTemplateGroupMode> list = new List <ShippingTemplateGroupMode>();
if (modeItem.ModeGroup != null && modeItem.ModeGroup.Count > 0)
{
foreach (ShippingTemplateGroupInfo item in modeItem.ModeGroup)
{
ShippingTemplateGroupMode shippingTemplateGroupMode = new ShippingTemplateGroupMode();
shippingTemplateGroupMode.AddNumber = (item.AddNumber.HasValue ? item.AddNumber.Value : decimal.Zero);
shippingTemplateGroupMode.AddPrice = (item.AddPrice.HasValue ? item.AddPrice.Value : decimal.Zero);
shippingTemplateGroupMode.DefaultNumber = item.DefaultNumber;
shippingTemplateGroupMode.DefaultPrice = item.Price;
StringBuilder stringBuilder = new StringBuilder();
StringBuilder stringBuilder2 = new StringBuilder();
foreach (ShippingRegionInfo modeRegion in item.ModeRegions)
{
stringBuilder.Append(modeRegion.RegionId + ",");
stringBuilder2.Append(RegionHelper.GetFullRegion(modeRegion.RegionId, ",", true, 0).Split(',')[1] + ",");
}
if (!string.IsNullOrEmpty(stringBuilder.ToString()))
{
shippingTemplateGroupMode.RegionIds = stringBuilder.ToString().Substring(0, stringBuilder.ToString().Length - 1);
}
if (!string.IsNullOrEmpty(stringBuilder2.ToString()))
{
shippingTemplateGroupMode.RegionNames = stringBuilder2.ToString().Substring(0, stringBuilder2.ToString().Length - 1);
}
list.Add(shippingTemplateGroupMode);
}
}
if (list != null && list.Count > 0)
{
this.hidRegionJson.Value = JsonHelper.GetJson(list);
}
IList <ShippingTemplateFreeGroupMode> list2 = new List <ShippingTemplateFreeGroupMode>();
if (modeItem.FreeGroup != null && modeItem.FreeGroup.Count > 0)
{
this.radHasFree.SelectedValue = true;
foreach (ShippingTemplateFreeGroupInfo item2 in modeItem.FreeGroup)
{
ShippingTemplateFreeGroupMode shippingTemplateFreeGroupMode = new ShippingTemplateFreeGroupMode();
shippingTemplateFreeGroupMode.ConditionType = item2.ConditionType;
shippingTemplateFreeGroupMode.ConditionNumber = item2.ConditionNumber;
StringBuilder stringBuilder3 = new StringBuilder();
StringBuilder stringBuilder4 = new StringBuilder();
foreach (ShippingFreeRegionInfo modeRegion2 in item2.ModeRegions)
{
stringBuilder3.Append(modeRegion2.RegionId + ",");
stringBuilder4.Append(RegionHelper.GetFullRegion(modeRegion2.RegionId, ",", true, 0).Split(',')[1] + ",");
}
if (!string.IsNullOrEmpty(stringBuilder3.ToString()))
{
shippingTemplateFreeGroupMode.RegionIds = stringBuilder3.ToString().Substring(0, stringBuilder3.ToString().Length - 1);
}
if (!string.IsNullOrEmpty(stringBuilder4.ToString()))
{
shippingTemplateFreeGroupMode.RegionNames = stringBuilder4.ToString().Substring(0, stringBuilder4.ToString().Length - 1);
}
list2.Add(shippingTemplateFreeGroupMode);
}
}
if (list2 != null && list2.Count > 0)
{
this.hidFreeJson.Value = JsonHelper.GetJson(list2);
}
}
private bool ValidateConverts(bool skuEnabled, out int displaySequence, out decimal salePrice, out decimal?costPrice, out decimal?marketPrice, out int stock, out int warningStock, out decimal weight, out decimal?secondLevelDeduct, out decimal?subMemberDeduct, out decimal?threeLevelDeduct, out int shippingTemplateId, out decimal volume, out bool isFreeShipping)
{
string text = string.Empty;
costPrice = null;
marketPrice = null;
weight = default(decimal);
secondLevelDeduct = null;
subMemberDeduct = null;
threeLevelDeduct = null;
volume = default(decimal);
displaySequence = (stock = (warningStock = 0));
salePrice = default(decimal);
shippingTemplateId = 0;
isFreeShipping = false;
if (this.txtProductCode.Text.Length > 20)
{
text += Formatter.FormatErrorMessage("商家编码的长度不能超过20个字符");
}
if (!string.IsNullOrEmpty(Globals.StripAllTags(this.txtProductCode.Text)) && ProductHelper.IsExistsProductCode(Globals.StripAllTags(this.txtProductCode.Text), 0))
{
text += Formatter.FormatErrorMessage("商家编码重复");
}
if (!string.IsNullOrEmpty(this.txtMarketPrice.Text))
{
decimal value = default(decimal);
if (decimal.TryParse(this.txtMarketPrice.Text, out value))
{
marketPrice = value;
}
else
{
text += Formatter.FormatErrorMessage("请正确填写商品的市场价");
}
}
if (this.radPhysicalProduct.Checked)
{
ValuationMethods valuationMethods = (ValuationMethods)0;
shippingTemplateId = this.ShippingTemplatesDropDownList.SelectedValue.ToInt(0);
ShippingTemplateInfo shippingTemplateInfo = null;
if (shippingTemplateId < 0)
{
text += Formatter.FormatErrorMessage("请选择运费模板");
}
else
{
shippingTemplateInfo = SalesHelper.GetShippingTemplate(shippingTemplateId, false);
}
if (shippingTemplateInfo == null)
{
text += Formatter.FormatErrorMessage("请选择运费模板");
}
else
{
valuationMethods = shippingTemplateInfo.ValuationMethod;
isFreeShipping = shippingTemplateInfo.IsFreeShipping;
}
if (valuationMethods == ValuationMethods.Weight && !isFreeShipping)
{
decimal num = default(decimal);
if (decimal.TryParse(this.txtWeight.Text, out num))
{
weight = num;
}
else
{
text += Formatter.FormatErrorMessage("请正确填写商品的重量");
}
}
if (valuationMethods == ValuationMethods.Volume && !isFreeShipping)
{
decimal num2 = default(decimal);
if (decimal.TryParse(this.txtVolume.Text, out num2))
{
volume = num2;
weight = volume;
}
else
{
text += Formatter.FormatErrorMessage("请正确填写商品的体积");
}
}
}
else if (this.customValid.Checked)
{
DateTime now = DateTime.Now;
DateTime now2 = DateTime.Now;
if (this.validStartDate.Text == "" || this.validEndDate.Text == "" || !DateTime.TryParse(this.validStartDate.Text, out now) || !DateTime.TryParse(this.validEndDate.Text, out now2))
{
text += Formatter.FormatErrorMessage("请选择自定义日期");
}
if (now > now2)
{
text += Formatter.FormatErrorMessage("自定义时间开始时间必须小于结束时间");
}
}
if (!skuEnabled)
{
if (string.IsNullOrEmpty(this.txtSalePrice.Text) || !decimal.TryParse(this.txtSalePrice.Text, out salePrice))
{
text += Formatter.FormatErrorMessage("请正确填写商品一口价");
}
if (!string.IsNullOrEmpty(this.txtCostPrice.Text))
{
decimal value2 = default(decimal);
if (decimal.TryParse(this.txtCostPrice.Text, out value2))
{
costPrice = value2;
}
else
{
text += Formatter.FormatErrorMessage("请正确填写商品的成本价");
}
}
if (string.IsNullOrEmpty(this.txtStock.Text) || !int.TryParse(this.txtStock.Text, out stock))
{
text += Formatter.FormatErrorMessage("请正确填写商品的库存数量");
}
if (string.IsNullOrEmpty(this.txtWarningStock.Text) || !int.TryParse(this.txtWarningStock.Text, out warningStock))
{
text += Formatter.FormatErrorMessage("请正确填写商品的警戒库存数量");
}
}
if (HiContext.Current.SiteSettings.IsOpenSecondLevelCommission && !string.IsNullOrEmpty(this.txtSecondLevelDeduct.Text))
{
decimal value3 = default(decimal);
if (decimal.TryParse(this.txtSecondLevelDeduct.Text, out value3))
{
secondLevelDeduct = value3;
}
else
{
text += Formatter.FormatErrorMessage("请正确填写会员上二级抽佣比例");
}
}
if (!string.IsNullOrEmpty(this.txtSubMemberDeduct.Text))
{
decimal value4 = default(decimal);
if (decimal.TryParse(this.txtSubMemberDeduct.Text, out value4))
{
subMemberDeduct = value4;
}
else
{
text += Formatter.FormatErrorMessage("请正确填写会员直接上级抽佣比例");
}
}
if (HiContext.Current.SiteSettings.IsOpenThirdLevelCommission && !string.IsNullOrEmpty(this.txtThreeLevelDeduct.Text))
{
decimal value5 = default(decimal);
if (decimal.TryParse(this.txtThreeLevelDeduct.Text, out value5))
{
threeLevelDeduct = value5;
}
else
{
text += Formatter.FormatErrorMessage("请正确填写会员上三级抽佣比例");
}
}
if (!string.IsNullOrEmpty(text))
{
this.ShowMsg(text, false);
return(false);
}
return(true);
}
private void BindControl(ShippingTemplateInfo modeItem)
{
if (modeItem.IsFreeShipping)
{
this.lijjfs.Visible = false;
this.ulysfs.Visible = false;
this.ulzdcs.Visible = false;
}
this.ltIsFreeShipping.Text = (modeItem.IsFreeShipping ? "卖家承担运费" : "自定义运费");
switch (modeItem.ValuationMethod)
{
case ValuationMethods.Number:
{
this.ltValuationMetnods.Text = ((Enum)(object)ValuationMethods.Number).ToDescription();
Literal literal13 = this.ltUnit;
Literal literal14 = this.ltUnit2;
Literal literal15 = this.ltUnit3;
Literal literal16 = this.ltUnit4;
string text2 = literal16.Text = "件";
string text4 = literal15.Text = text2;
string text7 = literal13.Text = (literal14.Text = text4);
Literal literal17 = this.ltUnitDesc;
Literal literal18 = this.ltUnitDesc2;
text7 = (literal17.Text = (literal18.Text = "件"));
break;
}
case ValuationMethods.Volume:
{
this.ltValuationMetnods.Text = ((Enum)(object)ValuationMethods.Volume).ToDescription();
Literal literal7 = this.ltUnit;
Literal literal8 = this.ltUnit2;
Literal literal9 = this.ltUnit3;
Literal literal10 = this.ltUnit4;
string text2 = literal10.Text = "m<sup>3</sup>";
string text4 = literal9.Text = text2;
string text7 = literal7.Text = (literal8.Text = text4);
Literal literal11 = this.ltUnitDesc;
Literal literal12 = this.ltUnitDesc2;
text7 = (literal11.Text = (literal12.Text = "体积"));
break;
}
default:
{
this.ltValuationMetnods.Text = ((Enum)(object)ValuationMethods.Weight).ToDescription();
Literal literal = this.ltUnit;
Literal literal2 = this.ltUnit2;
Literal literal3 = this.ltUnit3;
Literal literal4 = this.ltUnit4;
string text2 = literal4.Text = "kg";
string text4 = literal3.Text = text2;
string text7 = literal.Text = (literal2.Text = text4);
Literal literal5 = this.ltUnitDesc;
Literal literal6 = this.ltUnitDesc2;
text7 = (literal5.Text = (literal6.Text = "重"));
break;
}
}
this.ltModeName.Text = modeItem.TemplateName;
this.ltDefaultNumber.Text = modeItem.DefaultNumber.ToDecimal(0).F2ToString("f2");
this.ltAddNumber.Text = modeItem.AddNumber.ToDecimal(0).F2ToString("f2");
this.ltAddPrice.Text = modeItem.AddPrice.ToDecimal(0).F2ToString("f2");
this.ltDefaultPrice.Text = modeItem.Price.ToDecimal(0).F2ToString("f2");
if (modeItem.ModeGroup != null && modeItem.ModeGroup.Count > 0)
{
this.rptShippingTypeGroups.DataSource = modeItem.ModeGroup;
this.rptShippingTypeGroups.DataBind();
}
else
{
this.ulzdcs.Visible = false;
}
}
public static ShippingTemplateFreeGroupMode GetShippingTemplateFreeParam_RegionId(ShippingTemplateInfo shippingTemplateInfo, int provinceRegionId, int cityRegionid, int regionId)
{
ShippingTemplateFreeGroupMode shippingTemplateFreeGroupMode = null;
if (shippingTemplateInfo.FreeGroup != null && shippingTemplateInfo.FreeGroup.Count > 0)
{
foreach (ShippingTemplateFreeGroupInfo item in shippingTemplateInfo.FreeGroup)
{
if (item.ModeRegions != null && item.ModeRegions.Count > 0)
{
foreach (ShippingFreeRegionInfo modeRegion in item.ModeRegions)
{
if (modeRegion.RegionId == regionId || modeRegion.RegionId == provinceRegionId || modeRegion.RegionId == cityRegionid)
{
shippingTemplateFreeGroupMode = new ShippingTemplateFreeGroupMode();
shippingTemplateFreeGroupMode.ConditionType = item.ConditionType;
shippingTemplateFreeGroupMode.ConditionNumber = item.ConditionNumber;
return(shippingTemplateFreeGroupMode);
}
}
}
}
}
return(shippingTemplateFreeGroupMode);
}
public static decimal CalcFreight_ShipppingTemplate(int regionId, int shippingTemplateId, int quantity = 1, decimal weight = default(decimal), decimal volume = default(decimal), decimal amount = default(decimal))
{
decimal result = default(decimal);
decimal num = default(decimal);
decimal num2 = default(decimal);
decimal num3 = default(decimal);
decimal num4 = default(decimal);
ShippingTemplateInfo shippingTemplateInfo = (ShippingTemplateInfo)HiCache.Get($"DataCache-ShippingModeInfoCacheKey-{shippingTemplateId}");
if (shippingTemplateInfo == null)
{
shippingTemplateInfo = new ShippingModeDao().GetShippingTemplate(shippingTemplateId, true);
HiCache.Insert($"DataCache-ShippingModeInfoCacheKey-{shippingTemplateId}", shippingTemplateInfo, 1800);
}
if (shippingTemplateInfo != null)
{
if (shippingTemplateInfo.IsFreeShipping)
{
return(decimal.Zero);
}
num = shippingTemplateInfo.DefaultNumber;
num2 = (shippingTemplateInfo.AddNumber.HasValue ? shippingTemplateInfo.AddNumber.Value : decimal.Zero);
num3 = shippingTemplateInfo.Price;
num4 = (shippingTemplateInfo.AddPrice.HasValue ? shippingTemplateInfo.AddPrice.Value : decimal.Zero);
if (regionId > 0)
{
string fullPath = RegionHelper.GetFullPath(regionId, true);
if (!string.IsNullOrEmpty(fullPath))
{
string[] array = fullPath.Split(',');
int num5 = 0;
int num6 = 0;
if (array.Length >= 2)
{
num5 = array[0].ToInt(0);
num6 = array[1].ToInt(0);
regionId = ((array.Length >= 3) ? array[2].ToInt(0) : 0);
ShippingTemplateGroupMode shippingTemplateParam_RegionId = ShoppingProcessor.GetShippingTemplateParam_RegionId(shippingTemplateInfo, num5, num6, regionId);
ShippingTemplateFreeGroupMode shippingTemplateFreeParam_RegionId = ShoppingProcessor.GetShippingTemplateFreeParam_RegionId(shippingTemplateInfo, num5, num6, regionId);
if (shippingTemplateFreeParam_RegionId != null)
{
int conditionType = shippingTemplateFreeParam_RegionId.ConditionType;
ConditionType conditionType2 = ConditionType.Number;
if (conditionType == conditionType2.GetHashCode())
{
if (quantity >= shippingTemplateFreeParam_RegionId.ConditionNumber.ToInt(0))
{
return(decimal.Zero);
}
}
else
{
int conditionType3 = shippingTemplateFreeParam_RegionId.ConditionType;
conditionType2 = ConditionType.Amount;
if (conditionType3 == conditionType2.GetHashCode())
{
if (amount >= shippingTemplateFreeParam_RegionId.ConditionNumber.ToDecimal(0))
{
return(decimal.Zero);
}
}
else
{
int conditionType4 = shippingTemplateFreeParam_RegionId.ConditionType;
conditionType2 = ConditionType.NumberAndAmount;
if (conditionType4 == conditionType2.GetHashCode() && quantity >= shippingTemplateFreeParam_RegionId.ConditionNumber.Split('$')[0].ToInt(0) && amount >= shippingTemplateFreeParam_RegionId.ConditionNumber.Split('$')[1].ToDecimal(0))
{
return(decimal.Zero);
}
}
}
}
if (shippingTemplateParam_RegionId != null)
{
num = shippingTemplateParam_RegionId.DefaultNumber;
num2 = shippingTemplateParam_RegionId.AddNumber;
num3 = shippingTemplateParam_RegionId.DefaultPrice;
num4 = shippingTemplateParam_RegionId.AddPrice;
}
}
}
}
if (shippingTemplateInfo.ValuationMethod == ValuationMethods.Number)
{
result = ShoppingProcessor.CalcFreight(quantity, num3, num4, num, num2);
}
else if (shippingTemplateInfo.ValuationMethod == ValuationMethods.Volume)
{
result = ShoppingProcessor.CalcFreight(volume, num3, num4, num, num2);
}
else if (shippingTemplateInfo.ValuationMethod == ValuationMethods.Weight)
{
result = ShoppingProcessor.CalcFreight(weight, num3, num4, num, num2);
}
}
return(result);
}
