Пример #1
0
 /// <summary>
 /// 得到指定条件的所有集合
 /// </summary>
 /// <param name="uid"></param>
 /// <returns></returns>
 public List<ShowShop.Model.Order.OrderTransfer> GetAll(string strWhere)
 {
     List<ShowShop.Model.Order.OrderTransfer> list = new List<ShowShop.Model.Order.OrderTransfer>();
     StringBuilder strSql = new StringBuilder();
     strSql.Append("select id,orderid,username,transfername,poundage,poundagepaymentperson,remark,notedate,notename,uptime from yxs_ordertransfer ");
     if (strWhere != null && strWhere != "")
     {
         strSql.Append("where " + strWhere + " ");
     }
     using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString()))
     {
         while (reader.Read())
         {
             ShowShop.Model.Order.OrderTransfer model = new ShowShop.Model.Order.OrderTransfer();
             model.ID = reader.GetInt32(0);
             model.OrderId = reader.GetString(1);
             model.UserName = reader.GetString(2);
             model.TransferName = reader.GetString(3);
             model.PoundAge = Convert.ToDecimal(reader["poundage"]);
             model.PoundAgePayMentPerson = reader.GetString(5);
             model.Remark = reader.GetString(6);
             model.NoteDate = reader.GetDateTime(7);
             model.NoteName = reader.GetString(8);
             model.UpTime = reader.GetDateTime(9);
             list.Add(model);
         }
     }
     return list;
 }
Пример #2
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public ShowShop.Model.Order.OrderTransfer GetModelByID(int id)
 {
     ShowShop.Model.Order.OrderTransfer model = new ShowShop.Model.Order.OrderTransfer();
     StringBuilder strSql = new StringBuilder();
     strSql.Append("select  top 1 id,orderid,username,transfername,poundage,poundagepaymentperson,remark,notedate,notename,uptime from yxs_ordertransfer ");
     strSql.Append(" where [id]=@id ");
     SqlParameter[] parameters = (SqlParameter[])this.ValueIDPara(id);
     using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString(), parameters))
     {
         if (reader.Read())
         {
             model.ID = reader.GetInt32(0);
             model.OrderId = reader.GetString(1);
             model.UserName = reader.GetString(2);
             model.TransferName = reader.GetString(3);
             model.PoundAge = Convert.ToDecimal(reader["poundage"]);
             model.PoundAgePayMentPerson = reader.GetString(5);
             model.Remark = reader.GetString(6);
             model.NoteDate = reader.GetDateTime(7);
             model.NoteName = reader.GetString(8);
             model.UpTime = reader.GetDateTime(9);
         }
         else
         {
             model = null;
         }
     }
     return model;
 }
Пример #3
0
        protected void lbtnSave_Click(object sender, EventArgs e)
        {
            ShowShop.BLL.Member.MemberAccount memberBll = new ShowShop.BLL.Member.MemberAccount();
            ShowShop.BLL.Order.Orders orderBll = new ShowShop.BLL.Order.Orders();
            ShowShop.Model.Order.Orders orderModel = orderBll.GetModel(this.lblOrderId.Text);
            decimal memberCapital = 0;
            ShowShop.Model.Admin.AdminInfo adminInfo = (ShowShop.Model.Admin.AdminInfo)ShowShop.Common.AdministrorManager.Get();
            if (!memberBll.Exists(this.txtTransferName.Text.Trim()))
            {
                this.ltlMsg.Text = "过户失败,不存在用户:" + this.txtTransferName.Text.Trim();
                this.pnlMsg.Visible = true;
                this.pnlMsg.CssClass = "actionErr";
                return;
            }

            ShowShop.BLL.Order.OrderTransfer bll = new ShowShop.BLL.Order.OrderTransfer();
            ShowShop.Model.Order.OrderTransfer model = new ShowShop.Model.Order.OrderTransfer();
            model.OrderId = this.lblOrderId.Text;
            model.UserName = this.lblUserName.Text;
            model.TransferName = this.txtTransferName.Text;
            model.PoundAge = Convert.ToDecimal(this.txtPoundAge.Text);
            model.Remark = this.txtRemark.Text;
            model.NoteDate = DateTime.Now;
            model.NoteName = adminInfo.AdminName;
            model.UpTime = DateTime.Now;

            #region 计算用户余额 是否能支付过户费
            if (this.rabPoundPay.SelectedValue == "0") //订单当前所有者 支付手续费
            {
                ShowShop.Model.Member.MemberAccount memberModel = memberBll.GetModel(this.lblUserId.Text.Trim());
                if (memberModel.Capital > Convert.ToDecimal(this.txtPoundAge.Text))
                {
                    memberCapital = Convert.ToDecimal(memberModel.Capital - Convert.ToDecimal(this.txtPoundAge.Text));
                }
                else
                {
                    this.ltlMsg.Text = "过户失败," + this.lblUserId.Text.Trim() + " 资金余额不足";
                    this.pnlMsg.Visible = true;
                    this.pnlMsg.CssClass = "actionErr";
                    return;
                }
                //更改用户资金状况
                memberBll.Amend(memberModel.UID, "Capital", memberCapital);
                model.PoundAgePayMentPerson = this.lblUserId.Text;
            }
            else  //过户对象
            {
                ShowShop.Model.Member.MemberAccount memberModel = memberBll.GetModel(this.txtTransferName.Text.Trim());
                if (memberModel.Capital > Convert.ToDecimal(this.txtPoundAge.Text))
                {
                    memberCapital = Convert.ToDecimal(memberModel.Capital - Convert.ToDecimal(this.txtPoundAge.Text));
                }
                else
                {
                    this.ltlMsg.Text = "过户失败," + this.txtTransferName.Text.Trim() + " 资金余额不足";
                    this.pnlMsg.Visible = true;
                    this.pnlMsg.CssClass = "actionErr";
                    return;
                }
                //更改用户资金状况
                memberBll.Amend(memberModel.UID, "Capital", memberCapital);
                model.PoundAgePayMentPerson = this.txtTransferName.Text;
            }

            #endregion

            try
            {
                //把原订单所属用户改为现在的用户
                orderModel.UserId = this.txtTransferName.Text.Trim();
                orderBll.Update(orderModel);
                bll.Add(model);
                this.ltlMsg.Text = "操作成功,已保存该信息";
                this.pnlMsg.Visible = true;
                this.pnlMsg.CssClass = "actionOk";
            }
            catch
            {
                this.ltlMsg.Text = "操作失败!";
                this.pnlMsg.Visible = true;
                this.pnlMsg.CssClass = "actionErr";
            }
            finally
            {
                bll = null;
                model = null;
            }
        }