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