public int insert_mod(M_GroupBuyList m_Announc)
{
string sqlStr = "PR_City_Add";
SqlParameter[] cmdParams = m_Announc.GetParameters();
return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.StoredProcedure, sqlStr, cmdParams)));
}
public bool GetUpdate(M_GroupBuyList groupBuyList)
{
//return dal.GetUpdate(groupBuyList);
string sqlStr = "UPDATE [dbo].[ZL_GroupBuyList] SET [UserID] = @UserID,[ProID] = @ProID,[Deposit] = @Deposit,[DepositTime] = @DepositTime,[isbuy] = @isbuy,[buytime] = @buytime,[buymoney] = @buymoney,[Btime] = @Btime,[PayID]=@PayID,[DepositPayID]=@DepositPayID,[Snum]=@Snum,[OrderID]=@OrderID,[IsReceipt]=@IsReceipt WHERE [id] = @id";
SqlParameter[] cmdParams = groupBuyList.GetParameters();
return(SqlHelper.ExecuteSql(sqlStr, cmdParams));
}
public int GetInsert(M_GroupBuyList groupBuyList)
{
//return dal.GetInsert(groupBuyList);
string sqlStr = "INSERT INTO [dbo].[ZL_GroupBuyList] ([UserID],[ProID],[Deposit],[DepositTime],[isbuy],[buytime],[buymoney],[Btime],[PayID],[DepositPayID],[Snum],[OrderID],[IsReceipt]) VALUES (@UserID,@ProID,@Deposit,@DepositTime,@isbuy,@buytime,@buymoney,@Btime,@PayID,@DepositPayID,@Snum,@OrderID,@IsReceipt);select @@IDENTITY";
SqlParameter[] cmdParams = groupBuyList.GetParameters();
return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sqlStr, cmdParams)));
}
/// <summary>
/// 添加团购
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button6_Click(object sender, EventArgs e)
{
M_GroupBuyList mgbl = new M_GroupBuyList();
mgbl.ProID = DataConverter.CLng(Request.QueryString["proid"]);
//mgbl.UserID =bu.GetLogin().UserID;
M_UserInfo mui = bu.GetUserIDByUserName(this.Name.Text);
if (mui.UserID <= 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('用户名不存在!');</script>");
return;
}
mgbl.UserID = mui.UserID;
mgbl.Deposit = DataConverter.CDouble(this.ZFMoney.Text);
if (this.ZFMoney.Text != null && this.ZFMoney.Text != "")
{
mgbl.PayID = 1;
}
else
{
mgbl.PayID = 0;
}
mgbl.buymoney = DataConverter.CDouble(this.money.Text);
if (this.money.Text != null && this.money.Text != "")
{
mgbl.isbuy = 1;
}
else
{
mgbl.isbuy = 0;
}
mgbl.Snum = DataConverter.CLng(this.Num.Text);
mgbl.buytime = DataConverter.CDate(this.ZFTime.Text);
mgbl.DepositTime = DataConverter.CDate(this.ZFMoneyTime.Text);
mgbl.Btime = DataConverter.CDate(this.TGTime.Text);
int i = gll.GetInsert(mgbl);
if (i > 0)
{
function.WriteSuccessMsg("添加成功!", "ShowGroupUser.aspx?proid=" + mgbl.ProID);
}
else
{
function.WriteErrMsg("添加失败!");
}
}
public void lbIsReceipt_Click(object sender, EventArgs e)
{
LinkButton lb = sender as LinkButton;
M_GroupBuyList mgbl = gll.GetSelect(DataConverter.CLng(lb.CommandName));
if (mgbl.id > 0)
{
mgbl.IsReceipt = 1;
if (gll.GetUpdate(mgbl))
{
int proid = DataConverter.CLng(Request.QueryString["proid"]);
DataTable blist = gll.SelectGroupByProID(proid);
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改成功！');</script>");
MyBind();
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改失败！');</script>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
B_Admin badmin = new B_Admin();
M_Product proinfo = pro.GetproductByid(proid);
M_GroupBuyList mgbl = gll.GetSelect(proid);
Call.SetBreadCrumb(Master, "<li>商城管理</li><li>团购管理</li><li>" + proinfo.Proname + "<li>");
if (Request.QueryString["menu"] != null)
{
string menu = Request.QueryString["menu"];
if (menu == "delete")
{
int groupid = DataConverter.CLng(Request.QueryString["groupid"]);
int proids = DataConverter.CLng(Request.QueryString["proid"]);
gll.DeleteByGroupID(groupid);
Response.Redirect("ShowGroupUser.aspx?proid=" + proids + "&Currentpage=0");
}
}
this.Deposit.Text = formatcs((gll.GetDeposit(proid).ToString()), "1", "4") + "元";
this.buymoney.Text = formatcs(gll.GetBuymoney(proid).ToString(), "1", "4") + "元";
MyBind();
}
}
public int insert(M_GroupBuyList model)
{
return(Sql.insert(strTableName, initMod.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public bool UpdateByID(M_GroupBuyList model)
{
return(Sql.UpdateByIDs(strTableName, PK, model.id.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters()));
}
