/// <summary>
/// 从IDataReader创建StoreShipFeeInfo
/// </summary>
public static StoreShipFeeInfo BuildStoreShipFeeFromReader(IDataReader reader)
{
StoreShipFeeInfo storeShipFeeInfo = new StoreShipFeeInfo();
storeShipFeeInfo.RecordId = TypeHelper.ObjectToInt(reader["recordid"]);
storeShipFeeInfo.StoreSTid = TypeHelper.ObjectToInt(reader["storestid"]);
storeShipFeeInfo.RegionId = TypeHelper.ObjectToInt(reader["regionid"]);
storeShipFeeInfo.StartValue = TypeHelper.ObjectToInt(reader["startvalue"]);
storeShipFeeInfo.StartFee = TypeHelper.ObjectToInt(reader["startfee"]);
storeShipFeeInfo.AddValue = TypeHelper.ObjectToInt(reader["addvalue"]);
storeShipFeeInfo.AddFee = TypeHelper.ObjectToInt(reader["addfee"]);
return storeShipFeeInfo;
}
/// <summary>
/// 更新店铺配送费用
/// </summary>
/// <param name="storeShipFeeInfo">店铺配送费用信息</param>
public static void UpdateStoreShipFee(StoreShipFeeInfo storeShipFeeInfo)
{
BrnMall.Core.BMAData.RDBS.UpdateStoreShipFee(storeShipFeeInfo);
}
/// <summary>
/// 更新店铺配送费用
/// </summary>
/// <param name="storeShipFeeInfo">店铺配送费用信息</param>
public static void UpdateStoreShipFee(StoreShipFeeInfo storeShipFeeInfo)
{
BrnMall.Data.Stores.UpdateStoreShipFee(storeShipFeeInfo);
}
/// <summary>
/// 更新店铺配送费用
/// </summary>
/// <param name="storeShipFeeInfo">店铺配送费用信息</param>
public void UpdateStoreShipFee(StoreShipFeeInfo storeShipFeeInfo)
{
DbParameter[] parms = {
GenerateInParam("@storestid", SqlDbType.Int,4, storeShipFeeInfo.StoreSTid),
GenerateInParam("@regionid", SqlDbType.Int,4, storeShipFeeInfo.RegionId),
GenerateInParam("@startvalue", SqlDbType.Int,4, storeShipFeeInfo.StartValue),
GenerateInParam("@startfee", SqlDbType.Int,4, storeShipFeeInfo.StartFee),
GenerateInParam("@addvalue", SqlDbType.Int,4, storeShipFeeInfo.AddValue),
GenerateInParam("@addfee", SqlDbType.Int,4, storeShipFeeInfo.AddFee),
GenerateInParam("@recordid", SqlDbType.Int,4, storeShipFeeInfo.RecordId)
};
string commandText = string.Format("UPDATE [{0}storeshipfees] SET [storestid]=@storestid,[regionid]=@regionid,[startvalue]=@startvalue,[startfee]=@startfee,[addvalue]=@addvalue,[addfee]=@addfee WHERE [recordid]=@recordid",
RDBSHelper.RDBSTablePre);
RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
/// <summary>
/// 创建店铺配送费用
/// </summary>
/// <param name="storeShipFeeInfo">店铺配送费用信息</param>
public void CreateStoreShipFee(StoreShipFeeInfo storeShipFeeInfo)
{
DbParameter[] parms = {
GenerateInParam("@storestid", SqlDbType.Int,4, storeShipFeeInfo.StoreSTid),
GenerateInParam("@regionid", SqlDbType.Int,4, storeShipFeeInfo.RegionId),
GenerateInParam("@startvalue", SqlDbType.Int,4, storeShipFeeInfo.StartValue),
GenerateInParam("@startfee", SqlDbType.Int,4, storeShipFeeInfo.StartFee),
GenerateInParam("@addvalue", SqlDbType.Int,4, storeShipFeeInfo.AddValue),
GenerateInParam("@addfee", SqlDbType.Int,4, storeShipFeeInfo.AddFee)
};
string commandText = string.Format("INSERT INTO [{0}storeshipfees]([storestid],[regionid],[startvalue],[startfee],[addvalue],[addfee]) VALUES(@storestid,@regionid,@startvalue,@startfee,@addvalue,@addfee)",
RDBSHelper.RDBSTablePre);
RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
public ActionResult AddStoreShipFee(StoreShipFeeModel model, int storeSTid = -1)
{
StoreShipTemplateInfo storeShipTemplateInfo = AdminStores.GetStoreShipTemplateById(storeSTid);
if (storeShipTemplateInfo == null)
return PromptView("店铺配送模板不存在");
if (storeShipTemplateInfo.StoreId != WorkContext.StoreId)
return PromptView("不能操作其它店铺的配送模板");
if (ModelState.IsValid)
{
StoreShipFeeInfo storeShipFeeInfo = new StoreShipFeeInfo()
{
StoreSTid = storeSTid,
RegionId = model.RegionId,
StartValue = model.StartValue,
StartFee = model.StartFee,
AddValue = model.AddValue,
AddFee = model.AddFee
};
AdminStores.CreateStoreShipFee(storeShipFeeInfo);
AddStoreAdminLog("添加店铺配送费用", "添加店铺配送费用");
return PromptView("店铺配送费用添加成功");
}
LoadStoreShipFee(model.RegionId);
return View(model);
}
public ActionResult AddStoreShipTemplate(AddStoreShipTemplateModel model)
{
if (ModelState.IsValid)
{
StoreShipTemplateInfo storeShipTemplateInfo = new StoreShipTemplateInfo()
{
StoreId = WorkContext.StoreId,
Title = model.TemplateTitle,
Free = model.Free,
Type = model.Type
};
int storeSTid = AdminStores.CreateStoreShipTemplate(storeShipTemplateInfo);
if (storeSTid > 0)
{
StoreShipFeeInfo storeShipFeeInfo = new StoreShipFeeInfo()
{
StoreSTid = storeSTid,
RegionId = -1,
StartValue = model.StartValue,
StartFee = model.StartFee,
AddValue = model.AddValue,
AddFee = model.AddFee
};
AdminStores.CreateStoreShipFee(storeShipFeeInfo);
AddStoreAdminLog("添加店铺配送模板", "添加店铺配送模板,店铺配送模板为:" + model.TemplateTitle);
return PromptView("店铺配送模板添加成功");
}
else
{
return PromptView("店铺配送模板添加失败");
}
}
ViewData["referer"] = MallUtils.GetStoreAdminRefererCookie();
return View(model);
}