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