/// <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; }
/// <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; }
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; } }