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");
QnaInfo pdClick = qBLL.GetDataById(int.Parse(btnClick.CommandArgument.ToString()));
QnaInfo pdChange = qBLL.GetDataById(int.Parse(btnRdyChange.CommandArgument.ToString()));
ClickNowSort = pdClick.q_sort;
RdyChangeSort = pdChange.q_sort;
pdClick.q_sort = RdyChangeSort;
pdChange.q_sort = ClickNowSort;
if ((i = qBLL.Update(pdClick) + qBLL.Update(pdChange)) > 1)
{
ShowMessage("排序成功");
ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("f_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");
QnaInfo pdClick = qBLL.GetDataById(int.Parse(btnClick.CommandArgument.ToString()));
QnaInfo pdChange = qBLL.GetDataById(int.Parse(btnRdyChange.CommandArgument.ToString()));
ClickNowSort = pdClick.q_sort;
RdyChangeSort = pdChange.q_sort;
pdClick.q_sort = RdyChangeSort;
pdChange.q_sort = ClickNowSort;
if ((i = qBLL.Update(pdClick) + qBLL.Update(pdChange)) > 1)
{
ShowMessage("排序成功");
ObjectDataSource1.FilterExpression = AddMethodSystem.DecodeHtml2(AddMethodSystem.SearchWHEREStringObject("f_title", txtKeyWord.Text, ""));
}
}
else
{
ShowMessage("此項目排序已是最後一位");
}
}
}
public int Delete(int q_id)
{
QnaInfo info = GetDataById(q_id);
List <QnaInfo> infos = GetDataBySorting(info.q_sort);
foreach (QnaInfo Sortinfo in infos)
{
db.Update(Sortinfo.q_title, Sortinfo.q_content, Sortinfo.q_sort - 1, Sortinfo.q_show, Sortinfo.q_CreateDate, Sortinfo.q_EditDate, Sortinfo.q_id);
}
return(db.Delete(q_id));
}
public List <QnaInfo> GetDataBySorting(int sorting)
{
List <QnaInfo> infos = new List <QnaInfo>();
IDataReader reader = db.GetDataBySorting(sorting).CreateDataReader();
while (reader.Read())
{
infos.Add(QnaInfo.Populate(reader));
}
return(infos);
}
public QnaInfo GetDataById(int q_id)
{
QnaInfo info = new QnaInfo();
IDataReader reader = db.GetDataById(q_id).CreateDataReader();
if (reader.Read())
{
info = QnaInfo.Populate(reader);
}
return(info);
}
public int InsertSorting()
{
QnaInfo info = new QnaInfo();
IDataReader reader = db.InsertSorting().CreateDataReader();
if (reader.Read())
{
info = QnaInfo.Populate(reader);
return(info.q_sort + 1);
}
return(1);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
QnaInfo info = qBLL.GetDataById(id);
info.q_title = txtName.Text;
info.q_content = cked1.Text;
info.q_show = bool.Parse(rbShow.SelectedValue);
info.q_EditDate = DateTime.Now;
if (qBLL.Update(info) > 0)
{
Response.Redirect("List.aspx?header=" + Getmessage("30014"));
}
}
protected void Bind()
{
if (id != 0)
{
if (Tools.TryParseMethod(id.ToString()) > 0)
{
QnaInfo info = qBLL.GetDataById(id);
txtName.Text = info.q_title;
cked1.Text = info.q_content;
rbShow.SelectedValue = info.q_show.ToString();
txtCreatedate.Text = info.q_CreateDate.ToShortDateString();
txtEditdate.Text = info.q_EditDate.ToShortDateString();
}
}
}
public int Update(QnaInfo info)
{
return(db.Update(info.q_title, info.q_content, info.q_sort, info.q_show, info.q_CreateDate, info.q_EditDate, info.q_id));
}
public int Insert(QnaInfo info)
{
return(db.Insert(info.q_title, info.q_content, InsertSorting(), info.q_show, info.q_CreateDate, info.q_EditDate));
}
