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