/// <summary> /// 更新一条数据 /// </summary> public static Hashtable Update(WE_Project.Model.FDBuyList model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("update FDBuyList set "); strSql.Append(" BuyMID = @BuyMID , "); strSql.Append(" BuyCount = @BuyCount , "); strSql.Append(" BuyMoney = @BuyMoney , "); strSql.Append(" BuyDate = @BuyDate , "); strSql.Append(" CFState = @CFState , "); strSql.Append(" MoneyType = @MoneyType , "); strSql.Append(" BuyPrice = @BuyPrice , "); strSql.Append(" BuyFDName = @BuyFDName , "); strSql.Append(" BuyState = @BuyState "); strSql.Append(" where BuyID=@BuyID "); strSql.AppendFormat(" ;select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@BuyID", SqlDbType.Int, 4), new SqlParameter("@BuyMID", SqlDbType.VarChar, 50), new SqlParameter("@BuyCount", SqlDbType.Int, 4), new SqlParameter("@BuyMoney", SqlDbType.Decimal, 9), new SqlParameter("@BuyDate", SqlDbType.DateTime), new SqlParameter("@CFState", SqlDbType.Bit, 1), new SqlParameter("@MoneyType", SqlDbType.VarChar, 10), new SqlParameter("@BuyPrice", SqlDbType.Decimal, 9), new SqlParameter("@BuyState", SqlDbType.Int, 4), new SqlParameter("@BuyFDName", SqlDbType.VarChar, 10) }; parameters[0].Value = model.BuyID; parameters[1].Value = model.BuyMID; parameters[2].Value = model.BuyCount; parameters[3].Value = model.BuyMoney; parameters[4].Value = model.BuyDate; parameters[5].Value = model.CFState; parameters[6].Value = model.MoneyType; parameters[7].Value = model.BuyPrice; parameters[8].Value = model.BuyState; parameters[9].Value = model.BuyFDName; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
/// <summary> /// 实体转换 /// <summary> private static WE_Project.Model.FDBuyList TranEntity(DataRow dr) { if (dr != null) { WE_Project.Model.FDBuyList model = new WE_Project.Model.FDBuyList(); if (!string.IsNullOrEmpty(dr["BuyID"].ToString())) { model.BuyID = int.Parse(dr["BuyID"].ToString()); } model.BuyMID = dr["BuyMID"].ToString(); if (!string.IsNullOrEmpty(dr["BuyCount"].ToString())) { model.BuyCount = int.Parse(dr["BuyCount"].ToString()); } if (!string.IsNullOrEmpty(dr["BuyMoney"].ToString())) { model.BuyMoney = decimal.Parse(dr["BuyMoney"].ToString()); } if (!string.IsNullOrEmpty(dr["BuyDate"].ToString())) { model.BuyDate = DateTime.Parse(dr["BuyDate"].ToString()); } if (!string.IsNullOrEmpty(dr["CFState"].ToString())) { model.CFState = bool.Parse(dr["CFState"].ToString()); } model.MoneyType = dr["MoneyType"].ToString(); if (!string.IsNullOrEmpty(dr["BuyPrice"].ToString())) { model.BuyPrice = decimal.Parse(dr["BuyPrice"].ToString()); } if (!string.IsNullOrEmpty(dr["BuyState"].ToString())) { model.BuyState = int.Parse(dr["BuyState"].ToString()); } model.BuyFDName = dr["BuyFDName"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public static Hashtable Insert(WE_Project.Model.FDBuyList model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into FDBuyList("); strSql.Append("BuyMID,BuyCount,BuyMoney,BuyDate,CFState,MoneyType,BuyPrice,BuyState,BuyFDName"); strSql.Append(") values ("); strSql.Append("@BuyMID,@BuyCount,@BuyMoney,@BuyDate,@CFState,@MoneyType,@BuyPrice,@BuyState,@BuyFDName"); strSql.Append(") "); strSql.AppendFormat(";select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@BuyMID", SqlDbType.VarChar, 50), new SqlParameter("@BuyCount", SqlDbType.Int, 4), new SqlParameter("@BuyMoney", SqlDbType.Decimal, 9), new SqlParameter("@BuyDate", SqlDbType.DateTime), new SqlParameter("@CFState", SqlDbType.Bit, 1), new SqlParameter("@MoneyType", SqlDbType.VarChar, 10), new SqlParameter("@BuyPrice", SqlDbType.Decimal, 9), new SqlParameter("@BuyState", SqlDbType.Int, 4), new SqlParameter("@BuyFDName", SqlDbType.VarChar, 10) }; parameters[0].Value = model.BuyMID; parameters[1].Value = model.BuyCount; parameters[2].Value = model.BuyMoney; parameters[3].Value = model.BuyDate; parameters[4].Value = model.CFState; parameters[5].Value = model.MoneyType; parameters[6].Value = model.BuyPrice; parameters[7].Value = model.BuyState; parameters[8].Value = model.BuyFDName; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
public static string Insert(WE_Project.Model.FDBuyList model) { if (BLL.FDConfig.FDConfigModel[model.BuyFDName].ISOpen) { Model.Member member = DAL.Member.GetModel(model.BuyMID); if (member.RoleCode == "Notactive") { return("体验会员不允许购买,请先升级再进行购买"); } if (member.MConfig.FDTrade == model.BuyFDName) { lock (BLL.FDConfig.FDConfigModel) { if (BLL.ChangeMoney.EnoughChange(model.BuyMID, model.BuyCount * model.BuyPrice, model.MoneyType)) { List <Model.FDSellList> listsell = BLL.FDSellList.GetList("SellState<2 and SellFDName='" + model.BuyFDName + "' order by BuyDate"); int buycount = model.BuyCount; Hashtable MyHs = new Hashtable(); foreach (Model.FDSellList item in listsell) { int sell = item.SellTotalCount - item.SellCount; if (buycount >= sell) { buycount -= sell; item.SellCount += sell; item.SellMoney += item.SellPrice * sell; item.SellState = 2; item.LastSellDate = DateTime.Now; item.SellDate = DateTime.Now; BLL.ChangeMoney.HBChangeTran(item.SellPrice * sell, BLL.Member.ManageMember.TModel.MID, item.SellMID, "FDYJ", null, "MHB", model.BuyFDName, MyHs); BLL.FDSellList.Update(item, MyHs); } else { item.SellCount += buycount; item.SellMoney += buycount * item.SellPrice; item.SellState = 1; item.LastSellDate = DateTime.Now; item.SellDate = DateTime.Now; BLL.ChangeMoney.HBChangeTran(item.SellPrice * buycount, BLL.Member.ManageMember.TModel.MID, item.SellMID, "FDYJ", null, "MHB", model.BuyFDName, MyHs); BLL.FDSellList.Update(item, MyHs); buycount = 0; break; } } if (buycount > 0 || listsell.Sum(emp => (emp.SellTotalCount - emp.SellCount)) == 0) { Model.FDConfig fdconfig = BLL.FDConfig.FDConfigModel[model.BuyFDName]; fdconfig.FDState = false; BLL.FDConfig.Update(fdconfig, MyHs); BLL.FDConfig.FDConfigModel = null; } model.BuyCount -= buycount; if (model.BuyCount > 0) { model.BuyMoney = model.BuyCount * model.BuyPrice; BLL.FDBuyList.Insert(model, MyHs); if (BLL.CommonBase.RunHashtable(MyHs)) { if (buycount > 0) { BLL.FDConfig.FDConfigModel = null; } return("买入成功"); } return("买入失败"); } } else { return("你的FD币不足!"); } } } else { if (string.IsNullOrEmpty(member.MConfig.FDTrade)) { return("请先重置,再进行购买"); } else { return("您当前只允许" + member.MConfig.FDTrade + "盘交易"); } } } return(BLL.FDConfig.FDConfigModel[model.BuyFDName].FDCloseRemark); //return WE_Project.DAL.FDBuyList.Insert(model); }
public static Hashtable Insert(WE_Project.Model.FDBuyList model, Hashtable MyHs) { BLL.ChangeMoney.HBChangeTran(model.BuyMoney, model.BuyMID, BLL.Member.ManageMember.TModel.MID, "GM", null, "MGP", "", MyHs); return(WE_Project.DAL.FDBuyList.Insert(model, MyHs)); }
public static bool Update(WE_Project.Model.FDBuyList model) { return(WE_Project.DAL.FDBuyList.Update(model)); }
public static Hashtable Update(WE_Project.Model.FDBuyList model, Hashtable MyHs) { return(WE_Project.DAL.FDBuyList.Update(model, MyHs)); }
/// <summary> /// 增加一条数据 /// </summary> public static bool Insert(WE_Project.Model.FDBuyList model) { return(DAL.CommonBase.RunHashtable(Insert(model, new Hashtable()))); }