/// <summary> /// GetListInfoFromReader /// </summary> /// <param name="rdr">SqlDataReader</param> /// <returns></returns> private static List <M_Rebates> GetListInfoFromReader(SqlDataReader rdr) { List <M_Rebates> list = new List <M_Rebates>(); while (rdr.Read()) { M_Rebates info = new M_Rebates(); info.ID = DataConverter.CLng(rdr["ID"].ToString()); info.UserID = DataConverter.CLng(rdr["UserID"].ToString()); info.BalanceMoney = DataConverter.CDouble(rdr["BalanceMoney"].ToString()); info.Scale = DataConverter.CDouble(rdr["Scale"].ToString()); info.Money = DataConverter.CDouble(rdr["Money"].ToString()); info.ShopCount = DataConverter.CLng(rdr["ShopCount"].ToString()); info.OrderID = rdr["OrderID"].ToString(); list.Add(info); } rdr.Close(); return(list); }
/// <summary> /// 确定 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button2_Click(object sender, EventArgs e) { if (this.Label3.Value.Trim() == "") { Label5.Text = "<font style='color:red'></font>"; return; } else { Label5.Text = ""; } string[] proid; if (Request["item"] != null && Request["item"] != "") { proid = Request["item"].Split(','); M_ArticlePromotion map = new M_ArticlePromotion(); for (int i = 0; i < proid.Length; i++) { M_Rebates mr = new M_Rebates(); M_UserInfo mui = bu.GetUserIDByUserName(Label1.Text.Trim()); M_CartPro mcp = bcp.SelReturnModel(DataConverter.CLng(proid[i])); map = bap.GetSelectBySqlParams("select * from ZL_ArticlePromotion where cartproid=" + mcp.ID, null); mr.Money = mcp.AllMoney; mr.UserID = mui.UserID; mr.Scale = DataConverter.CFloat(this.Label3.Value) / 100; mr.BalanceMoney = (mcp.AllMoney * DataConverter.CFloat(Label3.Value) / 100); map.RebatesId = brb.GetInsert(mr); map.IsBalance = true; bap.GetUpdate(map); } if (map.RebatesId > 0) { function.Script(this, "alert('结算成功!');gotourl('shop/OrderBlanace.aspx?id=" + map.PromotionUserId + "&balance=0');Dialog.close();"); } else { function.Script(this, "alert('添加失败!');gotourl('shop/OrderBlanace.aspx?id=" + map.PromotionUserId + "&balance=0');Dialog.close();"); } } else { M_Rebates mr = new M_Rebates(); M_ArticlePromotion map = bap.GetSelect(DataConverter.CLng(hfId.Value)); mr.Money = DataConverter.CLng(this.Label2.Text); mr.UserID = map.PromotionUserId; mr.Scale = DataConverter.CFloat(this.Label3.Value) / 100; mr.BalanceMoney = DataConverter.CDouble(this.label4.Text); map.RebatesId = brb.GetInsert(mr); map.IsBalance = true; bap.GetUpdate(map); if (map.RebatesId > 0) { function.Script(this, "alert('结算成功!');gotourl('shop/OrderBlanace.aspx?id=" + map.PromotionUserId + "&balance=0');Dialog.close();"); } else { function.Script(this, "alert('添加失败!');gotourl('shop/OrderBlanace.aspx?id=" + map.PromotionUserId + "&balance=0');Dialog.close();"); } } }
public int GetInsert(M_Rebates model) { return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model))); }
/// <summary> /// 根据ID更新 /// </summary> public bool GetUpdate(M_Rebates model) { return(Sql.UpdateByIDs(strTableName, PK, model.ID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters())); }