protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { int ClickNowSort = 0; int RdyChangeSort = 0; int i = 0; Button btnClick; Button btnRdyChange; if (e.CommandName == "btnSortUp") { if (int.Parse(e.CommandArgument.ToString()) > 0) { btnClick = (Button)GridView1.Rows[int.Parse(e.CommandArgument.ToString())].FindControl("Button2"); btnRdyChange = (Button)GridView1.Rows[int.Parse(e.CommandArgument.ToString()) - 1].FindControl("Button2"); GBCategoryInfo pdClick = gbcBLL.GetDataById(int.Parse(btnClick.CommandArgument.ToString())); GBCategoryInfo pdChange = gbcBLL.GetDataById(int.Parse(btnRdyChange.CommandArgument.ToString())); ClickNowSort = pdClick.gbc_sort; RdyChangeSort = pdChange.gbc_sort; pdClick.gbc_sort = RdyChangeSort; pdChange.gbc_sort = ClickNowSort; if ((i = gbcBLL.Update(pdClick) + gbcBLL.Update(pdChange)) > 1) { ShowMessage("排序成功"); ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("qbc_title", txtKeyWord.Text, "")); } } else { ShowMessage("此項目排序已是第一位"); } } if (e.CommandName == "btnSortDown") { if (int.Parse(e.CommandArgument.ToString()) < GridView1.Rows.Count - 1) { btnClick = (Button)GridView1.Rows[int.Parse(e.CommandArgument.ToString())].FindControl("Button2"); btnRdyChange = (Button)GridView1.Rows[int.Parse(e.CommandArgument.ToString()) + 1].FindControl("Button2"); GBCategoryInfo pdClick = gbcBLL.GetDataById(int.Parse(btnClick.CommandArgument.ToString())); GBCategoryInfo pdChange = gbcBLL.GetDataById(int.Parse(btnRdyChange.CommandArgument.ToString())); ClickNowSort = pdClick.gbc_sort; RdyChangeSort = pdChange.gbc_sort; pdClick.gbc_sort = RdyChangeSort; pdChange.gbc_sort = ClickNowSort; if ((i = gbcBLL.Update(pdClick) + gbcBLL.Update(pdChange)) > 1) { ShowMessage("排序成功"); ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("qbc_title", txtKeyWord.Text, "")); } } else { ShowMessage("此項目排序已是最後一位"); } } }
public List <GBCategoryInfo> GetDataBySort(int sort) { List <GBCategoryInfo> infos = new List <GBCategoryInfo>(); IDataReader reader = db.GetDataBySort(sort).CreateDataReader(); while (reader.Read()) { infos.Add(GBCategoryInfo.Populate(reader)); } return(infos); }
public GBCategoryInfo GetDataById(int gbc_id) { GBCategoryInfo info = new GBCategoryInfo(); IDataReader reader = db.GetDataById(gbc_id).CreateDataReader(); if (reader.Read()) { info = GBCategoryInfo.Populate(reader); } return(info); }
protected void btnSubmit_Click(object sender, EventArgs e) { GBCategoryInfo info = new GBCategoryInfo(); info.gbc_title = txtName.Text; info.gbc_show = bool.Parse(rbShow.SelectedValue); if (gbcBLL.Insert(info) > 0) { Response.Redirect("List.aspx?header=" + Getmessage("30009")); } }
public int InsertSorting() { GBCategoryInfo info = new GBCategoryInfo(); IDataReader reader = db.InsertSorting().CreateDataReader(); if (reader.Read()) { info = GBCategoryInfo.Populate(reader); return(info.gbc_sort + 1); } return(1); }
protected void Bind() { if (id != 0) { if (Tools.TryParseMethod(id.ToString()) > 0) { GBCategoryInfo info = gbcBLL.GetDataById(id); txtName.Text = info.gbc_title; rbShow.SelectedValue = info.gbc_show.ToString(); } } }
public static GBCategoryInfo Populate(IDataReader reader) { GBCategoryInfo info = new GBCategoryInfo(); for (int i = 0; i < reader.FieldCount; i++) { PropertyInfo property = info.GetType().GetProperty(reader.GetName(i)); Type propType = property.PropertyType; TypeConverters.ITypeConverter typeConverter = TypeConverters.TypeConverterFactory.GetConvertType(propType); property.SetValue(info, Convert.ChangeType(typeConverter.Convert(reader.GetValue(i)), propType), null); } return(info); }
public int Delete(int gbc_id) { GBCategoryInfo info = GetDataById(gbc_id); List <GBCategoryInfo> infos = GetDataBySort(info.gbc_sort); foreach (GBCategoryInfo sortinfos in infos) { db.Update(sortinfos.gbc_title, sortinfos.gbc_sort - 1, sortinfos.gbc_show, sortinfos.gbc_id); } //連動刪除GBmessage List <GBmessageInfo> GBinfos = gbBLL.GetDataByCategoryId(gbc_id); foreach (GBmessageInfo gbInfosD in GBinfos) { gbBLL.Delete(gbInfosD.gb_ID); } return(db.Delete(gbc_id)); }
public int Update(GBCategoryInfo info) { return(db.Update(info.gbc_title, info.gbc_sort, info.gbc_show, info.gbc_id)); }
public int Insert(GBCategoryInfo info) { return(db.Insert(info.gbc_title, InsertSorting(), info.gbc_show)); }