/// <summary>
/// 添加赠送pv范围记录
/// </summary>
/// <param name="tran"></param>
/// <param name="setGiveModel"></param>
/// <returns></returns>
public static int AddSetGivePV(SqlTransaction tran, SetGivePVModel setGiveModel)
{
string sql = @"INSERT INTO SetGivePV
(totalpvStart,totalpvEnd,operatenum,operateip)
VALUES (@totalpvStart,@totalpvEnd,@operatenum,@operateip);set @addID=@@identity" ;
SqlParameter[] objPara =
{
new SqlParameter("@totalpvStart", SqlDbType.Float),
new SqlParameter("@totalpvEnd", SqlDbType.Float),
new SqlParameter("@operatenum", SqlDbType.NVarChar),
new SqlParameter("@operateip", SqlDbType.NVarChar),
new SqlParameter("@addID", SqlDbType.Int)
};
objPara[0].Value = setGiveModel.TotalPVStart;
objPara[1].Value = setGiveModel.TotalPVEnd;
objPara[2].Value = setGiveModel.OperateNum;
objPara[3].Value = setGiveModel.OperateIP;
objPara[4].Value = 0;
objPara[4].Direction = ParameterDirection.Output;
DBHelper.ExecuteNonQuery(tran, sql, objPara, CommandType.Text);
return(Convert.ToInt32(objPara[4].Value));
}
public static int AddSetGivePV(SqlTransaction tran, SetGivePVModel setGiveModel)
{
return(GiveProductDAL.AddSetGivePV(tran, setGiveModel));
}
/// <summary>
/// 确认
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSaveOrder_Click(object sender, EventArgs e)
{
if (Session["giveProductList"] == null || Session["giveProductList"].ToString() == "")
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("001992", "对不起，您所填写的入库产品的数量不能全部是0!")));
return;
}
else
{
list = (ArrayList)Session["giveProductList"];
if (txtPvStart.Text == "")
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("000000", "请填写赠送起始PV！")));
return;
}
double pvStart, pvEnd;
if (!double.TryParse(txtPvStart.Text.Trim(), out pvStart))
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("000000", "请填写正确的赠送起始PV！")));
return;
}
if (pvStart < 0)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("000000", "赠送起始PV必须不小于0！")));
return;
}
if (GiveProductBLL.GetLastEndPV(pvStart))
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("000000", "赠送起始PV已存在！")));
return;
}
if (!double.TryParse(txtPVEnd.Text.Trim(), out pvEnd))
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("000000", "请填写正确的赠送结束PV！")));
return;
}
if (pvEnd < 0)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("000000", "赠送结束PV必须不小于0！")));
return;
}
if (GiveProductBLL.GetLastEndPV(pvEnd))
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("000000", "赠送结束PV已存在！")));
return;
}
if (pvEnd <= pvStart)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("000000", "赠送结束PV必须大于起始PV！")));
return;
}
using (SqlConnection conn = new SqlConnection(DAL.DBHelper.connString))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
SetGivePVModel sm = new SetGivePVModel();
sm.TotalPVStart = pvStart;
sm.TotalPVEnd = pvEnd;
sm.OperateIP = Request.UserHostAddress;
sm.OperateNum = Session["Company"].ToString();
int setGivePVID = GiveProductBLL.AddSetGivePV(tran, sm);
GiveProductBLL.CreateGiveProducts(tran, list, setGivePVID);
tran.Commit();
}
catch
{
tran.Rollback();
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("000000", "参数设置失败，请联系管理员!")));
return;
}
finally
{
conn.Close();
}
}
ScriptManager.RegisterStartupScript(this, GetType(), "abs", "alert('" + GetTran("000000", "赠送产品设置成功!") + "');location.href='GiveProduct.aspx'", true);
}
}
