/// <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); } }