private void BindGridView()
{
#region FAQGridView 数据绑定
_faqEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_faqEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_faqEntity.LogMessages.Username = UserSession.Current.UserDspName;
_faqEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_faqEntity.FAQDBEntity = new List<FAQDBEntity>();
FAQDBEntity faqDBEntity = new FAQDBEntity();
_faqEntity.FAQDBEntity.Add(faqDBEntity);
DataSet dsResult = FAQBP.CommonSelect(_faqEntity).QueryResult;
DataTable dtUser = dsResult.Tables[0];
GridviewControl.GridViewDataBind(this.FAQGridView, dtUser);
#endregion
}
/// <summary>
/// 点击删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void FAQGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string ID = FAQGridView.DataKeys[e.RowIndex].Value.ToString();
_faqEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_faqEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_faqEntity.LogMessages.Username = UserSession.Current.UserDspName;
_faqEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_faqEntity.FAQDBEntity = new List<FAQDBEntity>();
FAQDBEntity faqDBEntity = new FAQDBEntity();
faqDBEntity.ID = Convert.ToInt32(ID);
_faqEntity.FAQDBEntity.Add(faqDBEntity); //增加一条到数据库中
int iResult = FAQBP.Delete(_faqEntity);
if (iResult == 1)//删除成功
{
string successText = Resources.MyGlobal.DeleteSuccessText;
//commonDBEntity.Event_Result = successText;
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "alert('" + successText + "');", true);
BindGridView();//重新绑定显示的页面
}
else//表示失败
{
//string strFaild = GetLocalResourceObject("DeleteFaildText").ToString();
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "failed", "alert('删除失败！')", true);
}
}
protected void FAQGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string ID = FAQGridView.DataKeys[e.RowIndex].Value.ToString();
_faqEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_faqEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_faqEntity.LogMessages.Username = UserSession.Current.UserDspName;
_faqEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
string strQuestion = ((TextBox)FAQGridView.Rows[e.RowIndex].FindControl("txtEditQuestion")).Text;
string strAnswer = ((TextBox)FAQGridView.Rows[e.RowIndex].FindControl("txtEditAnswer")).Text;
if ((strQuestion.Length > 100) || (string.IsNullOrEmpty(strQuestion)))
{
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "alert('问题不能为空，且总长度最多只能输入100个字符！');", true);
return;
}
if ((strAnswer.Length > 300) || (string.IsNullOrEmpty(strAnswer)))
{
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "alert('答案不能为空，且答案的内容的总长度不能大于300个字符！');", true);
return;
}
_faqEntity.FAQDBEntity = new List<FAQDBEntity>();
FAQDBEntity faqDBEntity = new FAQDBEntity();
faqDBEntity.ID = Convert.ToInt32(ID);
faqDBEntity.QUSETION_HEAD = strQuestion;
faqDBEntity.ANSWER_BODY = strAnswer;
_faqEntity.FAQDBEntity.Add(faqDBEntity);
int iResult = FAQBP.Update(_faqEntity);
if (iResult == 1) //修改成功
{
string successText = Resources.MyGlobal.UpdateSuccessText;
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "alert('" + successText + "');", true);
FAQGridView.EditIndex = -1;
BindGridView();//重新绑定显示的页面
btnAdjust.Enabled = true;
}
else//表示修改失败
{
//string strFaild = GetLocalResourceObject("UpdateFaildText").ToString();
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "failed", "alert('修改失败！')", true);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strQuestion = this.txtQuestion.Text.Trim();
string strAnswer = this.txtAnswer.Text.Trim();
_faqEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_faqEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_faqEntity.LogMessages.Username = UserSession.Current.UserDspName;
_faqEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_faqEntity.FAQDBEntity = new List<FAQDBEntity>();
FAQDBEntity faqDBEntity = new FAQDBEntity();
int id = new CommonFunction().getMaxIDfromSeq("t_lm_qa_seq");
int SeqMax = DbHelperOra.GetMaxID("SEQ", "t_lm_qa", false);
faqDBEntity.ID = id;
faqDBEntity.QUSETION_HEAD = strQuestion;
faqDBEntity.ANSWER_BODY = strAnswer;
faqDBEntity.SEQ = SeqMax;
_faqEntity.FAQDBEntity.Add(faqDBEntity);
FAQBP.Insert(_faqEntity);
clearInputText();//清空已经输入的信息
BindGridView();
}