protected void lvFAQs_SelectedIndexChanging(object sender, ListViewSelectEventArgs e) { try { Label lblnID = (Label)lvFAQs.Items[e.NewSelectedIndex].FindControl("lblnID"); int nID = 0; if (int.TryParse(lblnID.Text.Trim(), out nID) && nID > 0) { DBLL.clsFAQs clsnews = new DBLL.clsFAQs(); DataTable dtnews = clsnews.Select_tb_FAQsBynFAQID(nID); if (dtnews != null && dtnews.Rows.Count > 0) { if (Session["languageGlobal"] == "en") { lblFAQsDetailtitle.Text = dtnews.Rows[0]["sQuestionEN"].ToString(); lblFAQsDetailTime.Text = dtnews.Rows[0]["dCreatedTime"].ToString(); divFAQsDetail.InnerHtml = dtnews.Rows[0]["sAnswerEN"].ToString(); } else { lblFAQsDetailtitle.Text = dtnews.Rows[0]["sQuestionCN"].ToString(); lblFAQsDetailTime.Text = dtnews.Rows[0]["dCreatedTime"].ToString(); divFAQsDetail.InnerHtml = dtnews.Rows[0]["sAnswerCN"].ToString(); } PnlFAQsDetail.Visible = true; lvFAQs.Visible = false; } } } catch (Exception) { throw; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int nID = 0; if (Request.QueryString["nID"] != null && int.TryParse(Request.QueryString["nID"].ToString(), out nID) && nID > 0) { lblBigtitle.Text = "编辑数据"; BtnAdd.Visible = false; btnUpdate.Visible = true; DBLL.clsFAQs clFAQ = new DBLL.clsFAQs(); DataTable dt = clFAQ.Select_tb_FAQsBynFAQID(nID); if (dt != null && dt.Rows.Count > 0) { hfID.Value = dt.Rows[0]["nFAQID"].ToString(); txtsQuestionCN.Text = dt.Rows[0]["sQuestionCN"].ToString(); txtsQuestionEN.Text = dt.Rows[0]["sQuestionEN"].ToString(); txtsAnswerCN.Text = dt.Rows[0]["sAnswerCN"].ToString(); txtsAnswerEN.Text = dt.Rows[0]["sAnswerEN"].ToString(); txtnSorting.Text = dt.Rows[0]["nSorting"].ToString(); //绑定数据 } } else { lblBigtitle.Text = "添加数据"; btnUpdate.Visible = false; BtnAdd.Visible = true; } } }
protected void BtnUpdate_Click(object sender, EventArgs e) { //判断session if (Session["User"] == null || Session["User"].ToString().Length < 1) { Response.Redirect(Request.RawUrl); } try { if (ValiEdit()) { DBLL.clsFAQs FAQ = new DBLL.clsFAQs(); DBLL.OptionSysDBLL option = new DBLL.OptionSysDBLL(); bool _Result = FAQ.update_tb_FAQsBynFAQID(int.Parse(hfFAQUpdateID.Value), txtsQuestionCN.Text, txtsQuestionEN.Text, txtsAnswerCN.Text, txtsAnswerEN.Text, Session["user"].ToString(), DateTime.Now, true, int.Parse(ddlnSorting.SelectedValue)); if (_Result == true) { ShowMsg1.InnerContent = option.GetOptionValue("FormatSetting", "CommandControl", "UpdateSuccess"); ShowMsg1.Show(); MultiView1.ActiveViewIndex = 0; ReBindPageList(); } else { //失败就一条 ShowMsg1.InnerContent = option.GetOptionValue("FormatSetting", "CommandControl", "UpdateFail"); ShowMsg1.Show(); } } } catch (Exception) { throw; } }
protected void BtnAdd_Click(object sender, EventArgs e) { //判断session if (Session["User"] == null || Session["User"].ToString().Length < 1) { Response.Redirect(Request.RawUrl); } if (ValiAdd()) { DBLL.clsFAQs FAQ = new DBLL.clsFAQs(); DBLL.OptionSysDBLL option = new DBLL.OptionSysDBLL(); int _Result = FAQ.insert_tb_FAQs(txtsQuestionCN.Text, txtsQuestionEN.Text, txtsAnswerCN.Text, txtsAnswerEN.Text, Session["User"].ToString(), DateTime.Now, Session["User"].ToString(), DateTime.Now, true, int.Parse(ddlnSorting.SelectedValue)); if (_Result > 0) { ShowMsg1.InnerContent = option.GetOptionValue("FormatSetting", "CommandControl", "InsertSuccess"); ShowMsg1.Show(); Clear(); } else { ShowMsg1.InnerContent = option.GetOptionValue("FormatSetting", "CommandControl", "InsertFail"); ShowMsg1.Show(); } } else { ShowMsg1.Show(); } }
public void SetTyp4FAQs(string sName, int nTCID) { MultiView1.ActiveViewIndex = 3; lblBigTitle.Text = sName; DBLL.clsFAQs clsFAQs = new DBLL.clsFAQs(); lvFAQs.DataSource = clsFAQs.sp_selectNormalTableOfAllByFAQs(false); lvFAQs.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { OnSetLanguage(); DBLL.clsFAQs clsfaqs = new DBLL.clsFAQs(); DBLL.DBcommon dbcom = new DBLL.DBcommon(); DataTable dt = dbcom.GetDataTable("select top 1 * from tb_FAQs order by nSorting desc,dCreatedTime desc"); gvFAQS.DataSource = dt; gvFAQS.DataBind(); } }
public void ReBindPageList() { DBLL.clsFAQs FAQs = new DBLL.clsFAQs(); DataTable dt = new DataTable(); dt = FAQs.sp_selectNormalTableOfAllByFAQs(false); if (dt != null) { FAQList.Merge(dt); lvFAQList.DataSource = FAQList; lvFAQList.DataBind(); } else { lvFAQList.DataSource = null; lvFAQList.DataBind(); } }
protected void lvFAQList_SelectedIndexChanging(object sender, ListViewSelectEventArgs e) { Label lblnID = (Label)lvFAQList.Items[e.NewSelectedIndex].FindControl("lblnFAQID"); int _nID = 0; DBLL.clsFAQs FAQ = new DBLL.clsFAQs(); if (int.TryParse(lblnID.Text.Trim(), out _nID) && _nID > 0) { MultiView1.ActiveViewIndex = 1; DataTable dt = FAQ.Select_tb_FAQsBynFAQID(_nID); txtsQuestionCN.Text = dt.Rows[0]["sQuestionCN"].ToString(); txtsQuestionEN.Text = dt.Rows[0]["sQuestionEN"].ToString(); txtsAnswerCN.Text = dt.Rows[0]["sAnswerCN"].ToString(); txtsAnswerEN.Text = dt.Rows[0]["sAnswerEN"].ToString(); ddlnSorting.SelectedValue = dt.Rows[0]["nSorting"].ToString(); hfFAQUpdateID.Value = _nID.ToString(); } }
protected void btnUpdate_Click(object sender, EventArgs e) { //判断session if (Session["User"] == null || Session["User"].ToString().Length < 1) { Response.Redirect(Request.RawUrl); } try { int nID = 0; if (int.TryParse(hfID.Value.ToString(), out nID) && nID > 0) { //更新 if (Vali()) { DBLL.clsFAQs clFAQ = new DBLL.clsFAQs(); DBLL.OptionSysDBLL option = new DBLL.OptionSysDBLL(); bool _Result = clFAQ.update_tb_FAQsBynFAQID(int.Parse(hfID.Value), txtsQuestionCN.Text, txtsQuestionEN.Text, txtsAnswerCN.Text, txtsAnswerEN.Text, Session["user"].ToString(), DateTime.Now, true, int.Parse(txtnSorting.Text)); if (_Result == true) { ShowMsg1.InnerContent = option.GetOptionValue("FormatSetting", "CommandControl", "UpdateSuccess"); ShowMsg1.Show(); } else { //失败就一条 ShowMsg1.InnerContent = option.GetOptionValue("FormatSetting", "CommandControl", "UpdateFail"); ShowMsg1.Show(); } } else { ShowMsg1.Show(); } } } catch (Exception) { throw; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { OnSetLanguage(); MultiView1.ActiveViewIndex = 0; DBLL.clsTopicCategory clsTopicCate = new DBLL.clsTopicCategory(); int _nTCategoryID = 0; if (Request.QueryString["nTCategoryID"] != null && int.TryParse(Request.QueryString["nTCategoryID"], out _nTCategoryID)) { DataTable dttc = clsTopicCate.Select_tb_TopicCategoryBynTCategoryID(_nTCategoryID); if (dttc != null && dttc.Rows.Count > 0) { int nType = int.Parse(dttc.Rows[0]["nType"].ToString()); switch (nType) { case 1: { if (Session["languageGlobal"] == "en") { SetType1DivContent(dttc.Rows[0]["sTCategoryNameEN"].ToString(), dttc.Rows[0]["sContentEN"].ToString()); } else { SetType1DivContent(dttc.Rows[0]["sTCategoryNameCN"].ToString(), dttc.Rows[0]["sContentCN"].ToString()); } break; } case 2: { if (Session["languageGlobal"] == "en") { SetTyp2Ablum(dttc.Rows[0]["sTCategoryNameEN"].ToString(), _nTCategoryID); } else { SetTyp2Ablum(dttc.Rows[0]["sTCategoryNameCN"].ToString(), _nTCategoryID); } break; } case 3: { if (Session["languageGlobal"] == "en") { SetTyp3News(dttc.Rows[0]["sTCategoryNameEN"].ToString(), _nTCategoryID, 2); } else { SetTyp3News(dttc.Rows[0]["sTCategoryNameCN"].ToString(), _nTCategoryID, 1); } break; } case 4: { if (Session["languageGlobal"] == "en") { SetTyp4FAQs(dttc.Rows[0]["sTCategoryNameEN"].ToString(), _nTCategoryID); } else { SetTyp4FAQs(dttc.Rows[0]["sTCategoryNameCN"].ToString(), _nTCategoryID); } break; } default: break; } int nFAQsID = 0; if (Session["nFAQsRidectSet"] != null && int.TryParse(Session["nFAQsRidectSet"].ToString(), out nFAQsID) && nFAQsID > 0) { Session["nFAQsRidectSet"] = ""; DBLL.clsFAQs clsnews = new DBLL.clsFAQs(); DataTable dtnews = clsnews.Select_tb_FAQsBynFAQID(nFAQsID); if (dtnews != null && dtnews.Rows.Count > 0) { if (Session["languageGlobal"] == "en") { lblFAQsDetailtitle.Text = dtnews.Rows[0]["sQuestionEN"].ToString(); lblFAQsDetailTime.Text = dtnews.Rows[0]["dCreatedTime"].ToString(); divFAQsDetail.InnerHtml = dtnews.Rows[0]["sAnswerEN"].ToString(); } else { lblFAQsDetailtitle.Text = dtnews.Rows[0]["sQuestionCN"].ToString(); lblFAQsDetailTime.Text = dtnews.Rows[0]["dCreatedTime"].ToString(); divFAQsDetail.InnerHtml = dtnews.Rows[0]["sAnswerCN"].ToString(); } PnlFAQsDetail.Visible = true; lvFAQs.Visible = false; } } } } } }