/// <summary>
///添加记录
/// </summary>
/// <param name="MtrlsMrktng"></param>
/// <returns></returns>
public int GetInsert(M_MtrlsMrktng mtrlsMrktng)
{
string sqlStr = "INSERT INTO [dbo].[ZL_MtrlsMrktng] ([ShopID],[UserID],[Type],[Count],[commission]) VALUES (@ShopID,@UserID,@Type,@Count,@commission);SET @ID = SCOPE_IDENTITY()";
SqlParameter[] cmdParams = GetParameters(mtrlsMrktng);
return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sqlStr, cmdParams)));
}
/// <summary>
///更新记录
/// </summary>
/// <param name="MtrlsMrktng"></param>
/// <returns></returns>
public bool GetUpdate(M_MtrlsMrktng mtrlsMrktng)
{
string sqlStr = "UPDATE [dbo].[ZL_MtrlsMrktng] SET [ShopID] = @ShopID,[UserID] = @UserID,[Type] = @Type,[Count] = @Count,[commission] = @commission WHERE [ID] = @ID";
SqlParameter[] cmdParams = GetParameters(mtrlsMrktng);
return(SqlHelper.ExecuteSql(sqlStr, cmdParams));
}
private static M_MtrlsMrktng GetInfoFromReader(SqlDataReader rdr)
{
M_MtrlsMrktng info = new M_MtrlsMrktng();
info.ID = DataConverter.CLng(rdr["ID"].ToString());
info.ShopID = DataConverter.CLng(rdr["ShopID"].ToString());
info.UserID = DataConverter.CLng(rdr["UserID"].ToString());
info.Type = rdr["Type"].ToString();
info.Count = DataConverter.CLng(rdr["Count"].ToString());
info.commission = DataConverter.CDouble(rdr["commission"].ToString());
rdr.Close();
rdr.Dispose();
return(info);
}
protected void Page_Load(object sender, EventArgs e)
{
B_Admin badmin = new B_Admin();
Call.SetBreadCrumb(Master, "<li>商城管理</li><li><a href='PresentProject.aspx'>促销优惠</a></li><li><a href='MtrlsMrktng.aspx'>商品推广</a></li>");
int id = DataConverter.CLng(Request.QueryString["id"]);
M_MtrlsMrktng mp = bmm.GetSelect(id);
this.ShopID.Text = mp.ShopID.ToString();
this.ShopName.Text = GetShopName(mp.ShopID.ToString()).ToString();
this.ShopPrice.Text = GetPrice(mp.ShopID.ToString()).ToString();
this.lblNum.Text = Getprope(mp.ShopID.ToString()).ToString();
this.lblgu.Text = Getstock(mp.ShopID.ToString()).ToString();
this.txtJiexi.Text = Request.Url.ToString();
this.ExWorker.Text = GetUserName(mp.UserID.ToString()).ToString();
}
private static SqlParameter[] GetParameters(M_MtrlsMrktng MtrlsMrktnginfo)
{
SqlParameter[] parameter = new SqlParameter[6];
parameter[0] = new SqlParameter("@ID", SqlDbType.Int, 4);
parameter[0].Value = MtrlsMrktnginfo.ID;
parameter[1] = new SqlParameter("@ShopID", SqlDbType.Int, 4);
parameter[1].Value = MtrlsMrktnginfo.ShopID;
parameter[2] = new SqlParameter("@UserID", SqlDbType.Int, 4);
parameter[2].Value = MtrlsMrktnginfo.UserID;
parameter[3] = new SqlParameter("@Type", SqlDbType.NVarChar, 50);
parameter[3].Value = MtrlsMrktnginfo.Type;
parameter[4] = new SqlParameter("@Count", SqlDbType.Int, 4);
parameter[4].Value = MtrlsMrktnginfo.Count;
parameter[5] = new SqlParameter("@commission", SqlDbType.Money);
parameter[5].Value = MtrlsMrktnginfo.commission;
return(parameter);
}
