/// <summary> /// 增加一条数据 /// </summary> public static Hashtable Insert(yny_002.Model.EPList model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into EPList("); strSql.Append("SellMID,SellDate,MoneyType,Money,SellState,BuyMID,BuyDate,LastBuyDate,LastSellDate,TakeOffMoney,SellType,epPwd,MHGMoney,EPImg,Remark)"); strSql.Append(" values ("); strSql.Append("@SellMID,@SellDate,@MoneyType,@Money,@SellState,@BuyMID,@BuyDate,@LastBuyDate,@LastSellDate,@TakeOffMoney,@SellType,@epPwd,@MHGMoney,@EPImg,@Remark)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SellMID", SqlDbType.VarChar, 50), new SqlParameter("@SellDate", SqlDbType.DateTime), new SqlParameter("@MoneyType", SqlDbType.VarChar, 20), new SqlParameter("@Money", SqlDbType.Int, 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("@LastSellDate", SqlDbType.DateTime), new SqlParameter("@TakeOffMoney", SqlDbType.Decimal, 9), new SqlParameter("@SellType", SqlDbType.VarChar, 50), new SqlParameter("@epPwd", SqlDbType.VarChar, 50), new SqlParameter("@MHGMoney", SqlDbType.Int, 4), new SqlParameter("@EPImg", SqlDbType.VarChar, 100), new SqlParameter("@Remark", SqlDbType.NVarChar, 500) }; parameters[0].Value = model.SellMID; parameters[1].Value = model.SellDate; parameters[2].Value = model.MoneyType; parameters[3].Value = model.Money; parameters[4].Value = model.SellState; parameters[5].Value = model.BuyMID; parameters[6].Value = model.BuyDate; parameters[7].Value = model.LastBuyDate; parameters[8].Value = model.LastSellDate; parameters[9].Value = model.TakeOffMoney; parameters[10].Value = model.SellType; parameters[11].Value = model.epPwd; parameters[12].Value = model.MHGMoney; parameters[13].Value = model.EPImg; parameters[14].Value = model.Remark; strSql.AppendFormat(";select '{0}'", guid); //挂卖减少钱数 DAL.MemberConfig.UpdateConfigTran(model.SellMID, model.MoneyType, (-model.Money - model.MHGMoney).ToString(), null, false, SqlDbType.Int, MyHs); MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
public static string Insert(yny_002.Model.EPList model) { if (!BLL.ChangeMoney.EnoughChange(model.SellMID, model.Money, model.MoneyType)) { return("您当前的" + BLL.Reward.List[model.MoneyType].RewardName + "余额不足"); } if (DAL.EPList.Insert(model)) { return("挂卖成功"); } else { return("挂卖失败"); } }
public static bool Update(yny_002.Model.EPList model) { return(yny_002.DAL.EPList.Update(model)); }
public static Hashtable Update(yny_002.Model.EPList model, Hashtable MyHs) { return(yny_002.DAL.EPList.Update(model, MyHs)); }
public static Hashtable Insert(yny_002.Model.EPList model, Hashtable MyHs) { return(yny_002.DAL.EPList.Insert(model, MyHs)); }
/// <summary> /// 增加一条数据 /// </summary> public static bool Insert(yny_002.Model.EPList model) { return(DAL.CommonBase.RunHashtable(Insert(model, new Hashtable()))); }
/// <summary> /// 实体转换 /// <summary> private static yny_002.Model.EPList TranEntity(DataRow row) { if (row != null) { yny_002.Model.EPList model = new yny_002.Model.EPList(); if (row["EPID"] != null && row["EPID"].ToString() != "") { model.EPID = int.Parse(row["EPID"].ToString()); } if (row["SellMID"] != null) { model.SellMID = row["SellMID"].ToString(); } if (row["SellDate"] != null && row["SellDate"].ToString() != "") { model.SellDate = DateTime.Parse(row["SellDate"].ToString()); } if (row["MoneyType"] != null) { model.MoneyType = row["MoneyType"].ToString(); } if (row["Money"] != null && row["Money"].ToString() != "") { model.Money = int.Parse(row["Money"].ToString()); } if (row["SellState"] != null && row["SellState"].ToString() != "") { model.SellState = int.Parse(row["SellState"].ToString()); } if (row["BuyMID"] != null) { model.BuyMID = row["BuyMID"].ToString(); } if (row["BuyDate"] != null && row["BuyDate"].ToString() != "") { model.BuyDate = DateTime.Parse(row["BuyDate"].ToString()); } if (row["LastBuyDate"] != null && row["LastBuyDate"].ToString() != "") { model.LastBuyDate = DateTime.Parse(row["LastBuyDate"].ToString()); } if (row["LastSellDate"] != null && row["LastSellDate"].ToString() != "") { model.LastSellDate = DateTime.Parse(row["LastSellDate"].ToString()); } if (row["TakeOffMoney"] != null && row["TakeOffMoney"].ToString() != "") { model.TakeOffMoney = decimal.Parse(row["TakeOffMoney"].ToString()); } if (row["SellType"] != null) { model.SellType = row["SellType"].ToString(); } if (row["epPwd"] != null) { model.epPwd = row["epPwd"].ToString(); } if (row["MHGMoney"] != null && row["MHGMoney"].ToString() != "") { model.MHGMoney = int.Parse(row["MHGMoney"].ToString()); } if (row["EPImg"] != null) { model.EPImg = row["EPImg"].ToString(); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(yny_002.Model.EPList model) { return(DAL.CommonBase.RunHashtable(Update(model, new Hashtable()))); }
/// <summary> /// 更新一条数据 /// </summary> public static Hashtable Update(yny_002.Model.EPList model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("update EPList set "); 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("LastSellDate=@LastSellDate,"); strSql.Append("TakeOffMoney=@TakeOffMoney,"); strSql.Append("SellType=@SellType,"); strSql.Append("epPwd=@epPwd,"); strSql.Append("MHGMoney=@MHGMoney,"); strSql.Append("EPImg=@EPImg,"); strSql.Append("Remark=@Remark"); strSql.Append(" where EPID=@EPID"); SqlParameter[] parameters = { new SqlParameter("@SellMID", SqlDbType.VarChar, 50), new SqlParameter("@SellDate", SqlDbType.DateTime), new SqlParameter("@MoneyType", SqlDbType.VarChar, 20), new SqlParameter("@Money", SqlDbType.Int, 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("@LastSellDate", SqlDbType.DateTime), new SqlParameter("@TakeOffMoney", SqlDbType.Decimal, 9), new SqlParameter("@SellType", SqlDbType.VarChar, 50), new SqlParameter("@epPwd", SqlDbType.VarChar, 50), new SqlParameter("@MHGMoney", SqlDbType.Int, 4), new SqlParameter("@EPImg", SqlDbType.VarChar, 100), new SqlParameter("@Remark", SqlDbType.NVarChar, 500), new SqlParameter("@EPID", SqlDbType.Int, 4) }; parameters[0].Value = model.SellMID; parameters[1].Value = model.SellDate; parameters[2].Value = model.MoneyType; parameters[3].Value = model.Money; parameters[4].Value = model.SellState; parameters[5].Value = model.BuyMID; parameters[6].Value = model.BuyDate; parameters[7].Value = model.LastBuyDate; parameters[8].Value = model.LastSellDate; parameters[9].Value = model.TakeOffMoney; parameters[10].Value = model.SellType; parameters[11].Value = model.epPwd; parameters[12].Value = model.MHGMoney; parameters[13].Value = model.EPImg; parameters[14].Value = model.Remark; parameters[15].Value = model.EPID; strSql.AppendFormat(" ;select '{0}'", guid); MyHs.Add(strSql.ToString(), parameters); return(MyHs); }