Exemple #1
0
        /// <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);
        }
Exemple #2
0
        /// <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();");
                }
            }
        }
Exemple #3
0
 public int GetInsert(M_Rebates model)
 {
     return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
 }
Exemple #4
0
 /// <summary>
 /// 根据ID更新
 /// </summary>
 public bool GetUpdate(M_Rebates model)
 {
     return(Sql.UpdateByIDs(strTableName, PK, model.ID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters()));
 }