public List <ShiMiao.Model.m_Sell_Goods> getAllModel() { StringBuilder strSql = new StringBuilder(); strSql.Append("select GoodsID, OrgID, Title, Content, Amount, Balance, Price, CreateTime, OrderIndex, StateCode,Frozen,isSell "); strSql.Append(" from TD_Sell_Goods "); strSql.Append(" where isSell=@isSell"); MySqlParameter[] parameters = { new MySqlParameter("@isSell", 1) }; List <ShiMiao.Model.m_Sell_Goods> _list = new List <ShiMiao.Model.m_Sell_Goods>(); using (DbDataReader dr = MySqlHelperUtil.ExecuteReader(strSql.ToString(), parameters)) { while (dr.Read()) { ShiMiao.Model.m_Sell_Goods model = new ShiMiao.Model.m_Sell_Goods(); int i = -1; if (dr[++i] != DBNull.Value) { model.GoodsID = dr.GetString(i); } if (dr[++i] != DBNull.Value) { model.OrgID = dr.GetInt32(i); } if (dr[++i] != DBNull.Value) { model.Title = dr.GetString(i); } if (dr[++i] != DBNull.Value) { model.Content = dr.GetString(i); } if (dr[++i] != DBNull.Value) { model.Amount = dr.GetInt32(i); } if (dr[++i] != DBNull.Value) { model.Balance = dr.GetInt32(i); } if (dr[++i] != DBNull.Value) { model.Price = dr.GetDecimal(i); } if (dr[++i] != DBNull.Value) { model.CreateTime = dr.GetDateTime(i); } if (dr[++i] != DBNull.Value) { model.OrderIndex = dr.GetInt32(i); } if (dr[++i] != DBNull.Value) { model.StateCode = dr.GetInt32(i); } if (dr[++i] != DBNull.Value) { model.Frozen = dr.GetInt32(i); } if (dr[++i] != DBNull.Value) { model.isSell = dr.GetInt32(i); } _list.Add(model); } return(_list); } }
public IList <ShiMiao.Model.m_Sell_Goods> GetListByPage(string where, string orderby, IDictionary <string, object> dictParams, int startIndex, int pageSize) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT GoodsID, OrgID, Title, Content, Amount, Balance, Price, CreateTime, OrderIndex, StateCode,Frozen,isSell FROM TD_Sell_Goods"); if (!string.IsNullOrEmpty(where)) { strSql.Append(" WHERE " + where); } if (!string.IsNullOrEmpty(orderby)) { strSql.AppendFormat(" order by {0}", orderby); } strSql.AppendFormat(" limit {0}, {1}", startIndex, pageSize); List <MySqlParameter> parameters = new List <MySqlParameter>(); if (dictParams != null) { foreach (var pair in dictParams) { MySqlParameter parameter = new MySqlParameter("@" + pair.Key, pair.Value); parameters.Add(parameter); } } IList <ShiMiao.Model.m_Sell_Goods> list = new List <ShiMiao.Model.m_Sell_Goods>(); using (DbDataReader dr = MySqlHelperUtil.ExecuteReader(strSql.ToString(), parameters.ToArray())) { while (dr.Read()) { ShiMiao.Model.m_Sell_Goods model = new ShiMiao.Model.m_Sell_Goods(); int i = -1; if (dr[++i] != DBNull.Value) { model.GoodsID = dr.GetString(i); } if (dr[++i] != DBNull.Value) { model.OrgID = dr.GetInt32(i); } if (dr[++i] != DBNull.Value) { model.Title = dr.GetString(i); } if (dr[++i] != DBNull.Value) { model.Content = dr.GetString(i); } if (dr[++i] != DBNull.Value) { model.Amount = dr.GetInt32(i); } if (dr[++i] != DBNull.Value) { model.Balance = dr.GetInt32(i); } if (dr[++i] != DBNull.Value) { model.Price = dr.GetDecimal(i); } if (dr[++i] != DBNull.Value) { model.CreateTime = dr.GetDateTime(i); } if (dr[++i] != DBNull.Value) { model.OrderIndex = dr.GetInt32(i); } if (dr[++i] != DBNull.Value) { model.StateCode = dr.GetInt32(i); } if (dr[++i] != DBNull.Value) { model.Frozen = dr.GetInt32(i); } if (dr[++i] != DBNull.Value) { model.isSell = dr.GetInt32(i); } list.Add(model); } parameters.Clear(); return(list); } }
public ShiMiao.Model.m_Sell_Goods GetModel(string goodsID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select GoodsID, OrgID, Title, Content, Amount, Balance, Price, CreateTime, OrderIndex, StateCode,Frozen,isSell "); strSql.Append(" from TD_Sell_Goods "); strSql.Append(" where GoodsID=@GoodsID and isSell=1"); MySqlParameter[] parameters = { new MySqlParameter("@GoodsID", goodsID) }; ShiMiao.Model.m_Sell_Goods model = null; using (DbDataReader dr = MySqlHelperUtil.ExecuteReader(strSql.ToString(), parameters)) { if (dr.Read()) { model = new ShiMiao.Model.m_Sell_Goods(); int i = -1; if (dr[++i] != DBNull.Value) { model.GoodsID = dr.GetString(i); } if (dr[++i] != DBNull.Value) { model.OrgID = dr.GetInt32(i); } if (dr[++i] != DBNull.Value) { model.Title = dr.GetString(i); } if (dr[++i] != DBNull.Value) { model.Content = dr.GetString(i); } if (dr[++i] != DBNull.Value) { model.Amount = dr.GetInt32(i); } if (dr[++i] != DBNull.Value) { model.Balance = dr.GetInt32(i); } if (dr[++i] != DBNull.Value) { model.Price = dr.GetDecimal(i); } if (dr[++i] != DBNull.Value) { model.CreateTime = dr.GetDateTime(i); } if (dr[++i] != DBNull.Value) { model.OrderIndex = dr.GetInt32(i); } if (dr[++i] != DBNull.Value) { model.StateCode = dr.GetInt32(i); } if (dr[++i] != DBNull.Value) { model.Frozen = dr.GetInt32(i); } if (dr[++i] != DBNull.Value) { model.isSell = dr.GetInt32(i); } } return(model); } }