void InitialControlsValue() { if (HdInsertUpdate == false) { LtInsertUpdate.Text = "Cập nhật thông tin ngôn ngữ"; top = "1"; fields = "*"; condition = LanguageNationalTSql.GetByiLanguageNationalId(iLanguageNationalId); order = ""; DataTable dt = new DataTable(); dt = LanguageNational.GetLanguageNational(top, fields, condition, order); TbNameNational.Text = dt.Rows[0]["nLanguageNationalName"].ToString(); ltimg.Text = ImagesExtension.GetImage(pic, dt.Rows[0]["nLanguageNationalFlag"].ToString(), "", "", false, false, ""); if (!dt.Rows[0]["nLanguageNationalFlag"].ToString().Equals("")) { LbDelFlagCurrent.Visible = true; } HdFlagNational.Value = dt.Rows[0]["nLanguageNationalFlag"].ToString(); TbOrder.Text = dt.Rows[0]["nLanguageNationalDesc"].ToString(); if (dt.Rows[0]["iLanguageNationalEnable"].ToString().Equals("0")) { ChkStatus.Checked = false; } else { ChkStatus.Checked = true; } pnTiepTuc.Visible = false; } else { LtInsertUpdate.Text = "Thêm mới ngôn ngữ website"; pnTiepTuc.Visible = true; } }
void GetListLanguageNationals() { DataTable dt = new DataTable(); dt = LanguageNational.GetLanguageNational("", "*", LanguageNationalTSql.GetByiLanguageNationalEnable("1"), LanguageNationalColumns.nLanguageNationalDesc + " desc"); rptList.DataSource = dt; rptList.DataBind(); }
void GetListLanguageNationals() { top = ""; fields = "*"; condition = TatThanhJsc.TSql.LanguageNationalTSql.GetByiLanguageNationalEnable("1"); order = LanguageNationalColumns.nLanguageNationalDesc; DataTable dt = new DataTable(); dt = LanguageNational.GetLanguageNational(top, fields, condition, order); rptList.DataSource = dt; rptList.DataBind(); }
void GetListLanguageNationals() { top = ""; fields = "*"; condition = ""; order = LanguageNationalColumns.nLanguageNationalDesc + " ASC "; DataTable dt = new DataTable(); dt = LanguageNational.GetLanguageNational(top, fields, condition, order); RpListLanguageNationals.DataSource = dt; RpListLanguageNationals.DataBind(); }
private void LoadSourceLanguage() { ddlLanguageSource.Items.Clear(); condition = LanguageNationalTSql.GetByiLanguageNationalEnable("1"); orderby = LanguageNationalColumns.iLanguageNationalId; DataTable dt = new DataTable(); dt = LanguageNational.GetLanguageNational("", "*", condition, orderby, ddlWebSource.SelectedValue); for (int i = 0; i < dt.Rows.Count; i++) { ddlLanguageSource.Items.Add(new ListItem(dt.Rows[i][LanguageNationalColumns.nLanguageNationalName].ToString(), dt.Rows[i][LanguageNationalColumns.iLanguageNationalId].ToString())); } }
private void LoadDestLanguage() { ddlLanguageDest.Items.Clear(); condition = LanguageNationalTSql.GetByiLanguageNationalEnable("1"); orderby = LanguageNationalColumns.iLanguageNationalId; DataTable dt = new DataTable(); dt = LanguageNational.GetLanguageNational("", "*", condition, orderby, ConfigurationManager.AppSettings["WebName"]); for (int i = 0; i < dt.Rows.Count; i++) { ddlLanguageDest.Items.Add(new ListItem(dt.Rows[i][LanguageNationalColumns.nLanguageNationalName].ToString(), dt.Rows[i][LanguageNationalColumns.iLanguageNationalId].ToString())); } }
string GetListLanguageNationals() { string s = ""; top = ""; fields = "*"; condition = TatThanhJsc.TSql.LanguageNationalTSql.GetByiLanguageNationalEnable("1"); order = LanguageNationalColumns.nLanguageNationalDesc; DataTable dt = LanguageNational.GetLanguageNational(top, fields, condition, order); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { s += @" <a href='javascript:;' onclick='SetLangDisplay(" + dt.Rows[i][LanguageNationalColumns.iLanguageNationalId] + ")'>" + ImagesExtension.GetImage(FolderPic.Language, dt.Rows[i][LanguageNationalColumns.nLanguageNationalFlag].ToString(), dt.Rows[i][LanguageNationalColumns.nLanguageNationalName].ToString(), "", false, false, "") + @"</a> "; } } return(s); }
protected void RpListLanguageNationals_ItemCommand(object source, RepeaterCommandEventArgs e) { string c = e.CommandName.Trim(); string p = e.CommandArgument.ToString().Trim(); switch (c) { #region delete //case "delete": // if (!language.Equals(p)) // { // LanguageNational.DeleteLanguageNationalAndLanguageItem(p); // } // else // { // ScriptManager.RegisterStartupScript(this, GetType(), "DeleteItem", // "ThongBao(3000, 'Bạn đang sử dụng ngôn ngữ này vì vậy không thể xóa được!');", // true); // } // break; #endregion #region Edit Status case "EditStatus": top = "1"; fields = "iLanguageNationalEnable, nLanguageNationalName"; condition = LanguageNationalTSql.GetByiLanguageNationalId(p); order = ""; DataTable dt = new DataTable(); dt = LanguageNational.GetLanguageNational(top, fields, condition, order); string[] fieldsEditStatus = { "iLanguageNationalEnable" }; string[] valuesEditStatus = { "" }; if (dt.Rows[0]["iLanguageNationalEnable"].ToString().Equals("0")) { valuesEditStatus[0] = "1"; LanguageNational.UpdateLanguageNational(DataExtension.UpdateTransfer(fieldsEditStatus, valuesEditStatus), condition); } else { valuesEditStatus[0] = "0"; LanguageNational.UpdateLanguageNational(DataExtension.UpdateTransfer(fieldsEditStatus, valuesEditStatus), condition); } #region Logs string logAuthor = CookieExtension.GetCookies("LoginSetting"); string logCreateDate = DateTime.Now.ToString(); Logs.InsertLogs(logCreateDate, Request.Url.ToString(), "", dt.Rows[0]["nLanguageNationalName"].ToString(), logAuthor, "", logCreateDate + ": " + logAuthor + " thay đổi trạng thái ngôn ngữ " + dt.Rows[0]["nLanguageNationalName"].ToString()); #endregion GetListLanguageNationals(); break; #endregion #region edit case "edit": Response.Redirect(LinkUpdate(p)); break; #endregion } }