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