/// <summary>
/// 实体转换
/// <summary>
private static WE_Project.Model.EPList TranEntity(DataRow dr)
{
if (dr != null)
{
WE_Project.Model.EPList model = new WE_Project.Model.EPList();
if (!string.IsNullOrEmpty(dr["EPID"].ToString()))
{
model.EPID = int.Parse(dr["EPID"].ToString());
}
if (!string.IsNullOrEmpty(dr["LastSellDate"].ToString()))
{
model.LastSellDate = DateTime.Parse(dr["LastSellDate"].ToString());
}
model.SellMID = dr["SellMID"].ToString();
if (!string.IsNullOrEmpty(dr["SellDate"].ToString()))
{
model.SellDate = DateTime.Parse(dr["SellDate"].ToString());
}
model.MoneyType = dr["MoneyType"].ToString();
if (!string.IsNullOrEmpty(dr["Money"].ToString()))
{
model.Money = decimal.Parse(dr["Money"].ToString());
}
if (!string.IsNullOrEmpty(dr["SellState"].ToString()))
{
model.SellState = int.Parse(dr["SellState"].ToString());
}
model.BuyMID = dr["BuyMID"].ToString();
if (!string.IsNullOrEmpty(dr["BuyDate"].ToString()))
{
model.BuyDate = DateTime.Parse(dr["BuyDate"].ToString());
}
if (!string.IsNullOrEmpty(dr["LastBuyDate"].ToString()))
{
model.LastBuyDate = DateTime.Parse(dr["LastBuyDate"].ToString());
}
if (!string.IsNullOrEmpty(dr["TakeOffMoney"].ToString()))
{
model.TakeOffMoney = decimal.Parse(dr["TakeOffMoney"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static Hashtable Update(WE_Project.Model.EPList model, Hashtable MyHs)
{
string guid = Guid.NewGuid().ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("update EPList set ");
strSql.Append(" LastSellDate = @LastSellDate , ");
strSql.Append(" SellMID = @SellMID , ");
strSql.Append(" SellDate = @SellDate , ");
strSql.Append(" MoneyType = @MoneyType , ");
strSql.Append(" Money = @Money , ");
strSql.Append(" SellState = @SellState , ");
strSql.Append(" BuyMID = @BuyMID , ");
strSql.Append(" BuyDate = @BuyDate , ");
strSql.Append(" LastBuyDate = @LastBuyDate, ");
strSql.Append(" TakeOffMoney = @TakeOffMoney ");
strSql.Append(" where EPID=@EPID ");
strSql.AppendFormat(" ;select '{0}'", guid);
SqlParameter[] parameters =
{
new SqlParameter("@EPID", SqlDbType.Int, 4),
new SqlParameter("@LastSellDate", SqlDbType.DateTime),
new SqlParameter("@SellMID", SqlDbType.VarChar, 50),
new SqlParameter("@SellDate", SqlDbType.DateTime),
new SqlParameter("@MoneyType", SqlDbType.VarChar, 20),
new SqlParameter("@Money", SqlDbType.Decimal, 4),
new SqlParameter("@SellState", SqlDbType.Int, 4),
new SqlParameter("@BuyMID", SqlDbType.VarChar, 50),
new SqlParameter("@BuyDate", SqlDbType.DateTime),
new SqlParameter("@LastBuyDate", SqlDbType.DateTime),
new SqlParameter("@TakeOffMoney", SqlDbType.Decimal, 4)
};
parameters[0].Value = model.EPID;
parameters[1].Value = model.LastSellDate;
parameters[2].Value = model.SellMID;
parameters[3].Value = model.SellDate;
parameters[4].Value = model.MoneyType;
parameters[5].Value = model.Money;
parameters[6].Value = model.SellState;
parameters[7].Value = model.BuyMID;
parameters[8].Value = model.BuyDate;
parameters[9].Value = model.LastBuyDate;
parameters[10].Value = model.TakeOffMoney;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
public static string Insert(WE_Project.Model.EPList model)
{
Model.Member member = DAL.Member.GetModel(model.SellMID);
if (model.Money > member.MConfig.MJJ)
{
return("您当前的EP币余额不足");
}
if (DAL.EPList.Insert(model))
{
return("挂卖成功");
}
else
{
return("挂卖失败");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public static Hashtable Insert(WE_Project.Model.EPList model, Hashtable MyHs)
{
string guid = Guid.NewGuid().ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into EPList(");
strSql.Append("LastSellDate,SellMID,SellDate,MoneyType,Money,SellState,BuyMID,BuyDate,LastBuyDate,TakeOffMoney");
strSql.Append(") values (");
strSql.Append("@LastSellDate,@SellMID,@SellDate,@MoneyType,@Money,@SellState,@BuyMID,@BuyDate,@LastBuyDate,@TakeOffMoney");
strSql.Append(") ");
strSql.AppendFormat(";select '{0}'", guid);
SqlParameter[] parameters =
{
new SqlParameter("@LastSellDate", SqlDbType.DateTime),
new SqlParameter("@SellMID", SqlDbType.VarChar, 50),
new SqlParameter("@SellDate", SqlDbType.DateTime),
new SqlParameter("@MoneyType", SqlDbType.VarChar, 20),
new SqlParameter("@Money", SqlDbType.Decimal, 4),
new SqlParameter("@SellState", SqlDbType.Int, 4),
new SqlParameter("@BuyMID", SqlDbType.VarChar, 50),
new SqlParameter("@BuyDate", SqlDbType.DateTime),
new SqlParameter("@LastBuyDate", SqlDbType.DateTime),
new SqlParameter("@TakeOffMoney", SqlDbType.Decimal, 4)
};
parameters[0].Value = model.LastSellDate;
parameters[1].Value = model.SellMID;
parameters[2].Value = model.SellDate;
parameters[3].Value = model.MoneyType;
parameters[4].Value = model.Money;
parameters[5].Value = model.SellState;
parameters[6].Value = model.BuyMID;
parameters[7].Value = model.BuyDate;
parameters[8].Value = model.LastBuyDate;
parameters[9].Value = model.TakeOffMoney;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
public static bool Update(WE_Project.Model.EPList model)
{
return(WE_Project.DAL.EPList.Update(model));
}
public static Hashtable Update(WE_Project.Model.EPList model, Hashtable MyHs)
{
return(WE_Project.DAL.EPList.Update(model, MyHs));
}
public static Hashtable Insert(WE_Project.Model.EPList model, Hashtable MyHs)
{
return(WE_Project.DAL.EPList.Insert(model, MyHs));
}
/// <summary>
/// 增加一条数据
/// </summary>
public static bool Insert(WE_Project.Model.EPList model)
{
return(DAL.CommonBase.RunHashtable(Insert(model, new Hashtable())));
}
