/// <summary> /// 实体转换 /// <summary> private static WE_Project.Model.FDSellList TranEntity(DataRow dr) { if (dr != null) { WE_Project.Model.FDSellList model = new WE_Project.Model.FDSellList(); if (!string.IsNullOrEmpty(dr["SellID"].ToString())) { model.SellID = int.Parse(dr["SellID"].ToString()); } if (!string.IsNullOrEmpty(dr["BuyID"].ToString())) { model.BuyID = int.Parse(dr["BuyID"].ToString()); } model.SellMID = dr["SellMID"].ToString(); if (!string.IsNullOrEmpty(dr["SellTotalCount"].ToString())) { model.SellTotalCount = int.Parse(dr["SellTotalCount"].ToString()); } if (!string.IsNullOrEmpty(dr["SellCount"].ToString())) { model.SellCount = int.Parse(dr["SellCount"].ToString()); } if (!string.IsNullOrEmpty(dr["SellPrice"].ToString())) { model.SellPrice = decimal.Parse(dr["SellPrice"].ToString()); } if (!string.IsNullOrEmpty(dr["SellMoney"].ToString())) { model.SellMoney = decimal.Parse(dr["SellMoney"].ToString()); } if (!string.IsNullOrEmpty(dr["SellDate"].ToString())) { model.SellDate = DateTime.Parse(dr["SellDate"].ToString()); } if (!string.IsNullOrEmpty(dr["LastSellDate"].ToString())) { model.LastSellDate = DateTime.Parse(dr["LastSellDate"].ToString()); } if (!string.IsNullOrEmpty(dr["BuyDate"].ToString())) { model.BuyDate = DateTime.Parse(dr["BuyDate"].ToString()); } if (!string.IsNullOrEmpty(dr["SellState"].ToString())) { model.SellState = int.Parse(dr["SellState"].ToString()); } if (!string.IsNullOrEmpty(dr["ChaiFenCode"].ToString())) { model.ChaiFenCode = int.Parse(dr["ChaiFenCode"].ToString()); } model.SellFDName = dr["SellFDName"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public static Hashtable Update(WE_Project.Model.FDSellList model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("update FDSellList set "); strSql.Append(" BuyID = @BuyID , "); strSql.Append(" SellMID = @SellMID , "); strSql.Append(" SellTotalCount = @SellTotalCount , "); strSql.Append(" SellCount = @SellCount , "); strSql.Append(" SellPrice = @SellPrice , "); strSql.Append(" SellMoney = @SellMoney , "); strSql.Append(" SellDate = @SellDate , "); strSql.Append(" LastSellDate = @LastSellDate , "); strSql.Append(" SellFDName = @SellFDName , "); strSql.Append(" BuyDate = @BuyDate , "); strSql.Append(" ChaiFenCode = @ChaiFenCode , "); strSql.Append(" SellState = @SellState "); strSql.Append(" where SellID=@SellID "); strSql.AppendFormat(" ;select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@SellID", SqlDbType.Int, 4), new SqlParameter("@BuyID", SqlDbType.Int, 4), new SqlParameter("@SellMID", SqlDbType.VarChar, 50), new SqlParameter("@SellTotalCount", SqlDbType.Int, 4), new SqlParameter("@SellCount", SqlDbType.Int, 4), new SqlParameter("@SellPrice", SqlDbType.Decimal, 9), new SqlParameter("@SellMoney", SqlDbType.Decimal, 9), new SqlParameter("@SellDate", SqlDbType.DateTime), new SqlParameter("@LastSellDate", SqlDbType.DateTime), new SqlParameter("@SellState", SqlDbType.Int, 4), new SqlParameter("@SellFDName", SqlDbType.VarChar, 10), new SqlParameter("@BuyDate", SqlDbType.DateTime), new SqlParameter("@ChaiFenCode", SqlDbType.Int, 4) }; parameters[0].Value = model.SellID; parameters[1].Value = model.BuyID; parameters[2].Value = model.SellMID; parameters[3].Value = model.SellTotalCount; parameters[4].Value = model.SellCount; parameters[5].Value = model.SellPrice; parameters[6].Value = model.SellMoney; parameters[7].Value = model.SellDate; parameters[8].Value = model.LastSellDate; parameters[9].Value = model.SellState; parameters[10].Value = model.SellFDName; parameters[11].Value = model.BuyDate; parameters[12].Value = model.ChaiFenCode; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
/// <summary> /// 增加一条数据 /// </summary> public static Hashtable Insert(WE_Project.Model.FDSellList model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into FDSellList("); strSql.Append("BuyID,SellMID,SellTotalCount,SellCount,SellPrice,SellMoney,SellDate,LastSellDate,SellState,SellFDName,BuyDate,ChaiFenCode"); strSql.Append(") values ("); strSql.Append("@BuyID,@SellMID,@SellTotalCount,@SellCount,@SellPrice,@SellMoney,@SellDate,@LastSellDate,@SellState,@SellFDName,@BuyDate,@ChaiFenCode"); strSql.Append(") "); strSql.AppendFormat(";select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@BuyID", SqlDbType.Int, 4), new SqlParameter("@SellMID", SqlDbType.VarChar, 50), new SqlParameter("@SellTotalCount", SqlDbType.Int, 4), new SqlParameter("@SellCount", SqlDbType.Int, 4), new SqlParameter("@SellPrice", SqlDbType.Decimal, 9), new SqlParameter("@SellMoney", SqlDbType.Decimal, 9), new SqlParameter("@SellDate", SqlDbType.DateTime), new SqlParameter("@LastSellDate", SqlDbType.DateTime), new SqlParameter("@SellState", SqlDbType.Int, 4), new SqlParameter("@SellFDName", SqlDbType.VarChar, 10), new SqlParameter("@BuyDate", SqlDbType.DateTime), new SqlParameter("@ChaiFenCode", SqlDbType.Int, 4) }; parameters[0].Value = model.BuyID; parameters[1].Value = model.SellMID; parameters[2].Value = model.SellTotalCount; parameters[3].Value = model.SellCount; parameters[4].Value = model.SellPrice; parameters[5].Value = model.SellMoney; parameters[6].Value = model.SellDate; parameters[7].Value = model.LastSellDate; parameters[8].Value = model.SellState; parameters[9].Value = model.SellFDName; parameters[10].Value = model.BuyDate; parameters[11].Value = model.ChaiFenCode; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
/// <summary> /// 增加一条数据 /// </summary> public static bool Insert(WE_Project.Model.FDSellList model) { return(DAL.CommonBase.RunHashtable(Insert(model, new Hashtable()))); }
public static bool Update(WE_Project.Model.FDSellList model) { return(WE_Project.DAL.FDSellList.Update(model)); }
public static Hashtable Update(WE_Project.Model.FDSellList model, Hashtable MyHs) { return(WE_Project.DAL.FDSellList.Update(model, MyHs)); }
public static bool Insert(WE_Project.Model.FDSellList model) { return(WE_Project.DAL.FDSellList.Insert(model)); }
public static Hashtable Insert(WE_Project.Model.FDSellList model, Hashtable MyHs) { return(WE_Project.DAL.FDSellList.Insert(model, MyHs)); }