/// <summary>
/// 从一个MySqlDataReader里读数据
/// </summary>
/// <param name="Reader">MySqlDataReader</param>
/// <returns>basic_goods_wordExample</returns>
public static basic_goods_word GetByReader(MySqlDataReader Reader)
{
basic_goods_word basic_goods_wordExample = new basic_goods_word();
basic_goods_wordExample.gwid = Reader["gwid"] == DBNull.Value ? 0 : (int)Reader["gwid"];
basic_goods_wordExample.gwname = Reader["gwname"] == DBNull.Value ? null : Reader["gwname"].ToString();
basic_goods_wordExample.bgid = Reader["bgid"] == DBNull.Value ? 0 : (int)Reader["bgid"];
basic_goods_wordExample.bgname = Reader["bgname"] == DBNull.Value ? null : Reader["bgname"].ToString();
basic_goods_wordExample.gwdate = Reader["gwdate"] == DBNull.Value ? new DateTime() : Convert.ToDateTime(Reader["gwdate"]);
basic_goods_wordExample.gwnum = Reader["gwnum"] == DBNull.Value ? 0 : (int)Reader["gwnum"];
basic_goods_wordExample.gwstate = Reader["gwstate"] == DBNull.Value ? null : Reader["gwstate"].ToString();
basic_goods_wordExample.gwremark = Reader["gwremark"] == DBNull.Value ? null : Reader["gwremark"].ToString();
return(basic_goods_wordExample);
}
/// <summary>
/// 查询全部数据
/// </summary>
/// <returns>IList</returns>
/*查看是否为视图*/
public IList <basic_goods_word> SearchAll()
{
DBHelper.sqlstr = "select * from basic_goods_word ";
List <basic_goods_word> list = new List <basic_goods_word>();
MySqlDataReader reader = DBHelper.ExecuteReader();
while (reader.Read())
{
basic_goods_word Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
/// <summary>
/// 根据gwid,查询一条数据
/// </summary>
/// <param name="gwid">补单关键词编号</param>
/// <returns></returns>
/*查看是否为视图*/
public basic_goods_word SearchByID(int gwid)
{
DBHelper.sqlstr = "select * from basic_goods_word where gwid = @gwid";
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("@gwid", gwid)
};
MySqlDataReader reader = DBHelper.ExecuteReader(param);
basic_goods_word Obj = null;
if (reader.Read())
{
Obj = GetByReader(reader);
}
reader.Close();
return(Obj);
}
/// <summary>
/// 搜索条件
/// </summary>
/// <param name="s">开始位置</param>
/// <param name="e">结束位置</param>
/// <param name="key">关键词</param>
/// <param name="bgid">商品编号</param>
/// <param name="state">状态</param>
/// <param name="bgkey">是否重点</param>
/// <param name="dt1_add">添加时间</param>
/// <param name="dt2_add">添加时间</param>
/// <param name="orderby">排序方式,直接输入order by后面的语句</param>
/// <returns>IList<basic_goods_word></returns>
public IList <basic_goods_word> Search(int s, int e, string key, int bgid, string state, string bgkey, DateTime dt1_add, DateTime dt2_add, string orderby)
{
string sql1 = "select top " + (e - s + 1).ToString() + " * from basic_goods_word where ";
string sql2 = string.IsNullOrEmpty(key) ? " 1=1 " : " ( gwname like '%" + key + "%' or bgname like '%" + key + "%' or gwremark like '%" + key + "%' ) ";
string sql3 = bgid == 0 ? "" : " and bgid=" + bgid.ToString();
string sql4 = string.IsNullOrEmpty(state) ? "" : " and gwstate= '" + state + "' ";
string sql5 = dt1_add == new DateTime() ? "" : " and datediff(d,'" + dt1_add.ToString() + "',gwdate)>=0 ";
string sql6 = dt2_add == new DateTime() ? "" : " and datediff(d,'" + dt2_add.ToString() + "',gwdate)<=0 ";
string sql7 = string.IsNullOrEmpty(orderby) ? " order by gwdate desc " : " order by " + orderby;
string sql8 = s == 1 ? "" : " and gwid not in ( select top " + (s - 1).ToString() + " gwid from basic_goods_word where " + sql2 + sql3 + sql4 + sql5 + sql6 + " ) ";
DBHelper.sqlstr = sql1 + sql2 + sql3 + sql4 + sql5 + sql6 + sql8 + sql7;
List <basic_goods_word> list = new List <basic_goods_word>();
SqlDataReader reader = DBHelper.ExecuteReader();
while (reader.Read())
{
basic_goods_word Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="basic_goods_word">basic_goods_word表实例</param>
/// <returns>int</returns>
public int Update(basic_goods_word basic_goods_wordExample)
{
DBHelper.sqlstr = "update basic_goods_word set gwname=@gwname,bgid=@bgid,bgname=@bgname,gwdate=@gwdate,gwnum=@gwnum,gwstate=@gwstate,gwremark=@gwremark where gwid=" + basic_goods_wordExample.gwid;
return(DBHelper.ExecuteNonQuery(GetSqlParameters(basic_goods_wordExample)));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="basic_goods_word">basic_goods_word表实例</param>
/// <returns>int</returns>
public int Insert(basic_goods_word basic_goods_wordExample)
{
DBHelper.sqlstr = "insert into basic_goods_word (gwname,bgid,bgname,gwdate,gwnum,gwstate,gwremark)values(@gwname,@bgid,@bgname,@gwdate,@gwnum,@gwstate,@gwremark)";
return(DBHelper.ExecuteNonQuery(GetSqlParameters(basic_goods_wordExample)));
}
/// <summary>
/// 根据表,获取一个MySqlParameter数组
/// </summary>
/// <returns>MySqlParameter[]</returns>
public static MySqlParameter[] GetSqlParameters(basic_goods_word basic_goods_wordExample)
{
List <MySqlParameter> list_param = new List <MySqlParameter>();
if (!string.IsNullOrEmpty(basic_goods_wordExample.gwname))
{
list_param.Add(new MySqlParameter("@gwname", basic_goods_wordExample.gwname));
}
else
{
list_param.Add(new MySqlParameter("@gwname", DBNull.Value));
}
if (basic_goods_wordExample.bgid != 0)
{
list_param.Add(new MySqlParameter("@bgid", basic_goods_wordExample.bgid));
}
else
{
list_param.Add(new MySqlParameter("@bgid", DBNull.Value));
}
if (!string.IsNullOrEmpty(basic_goods_wordExample.bgname))
{
list_param.Add(new MySqlParameter("@bgname", basic_goods_wordExample.bgname));
}
else
{
list_param.Add(new MySqlParameter("@bgname", DBNull.Value));
}
if (basic_goods_wordExample.gwdate != new DateTime() && basic_goods_wordExample.gwdate != null)
{
list_param.Add(new MySqlParameter("@gwdate", basic_goods_wordExample.gwdate.ToString("yyyy-MM-dd")));
}
else
{
list_param.Add(new MySqlParameter("@gwdate", DBNull.Value));
}
if (basic_goods_wordExample.gwnum != 0)
{
list_param.Add(new MySqlParameter("@gwnum", basic_goods_wordExample.gwnum));
}
else
{
list_param.Add(new MySqlParameter("@gwnum", DBNull.Value));
}
if (!string.IsNullOrEmpty(basic_goods_wordExample.gwstate))
{
list_param.Add(new MySqlParameter("@gwstate", basic_goods_wordExample.gwstate));
}
else
{
list_param.Add(new MySqlParameter("@gwstate", DBNull.Value));
}
if (!string.IsNullOrEmpty(basic_goods_wordExample.gwremark))
{
list_param.Add(new MySqlParameter("@gwremark", basic_goods_wordExample.gwremark));
}
else
{
list_param.Add(new MySqlParameter("@gwremark", DBNull.Value));
}
MySqlParameter[] param = new MySqlParameter[list_param.Count];
int index = 0;
foreach (MySqlParameter p in list_param)
{
param[index] = p;
index++;
}
return(param);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="basic_goods_word">basic_goods_word表实例</param>
/// <returns>int</returns>
public static int Update(basic_goods_word basic_goods_wordExample)
{
return(Service.Update(basic_goods_wordExample));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="basic_goods_word">basic_goods_word表实例</param>
/// <returns>int</returns>
public static int Insert(basic_goods_word basic_goods_wordExample)
{
return(Service.Insert(basic_goods_wordExample));
}
