/// <summary>
/// 搜索条件
/// </summary>
/// <param name="s">开始位置</param>
/// <param name="e">结束位置</param>
/// <param name="key">关键词</param>
/// <param name="opid">补单计划编号</param>
/// <param name="hdid">活动编号</param>
/// <param name="dpid">店铺编号</param>
/// <param name="state">状态 1是 2否</param>
/// <param name="bgkey">知否重点 1是 2否</param>
/// <param name="dt1_up">上架时间</param>
/// <param name="dt2_up">上架时间2</param>
/// <param name="dt1_add">添加时间</param>
/// <param name="dt2_add">添加时间2</param>
/// <param name="orderby">排序方式,直接输入order by后面的语句</param>
/// <returns>IList<basic_goods></returns>
public IList <basic_goods> Search(int s, int e, string key, int opid, int hdid, int dpid, string state, string bgkey, DateTime dt1_up, DateTime dt2_up, DateTime dt1_add, DateTime dt2_add, string orderby)
{
string sql1 = "select * from basic_goods where ";
string sql2 = string.IsNullOrEmpty(key) ? " 1=1 " : " ( bgname like '%" + key + "%' or bgurl like '%" + key + "%' or dpname like '%" + key + "%' or bgremark like '%" + key + "%' ) ";
string sql3 = opid == 0 ? "" : " and opid=" + opid.ToString();
string sql4 = hdid == 0 ? "" : " and hdid=" + hdid.ToString();
string sql5 = dpid == 0 ? "" : " and dpid=" + dpid.ToString();
string sql6 = string.IsNullOrEmpty(state) ? "" : " and bgstate= '" + state + "' ";
string sql7 = string.IsNullOrEmpty(bgkey) ? "" : " and bgkey= '" + bgkey + "' ";
string sql8 = dt1_up == new DateTime() ? "" : " and datediff(d,'" + dt1_up.ToString() + "',bgupdate)>=0 ";
string sql9 = dt2_up == new DateTime() ? "" : " and datediff(d,'" + dt2_up.ToString() + "',bgupdate)<=0 ";
string sql10 = dt1_add == new DateTime() ? "" : " and datediff(d,'" + dt1_add.ToString() + "',bgdate)>=0 ";
string sql11 = dt2_add == new DateTime() ? "" : " and datediff(d,'" + dt2_add.ToString() + "',bgdate)<=0 ";
string sql12 = string.IsNullOrEmpty(orderby) ? " order by bgkey asc,bgdate desc " : " order by " + orderby;
;
string sql15 = e == 0 ? " " : " limit " + s + "," + e;
DBHelper.sqlstr = sql1 + sql2 + sql3 + sql4 + sql5 + sql6 + sql7 + sql8 + sql9 + sql10 + sql11 + sql12 + sql15;
List <basic_goods> list = new List <basic_goods>();
MySqlDataReader reader = DBHelper.ExecuteReader();
while (reader.Read())
{
basic_goods Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
void bind()
{
if (!string.IsNullOrEmpty(id))
{
int temp = 0;
if (int.TryParse(id, out temp))
{
basic_goods dp = basic_goodsManager.SearchByID(temp);
if (dp != null)
{
try
{
ddl_basic_huodong.SelectedValue = dp.hdid.ToString();
ddl_dianpu.SelectedValue = dp.dpid.ToString();
ddl_order_plan.SelectedValue = dp.opid.ToString();
txt_remark.Text = dp.bgremark;
txt_time.Text = dp.bgupdate.ToString("yyyy-MM-dd HH:mm");
txt_title.Text = dp.bgname;
txt_url.Text = dp.bgurl;
ddl_state.SelectedValue = dp.bgstate;
lb_date.Text = dp.bgdate.ToString();
ddl_key.SelectedValue = dp.bgkey;
}
catch { }
}
}
}
else
{
txt_time.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
}
}
/// <summary>
/// 查询全部数据
/// </summary>
/// <returns>IList</returns>
/*查看是否为视图*/
public IList <basic_goods> SearchAll()
{
DBHelper.sqlstr = "select * from basic_goods ";
List <basic_goods> list = new List <basic_goods>();
MySqlDataReader reader = DBHelper.ExecuteReader();
while (reader.Read())
{
basic_goods Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
/// <summary>
/// 根据bgid,查询一条数据
/// </summary>
/// <param name="bgid">编号</param>
/// <returns></returns>
/*查看是否为视图*/
public basic_goods SearchByID(int bgid)
{
DBHelper.sqlstr = "select * from basic_goods where bgid = @bgid";
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("@bgid", bgid)
};
MySqlDataReader reader = DBHelper.ExecuteReader(param);
basic_goods Obj = null;
if (reader.Read())
{
Obj = GetByReader(reader);
}
reader.Close();
return(Obj);
}
protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e)
{
string state = e.CommandName;
if (state == "state")
{
int id = Convert.ToInt32(GridView2.DataKeys[((e.CommandSource as LinkButton).NamingContainer as GridViewRow).RowIndex].Values["bgid"].ToString());
if (id != 0)
{
basic_goods fx = BLL.basic_goodsManager.SearchByID(id);
fx.bgstate = fx.bgstate == "1" ? "2" : "1";
if (fx.bgstate == "2")
{
//fx.bgdate = DateTime.Now;
}
if (BLL.basic_goodsManager.Update(fx) != 1)
{
AJAXManager.Alert(this.UpdatePanel1, "修改失败");
}
else
{
bind_goods();
}
}
}
else if (state == "iskey")
{
int id = Convert.ToInt32(GridView2.DataKeys[((e.CommandSource as LinkButton).NamingContainer as GridViewRow).RowIndex].Values["bgid"].ToString());
if (id != 0)
{
basic_goods fx = BLL.basic_goodsManager.SearchByID(id);
fx.bgkey = fx.bgkey == "1" ? "2" : "1";
//fx.bgdate = DateTime.Now;
if (BLL.basic_goodsManager.Update(fx) != 1)
{
AJAXManager.Alert(this.UpdatePanel1, "修改失败");
}
else
{
bind_goods();
}
//AJAXManager.Alert(UpdatePanel1, "test");
//AJAXManager.Js(UpdatePanel1, "to_zhifubao('" + fx.fx_zhifubao + "','" + fx.fx_num + "')");
}
}
}
/// <summary>
/// 从一个MySqlDataReader里读数据
/// </summary>
/// <param name="Reader">MySqlDataReader</param>
/// <returns>basic_goodsExample</returns>
public static basic_goods GetByReader(MySqlDataReader Reader)
{
basic_goods basic_goodsExample = new basic_goods();
basic_goodsExample.bgid = Reader["bgid"] == DBNull.Value ? 0 : (int)Reader["bgid"];
basic_goodsExample.bgname = Reader["bgname"] == DBNull.Value ? null : Reader["bgname"].ToString();
basic_goodsExample.bgurl = Reader["bgurl"] == DBNull.Value ? null : Reader["bgurl"].ToString();
basic_goodsExample.bgupdate = Reader["bgupdate"] == DBNull.Value ? new DateTime() : Convert.ToDateTime(Reader["bgupdate"]);
basic_goodsExample.opid = Reader["opid"] == DBNull.Value ? 0 : (int)Reader["opid"];
basic_goodsExample.hdid = Reader["hdid"] == DBNull.Value ? 0 : (int)Reader["hdid"];
basic_goodsExample.dpid = Reader["dpid"] == DBNull.Value ? 0 : (int)Reader["dpid"];
basic_goodsExample.dpname = Reader["dpname"] == DBNull.Value ? null : Reader["dpname"].ToString();
basic_goodsExample.bgstate = Reader["bgstate"] == DBNull.Value ? null : Reader["bgstate"].ToString();
basic_goodsExample.bgdate = Reader["bgdate"] == DBNull.Value ? new DateTime() : Convert.ToDateTime(Reader["bgdate"]);
basic_goodsExample.bgremark = Reader["bgremark"] == DBNull.Value ? null : Reader["bgremark"].ToString();
basic_goodsExample.bgkey = Reader["bgkey"] == DBNull.Value ? null : Reader["bgkey"].ToString();
return(basic_goodsExample);
}
void bind()
{
int temp_bgid = 0;
if (!string.IsNullOrEmpty(id))
{
int temp = 0;
if (int.TryParse(id, out temp))
{
basic_order_record dp = basic_order_recordManager.SearchByID(temp);
if (dp != null)
{
try
{
ddl_dianpu.SelectedValue = dp.dpid.ToString();
ddl_maijiaxiu.SelectedValue = dp.ormaijiaxiu;
ddl_state.SelectedValue = dp.orprepare1;
txt_key.Text = dp.gkname;
txt_price.Text = dp.orprice;
txt_qq.Text = dp.orqq;
txt_remark.Text = dp.orremark;
txt_title.Text = dp.bgname;
txt_wangwang.Text = dp.orwangwang;
txt_wuliu.Text = dp.bgwuliu;
txt_date1.Text = dp.ordate.ToString("yyyy-MM-dd");
txt_code.Text = dp.orcode;
}
catch { }
}
}
}
else if (int.TryParse(bgid, out temp_bgid))
{
basic_goods bg = BLL.basic_goodsManager.SearchByID(Convert.ToInt32(bgid));
ddl_dianpu.SelectedValue = bg.dpid.ToString();
txt_title.Text = bg.bgname;
}
else
{
Manager.Alert("请先选择商品", Page);
return;
}
}
protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox txt_name = GridView2.Rows[e.RowIndex].FindControl("txt_name") as TextBox;
TextBox txt_update = GridView2.Rows[e.RowIndex].FindControl("txt_update") as TextBox;
TextBox txt_remark = GridView2.Rows[e.RowIndex].FindControl("txt_remark") as TextBox;
int id = Convert.ToInt32(GridView2.DataKeys[e.RowIndex].Values["bgid"]);
basic_goods fx = BLL.basic_goodsManager.SearchByID(id);
if (string.IsNullOrEmpty(txt_name.Text))
{
AJAXManager.Alert(this.UpdatePanel1, "请输入商品名称");
return;
}
DateTime _dt = new DateTime();
if (!DateTime.TryParse(txt_update.Text, out _dt))
{
AJAXManager.Alert(this.UpdatePanel1, "请输入正确的上架时间");
return;
}
fx.bgname = txt_name.Text.Trim();
fx.bgupdate = _dt;
fx.bgremark = txt_remark.Text.Trim();
//fx.bgdate = DateTime.Now;
if (BLL.basic_goodsManager.Update(fx) != 1)
{
AJAXManager.Alert(this.UpdatePanel1, "修改失败");
}
else
{
GridView2.EditIndex = -1;
bind_goods();
}
}
protected void btn_save_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(bgid) && string.IsNullOrEmpty(id))
{
Manager.Alert("请先选择商品2", Page);
return;
}
else
{
basic_order_record or = new basic_order_record();
if (!string.IsNullOrEmpty(id))
{
or = BLL.basic_order_recordManager.SearchByID(Convert.ToInt32(id));
}
else
{
or.ordate = DateTime.Now;
}
basic_goods bg = new basic_goods();
if (!string.IsNullOrEmpty(bgid))
{
bg = BLL.basic_goodsManager.SearchByID(Convert.ToInt32(bgid));
}
//else if (!string.IsNullOrEmpty(id))
//{
// bg = BLL.basic_goodsManager.SearchByID(or.bgid);
//}
//else if (string.IsNullOrEmpty(id))
//{
// Manager.Alert("请先选择商品3", Page);
// return;
//}
DateTime dt = new DateTime();
string _dianpu = ddl_dianpu.SelectedValue;
string remark = txt_remark.Text.Trim();
string title = txt_title.Text.Trim();
string state = ddl_state.SelectedValue;
string maijiaxiu = ddl_maijiaxiu.SelectedValue;
string _key = txt_key.Text.Trim();
string price = txt_price.Text.Trim();
string qq = txt_qq.Text.Trim();
string wangwang = txt_wangwang.Text.Trim();
string wuliu = txt_wuliu.Text.Trim();
string code = txt_code.Text.Trim();
string dt1 = txt_date1.Text.Trim();
int dianpu = 0;
int.TryParse(_dianpu, out dianpu);
if (!DateTime.TryParse(dt1, out dt))
{
Manager.Alert("请输入正确的补单时间", Page);
return;
}
or.bgid = bg.bgid;
or.bgname = title;
or.dpid = bg.dpid;
or.dpname = bg.dpname;
or.gkname = _key;
or.bgwuliu = wuliu;
or.ormaijiaxiu = maijiaxiu;
or.orprepare1 = state;
or.orprice = price;
or.orqq = qq;
or.orremark = remark;
or.orwangwang = wangwang;
or.orcode = code;
or.ordate = dt;
int res;
if (string.IsNullOrEmpty(id))
{
res = BLL.basic_order_recordManager.Insert(or);
}
else
{
res = BLL.basic_order_recordManager.Update(or);
}
if (res == 1)
{
Manager.Alert("保存成功", Page);
}
else
{
Manager.Alert("保存失败", Page);
}
}
}
catch (Exception ex)
{
Manager.Alert(ex.ToString(), Page);
}
Manager.page_href_reload(Page);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="basic_goods">basic_goods表实例</param>
/// <returns>int</returns>
public int Update(basic_goods basic_goodsExample)
{
DBHelper.sqlstr = "update basic_goods set bgname=@bgname,bgurl=@bgurl,bgupdate=@bgupdate,opid=@opid,hdid=@hdid,dpid=@dpid,dpname=@dpname,bgstate=@bgstate,bgdate=@bgdate,bgremark=@bgremark,bgkey=@bgkey where bgid=" + basic_goodsExample.bgid;
return(DBHelper.ExecuteNonQuery(GetSqlParameters(basic_goodsExample)));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="basic_goods">basic_goods表实例</param>
/// <returns>int</returns>
public int Insert(basic_goods basic_goodsExample)
{
DBHelper.sqlstr = "insert into basic_goods (bgname,bgurl,bgupdate,opid,hdid,dpid,dpname,bgstate,bgdate,bgremark,bgkey)values(@bgname,@bgurl,@bgupdate,@opid,@hdid,@dpid,@dpname,@bgstate,@bgdate,@bgremark,@bgkey)";
return(DBHelper.ExecuteNonQuery(GetSqlParameters(basic_goodsExample)));
}
/// <summary>
/// 根据表,获取一个MySqlParameter数组
/// </summary>
/// <returns>MySqlParameter[]</returns>
public static MySqlParameter[] GetSqlParameters(basic_goods basic_goodsExample)
{
List <MySqlParameter> list_param = new List <MySqlParameter>();
if (!string.IsNullOrEmpty(basic_goodsExample.bgname))
{
list_param.Add(new MySqlParameter("@bgname", basic_goodsExample.bgname));
}
else
{
list_param.Add(new MySqlParameter("@bgname", DBNull.Value));
}
if (!string.IsNullOrEmpty(basic_goodsExample.bgurl))
{
list_param.Add(new MySqlParameter("@bgurl", basic_goodsExample.bgurl));
}
else
{
list_param.Add(new MySqlParameter("@bgurl", DBNull.Value));
}
if (basic_goodsExample.bgupdate != new DateTime() && basic_goodsExample.bgupdate != null)
{
list_param.Add(new MySqlParameter("@bgupdate", basic_goodsExample.bgupdate.ToString("yyyy-MM-dd")));
}
else
{
list_param.Add(new MySqlParameter("@bgupdate", DBNull.Value));
}
if (basic_goodsExample.opid != 0)
{
list_param.Add(new MySqlParameter("@opid", basic_goodsExample.opid));
}
else
{
list_param.Add(new MySqlParameter("@opid", DBNull.Value));
}
if (basic_goodsExample.hdid != 0)
{
list_param.Add(new MySqlParameter("@hdid", basic_goodsExample.hdid));
}
else
{
list_param.Add(new MySqlParameter("@hdid", DBNull.Value));
}
if (basic_goodsExample.dpid != 0)
{
list_param.Add(new MySqlParameter("@dpid", basic_goodsExample.dpid));
}
else
{
list_param.Add(new MySqlParameter("@dpid", DBNull.Value));
}
if (!string.IsNullOrEmpty(basic_goodsExample.dpname))
{
list_param.Add(new MySqlParameter("@dpname", basic_goodsExample.dpname));
}
else
{
list_param.Add(new MySqlParameter("@dpname", DBNull.Value));
}
if (!string.IsNullOrEmpty(basic_goodsExample.bgstate))
{
list_param.Add(new MySqlParameter("@bgstate", basic_goodsExample.bgstate));
}
else
{
list_param.Add(new MySqlParameter("@bgstate", DBNull.Value));
}
if (basic_goodsExample.bgdate != new DateTime() && basic_goodsExample.bgdate != null)
{
list_param.Add(new MySqlParameter("@bgdate", basic_goodsExample.bgdate.ToString("yyyy-MM-dd")));
}
else
{
list_param.Add(new MySqlParameter("@bgdate", DBNull.Value));
}
if (!string.IsNullOrEmpty(basic_goodsExample.bgremark))
{
list_param.Add(new MySqlParameter("@bgremark", basic_goodsExample.bgremark));
}
else
{
list_param.Add(new MySqlParameter("@bgremark", DBNull.Value));
}
if (!string.IsNullOrEmpty(basic_goodsExample.bgkey))
{
list_param.Add(new MySqlParameter("@bgkey", basic_goodsExample.bgkey));
}
else
{
list_param.Add(new MySqlParameter("@bgkey", DBNull.Value));
}
MySqlParameter[] param = new MySqlParameter[list_param.Count];
int index = 0;
foreach (MySqlParameter p in list_param)
{
param[index] = p;
index++;
}
return(param);
}
protected void btn_save_Click(object sender, EventArgs e)
{
try
{
string _huodong = ddl_basic_huodong.SelectedValue;
string _dianpu = ddl_dianpu.SelectedValue;
string dianpu_name = ddl_dianpu.Text;
string _order_plan = ddl_order_plan.SelectedValue;
string remark = txt_remark.Text.Trim();
string uptime = txt_time.Text.Trim();
string title = txt_title.Text.Trim();
string url = txt_url.Text.Trim();
string state = ddl_state.SelectedValue;
string key = ddl_key.SelectedValue;
if (string.IsNullOrEmpty(title))
{
Manager.Alert("请输入商品名称", Page);
Manager.TextBox_Select(txt_title);
return;
}
DateTime date1 = new DateTime();
if (!DateTime.TryParse(uptime, out date1))
{
Manager.Alert("请输入正确的时间", Page);
Manager.TextBox_Select(txt_time);
return;
}
int huodong = 0;
int dianpu = 0;
int order_plan = 0;
int.TryParse(_huodong, out huodong);
int.TryParse(_dianpu, out dianpu);
int.TryParse(_order_plan, out order_plan);
basic_goods dp = new basic_goods();
if (!string.IsNullOrEmpty(id))
{
dp = BLL.basic_goodsManager.SearchByID(Convert.ToInt32(id));
}
else
{
dp.bgdate = DateTime.Now;
}
dp.bgkey = key;
dp.bgname = title;
dp.bgremark = remark;
dp.bgstate = state;
dp.bgupdate = date1;
dp.bgurl = url;
dp.dpid = dianpu;
dp.dpname = dianpu_name;
dp.hdid = huodong;
dp.opid = order_plan;
int res;
if (string.IsNullOrEmpty(id))
{
res = BLL.basic_goodsManager.Insert(dp);
}
else
{
res = BLL.basic_goodsManager.Update(dp);
}
if (res == 1)
{
Manager.Alert("保存成功", Page);
}
else
{
Manager.Alert("保存失败", Page);
}
}
catch (Exception ex)
{
Manager.Alert(ex.ToString(), Page);
}
Manager.page_href_reload(Page);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="basic_goods">basic_goods表实例</param>
/// <returns>int</returns>
public static int Update(basic_goods basic_goodsExample)
{
return(Service.Update(basic_goodsExample));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="basic_goods">basic_goods表实例</param>
/// <returns>int</returns>
public static int Insert(basic_goods basic_goodsExample)
{
return(Service.Insert(basic_goodsExample));
}
