/// <summary>
/// 根据表,获取一个MySqlParameter数组
/// </summary>
/// <returns>MySqlParameter[]</returns>
public static MySqlParameter[] GetSqlParameter(yh_corekeys yh_corekeysExample)
{
List <MySqlParameter> list_param = new List <MySqlParameter>();
if (!string.IsNullOrEmpty(yh_corekeysExample.ckname))
{
list_param.Add(new MySqlParameter("@ckname", yh_corekeysExample.ckname));
}
else
{
list_param.Add(new MySqlParameter("@ckname", DBNull.Value));
}
if (!string.IsNullOrEmpty(yh_corekeysExample.ckremark))
{
list_param.Add(new MySqlParameter("@ckremark", yh_corekeysExample.ckremark));
}
else
{
list_param.Add(new MySqlParameter("@ckremark", DBNull.Value));
}
if (!string.IsNullOrEmpty(yh_corekeysExample.cksort))
{
list_param.Add(new MySqlParameter("@cksort", yh_corekeysExample.cksort));
}
else
{
list_param.Add(new MySqlParameter("@cksort", DBNull.Value));
}
if (!string.IsNullOrEmpty(yh_corekeysExample.ckstate))
{
list_param.Add(new MySqlParameter("@ckstate", yh_corekeysExample.ckstate));
}
else
{
list_param.Add(new MySqlParameter("@ckstate", DBNull.Value));
}
if (!string.IsNullOrEmpty(yh_corekeysExample.gtid))
{
list_param.Add(new MySqlParameter("@gtid", yh_corekeysExample.gtid));
}
else
{
list_param.Add(new MySqlParameter("@gtid", 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 name = txt_name.Text.Trim();
string remark = txt_remark.Text.Trim();
string state = ddl_state.SelectedValue.ToString();
string gt = ddl_goodstype.SelectedValue;
string sort = txt_sort.Text.Trim();
yh_corekeys ck = new yh_corekeys();
if (!string.IsNullOrEmpty(id))
{
ck = BLL.yh_corekeysManager.SearchByckid(Convert.ToInt32(id));
}
else
{
ck.ckdate = DateTime.Now;
}
ck.ckname = name;
ck.ckremark = remark;
ck.cksort = sort;
ck.ckstate = state;
ck.gtid = gt;
int res;
if (string.IsNullOrEmpty(id))
{
res = BLL.yh_corekeysManager.Insert(ck);
}
else
{
res = BLL.yh_corekeysManager.Update(ck);
}
if (res == 1)
{
Manager.Alert("保存成功", Page);
}
else
{
Manager.Alert("保存失败", Page);
}
}
catch (Exception ex)
{
Manager.Alert(ex.ToString());
}
Manager.page_href_reload(Page);
}
/// <summary>
/// 从一个MySqlDataReader里读数据
/// </summary>
/// <param name="Reader">MySqlDataReader</param>
/// <returns>yh_corekeysExample</returns>
public static yh_corekeys GetByReader(MySqlDataReader Reader)
{
yh_corekeys yh_corekeysExample = new yh_corekeys();
yh_corekeysExample.ckdate = Reader["ckdate"] == DBNull.Value ? new DateTime() : Convert.ToDateTime(Reader["ckdate"]);
yh_corekeysExample.ckid = Reader["ckid"] == DBNull.Value ? 0 : (int)Reader["ckid"];
yh_corekeysExample.ckname = Reader["ckname"] == DBNull.Value ? null : Reader["ckname"].ToString();
yh_corekeysExample.ckremark = Reader["ckremark"] == DBNull.Value ? null : Reader["ckremark"].ToString();
yh_corekeysExample.cksort = Reader["cksort"] == DBNull.Value ? null : Reader["cksort"].ToString();
yh_corekeysExample.ckstate = Reader["ckstate"] == DBNull.Value ? null : Reader["ckstate"].ToString();
yh_corekeysExample.gtid = Reader["gtid"] == DBNull.Value ? null : Reader["gtid"].ToString();
return(yh_corekeysExample);
}
/// <summary>
/// 查询全部数据
/// </summary>
/// <returns>IList</returns>
/*查看是否为视图*/
public IList <yh_corekeys> SearchAll()
{
DBHelper.sqlstr = "select * from yh_corekeys order by cksort asc,ckdate desc ";
List <yh_corekeys> list = new List <yh_corekeys>();
MySqlDataReader reader = DBHelper.ExecuteReader();
while (reader.Read())
{
yh_corekeys Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
protected void btn_quickadd_Click(object sender, EventArgs e)
{
string str = txt_quickadd.Text.Trim();
string remark = txt_remark.Text.Trim();
string state = ddl_state.SelectedValue.ToString();
string gt = ddl_goodstype.SelectedValue;
string sort = txt_sort.Text.Trim();
yh_corekeys ck = new yh_corekeys();
ck.ckremark = remark;
ck.cksort = sort;
ck.ckstate = state;
ck.gtid = gt;
int res1 = 0;
int res2 = 0;
if (string.IsNullOrEmpty(str))
{
return;
}
try
{
string[] ss = str.Split(new char[] { '\n', '\r' }, StringSplitOptions.RemoveEmptyEntries);
foreach (string s in ss)
{
string temp = s.Trim();
if (!string.IsNullOrEmpty(temp))
{
ck.ckname = temp;
ck.ckdate = DateTime.Now;
if (BLL.yh_corekeysManager.Insert(ck) == 1)
{
res1++;
}
else
{
res2++;
}
}
}
Manager.Alert("批处理操作完成:\\n成功添加 " + res1.ToString() + " 条信息" + (res2 == 0 ? "" : "\\n添加失败" + res2.ToString() + "条信息！请注意核实！"), Page);
}
catch (Exception ex)
{
Manager.Alert(ex.ToString(), Page);
}
}
/// <summary>
/// 根据ckid,查询一条数据
/// </summary>
/// <param name="ckid">核心关键词ID</param>
/// <returns></returns>
public yh_corekeys SearchByckid(int ckid)
{
DBHelper.sqlstr = "select * from yh_corekeys where ckid = @ckid";
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("@ckid", ckid)
};
MySqlDataReader reader = DBHelper.ExecuteReader(param);
yh_corekeys Obj = null;
if (reader.Read())
{
Obj = GetByReader(reader);
}
reader.Close();
return(Obj);
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox txt_name = GridView1.Rows[e.RowIndex].FindControl("txt_name") as TextBox;
TextBox txt_remark = GridView1.Rows[e.RowIndex].FindControl("txt_remark") as TextBox;
TextBox txt_sort = GridView1.Rows[e.RowIndex].FindControl("txt_sort") as TextBox;
int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values["ckid"]);
yh_corekeys ck = BLL.yh_corekeysManager.SearchByckid(id);
ck.ckname = string.IsNullOrEmpty(txt_name.Text) ? "" : txt_name.Text.Trim();
ck.ckremark = string.IsNullOrEmpty(txt_name.Text) ? "" : txt_remark.Text.Trim();
ck.cksort = string.IsNullOrEmpty(txt_sort.Text) ? "" : txt_sort.Text.Trim();
if (BLL.yh_corekeysManager.Update(ck) != 1)
{
AJAXManager.Alert(this.UpdatePanel1, "修改失败");
}
else
{
GridView1.EditIndex = -1;
bind();
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
string state = e.CommandName;
if (state == "state")
{
int id = Convert.ToInt32(GridView1.DataKeys[((e.CommandSource as LinkButton).NamingContainer as GridViewRow).RowIndex].Values["ckid"].ToString());
if (id != 0)
{
yh_corekeys ck = BLL.yh_corekeysManager.SearchByckid(id);
ck.ckstate = ck.ckstate == "1" ? "2" : "1";
if (BLL.yh_corekeysManager.Update(ck) != 1)
{
AJAXManager.Alert(this.UpdatePanel1, "修改失败");
}
else
{
GridView1.EditIndex = -1;
bind();
}
}
}
}
/// <summary>
/// 条件搜索
/// </summary>
/// <param name="s">起始位置</param>
/// <param name="e">结束位置</param>
/// <param name="key">关键词</param>
/// <param name="gt">商品类型</param>
/// <param name="state">状态 空:不查,1:启用,2:禁用</param>
/// <param name="dt1_add">添加商品起始时间</param>
/// <param name="dt2_add">添加商品结束时间</param>
/// <param name="orderby">排序方式,直接输入order by后面的语句</param>
/// <returns>IList<goods></returns>
public IList <yh_corekeys> Search(int s, int e, string key, int gt, string state, DateTime dt1_add, DateTime dt2_add, string orderby)
{
string sql1 = "select top " + (e - s + 1).ToString() + " * from yh_corekeys where ";
string sql2 = string.IsNullOrEmpty(key) ? " 1=1 " : " ( ckname like '%" + key + "%' or ckremark like '%" + key + "%' ) ";
string sql3 = gt == 0 ? "" : " and gtid='" + gt.ToString() + "' ";
string sql4 = string.IsNullOrEmpty(state) ? "" : " and ckstate= '" + state + "' ";
string sql5 = dt1_add == new DateTime() ? "" : " and datediff(d,'" + dt1_add.ToString() + "',ckdate)>=0 ";
string sql6 = dt2_add == new DateTime() ? "" : " and datediff(d,'" + dt2_add.ToString() + "',ckdate)<=0 ";
string sql8 = string.IsNullOrEmpty(orderby) ? " order by cksort asc,ckdate desc " : " order by " + orderby;
string sql7 = s == 1 ? "" : " and ckid not in ( select top " + (s - 1).ToString() + " ckid from yh_corekeys where " + sql2 + sql3 + sql4 + sql5 + sql6 + sql8 + " ) ";
DBHelper.sqlstr = sql1 + sql2 + sql3 + sql4 + sql5 + sql6 + sql7 + sql8;
List <yh_corekeys> list = new List <yh_corekeys>();
SqlDataReader reader = DBHelper.ExecuteReader();
while (reader.Read())
{
yh_corekeys 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))
{
yh_corekeys ck = yh_corekeysManager.SearchByckid(temp);
if (ck != null)
{
try
{
txt_name.Text = ck.ckname;
txt_remark.Text = ck.ckremark;
txt_sort.Text = ck.cksort;
lbl_date.Text = ck.ckdate.ToString();
ddl_goodstype.SelectedValue = ck.gtid.ToString();
ddl_state.SelectedValue = ck.ckstate;
}
catch { }
}
}
}
}
protected void btn_save_Click(object sender, EventArgs e)
{
try
{
//string name = txt_name.Text.Trim();
//string remark = txt_remark.Text.Trim();
//txt_name.Text = k.kname;
//txt_dianjilv.Text = k.kdianjilv.ToString();
//txt_dianjizhanbi.Text = k.kscdianjizhanbi.ToString();
//txt_dianjizhishu.Text = k.kdianjizhishu.ToString();
//txt_remark.Text = k.kremark;
//txt_shangpinshuliang.Text = k.kgoodsnum.ToString();
//txt_sousuocishu.Text = k.kcishu.ToString();
//txt_sousuorenshu.Text = k.krenshu.ToString();
//txt_sousuozhanbi.Text = k.ksousuozhanbi.ToString();
//txt_zhitongche.Text = k.kzhitongche.ToString();
//txt_zhuanhualv.Text = k.kzhuanhualv.ToString();
//lbl_dangebaobeisousuocishu.Text = k.kdgbbsscs.ToString();
//lbl_qiangebaobeichengjiaocishu.Text = k.kqgbbcjcs.ToString();
//lbl_date.Text = k.kdate.ToString();
//ddl_state.SelectedValue = k.kstate;
yh_corekeys ck = new yh_corekeys();
if (!string.IsNullOrEmpty(id))
{
ck = BLL.yh_corekeysManager.SearchByckid(Convert.ToInt32(id));
}
else
{
ck.ckdate = DateTime.Now;
}
//ck.ckname = name;
//ck.ckremark = remark;
//ck.cksort = sort;
//ck.ckstate = state;
//ck.gtid = gt;
int res;
if (string.IsNullOrEmpty(id))
{
res = BLL.yh_corekeysManager.Insert(ck);
}
else
{
res = BLL.yh_corekeysManager.Update(ck);
}
if (res == 1)
{
Manager.Alert("保存成功", Page);
}
else
{
Manager.Alert("保存失败", Page);
}
}
catch (Exception ex)
{
Manager.Alert(ex.ToString());
}
Manager.page_href_reload(Page);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="yh_corekeys">yh_corekeys表实例</param>
/// <returns>int</returns>
public static int Update(yh_corekeys yh_corekeysExample)
{
return(Service.Update(yh_corekeysExample));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="yh_corekeys">yh_corekeys表实例</param>
/// <returns>int</returns>
public static int Insert(yh_corekeys yh_corekeysExample)
{
return(Service.Insert(yh_corekeysExample));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="yh_corekeys">yh_corekeys表实例</param>
/// <returns>int</returns>
public int Update(yh_corekeys yh_corekeysExample)
{
DBHelper.sqlstr = "update yh_corekeys set ckdate='" + yh_corekeysExample.ckdate.ToString() + "',ckname=@ckname,ckremark=@ckremark,cksort=@cksort,ckstate=@ckstate,gtid=@gtid where ckid=" + yh_corekeysExample.ckid;
return(DBHelper.ExecuteNonQuery(GetSqlParameter(yh_corekeysExample)));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="yh_corekeys">yh_corekeys表实例</param>
/// <returns>int</returns>
public int Insert(yh_corekeys yh_corekeysExample)
{
DBHelper.sqlstr = "insert into yh_corekeys (ckdate,ckname,ckremark,cksort,ckstate,gtid)values('" + yh_corekeysExample.ckdate.ToString() + "',@ckname,@ckremark,@cksort,@ckstate,@gtid)";
return(DBHelper.ExecuteNonQuery(GetSqlParameter(yh_corekeysExample)));
}
