/// <summary>
/// 删除赠品设置记录
/// </summary>
/// <param name="tran"></param>
/// <param name="id"></param>
/// <returns></returns>
public static bool DelSPVProduct(int id)
{
using (SqlConnection conn = new SqlConnection(DAL.DBHelper.connString))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
if (GiveProductDAL.DelGiveProductBySID(tran, id) <= 0)
{
tran.Rollback();
return(false);
}
if (GiveProductDAL.DelSetSetGivePVByID(tran, id) <= 0)
{
tran.Rollback();
return(false);
}
tran.Commit();
}
catch
{
tran.Rollback();
return(false);
}
finally
{
conn.Close();
}
}
return(true);
}
public static string GetTableZp(double pv)
{
StringBuilder sb = new StringBuilder();
DataTable dt = GiveProductDAL.GetDtBYPv(pv);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr>");
sb.Append("<td class='shoptab-img'><img src='" + FormatURL(dt.Rows[i]["ProductID"]) + "' width='40' height='40' /></td>");
sb.Append("<td >" + dt.Rows[i]["ProductCode"] + "</td>");
sb.Append("<td >" + dt.Rows[i]["ProductName"] + "</td>");
sb.Append("<td >" + dt.Rows[i]["price"] + "</td>");
sb.Append("<td >" + dt.Rows[i]["pv"] + "</td>");
sb.Append("<td >" + dt.Rows[i]["productQuantity"] + "</td>");
sb.Append("<td >" + dt.Rows[i]["totalPrice"] + "</td>");
sb.Append("<td >" + dt.Rows[i]["totalPv"] + "</td>");
sb.Append("</tr>");
}
}
else
{
sb.Append("<tr><td colspan='8'> 没有赠送产品</td></tr>");
}
}
else
{
sb.Append("<tr><td colspan='8'> 没有赠送产品</td></tr>");
}
return(sb.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
Permissions.ComRedirect(Page, Permissions.redirUrl);
if (!IsPostBack)
{
if (null != Request["id"])
{
DataTable dt = GiveProductDAL.GetSetGivePVByID(Convert.ToInt32(Request["id"]));
this.givDoc.DataSource = dt;
this.givDoc.DataBind();
this.givDocDitals.DataSource = GiveProductDAL.GetGiveProductBySID(Convert.ToInt32(Request["id"]));
this.givDocDitals.DataBind();
}
else
{
ScriptHelper.SetAlert(Page, GetTran("000984", "该编号可能以不存在！！！"), "SetGivePVManager.aspx");
}
}
Translations();
}
/// <summary>
/// 获取最后一条结束PV值
/// </summary>
/// <returns></returns>
public static bool GetLastEndPV(double totalpvStart)
{
return(GiveProductDAL.GetLastEndPV(totalpvStart));
}
public static int AddSetGivePV(SqlTransaction tran, SetGivePVModel setGiveModel)
{
return(GiveProductDAL.AddSetGivePV(tran, setGiveModel));
}
public static bool CreateGiveProducts(SqlTransaction tran, ArrayList giveProductList, int setGivePVID)
{
return(GiveProductDAL.CreateGiveProducts(tran, giveProductList, setGivePVID) > 0 ? true : false);
}
