public bool UpdateLanguageSetting(LanguageClass language) { try { string user = Class.valiballecommon.GetStorage().UserName; string CreateDate = DateTime.Now.ToString("yyyyMMdd"); string PC = Class.valiballecommon.GetStorage().PCName; StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" update t_language "); stringBuilder.Append(" set Modifier = '" + user + "' , "); stringBuilder.Append(" Modify_Date = '" + CreateDate + "' , "); stringBuilder.Append(" Modify_App = '" + PC + "', "); stringBuilder.Append(" TiengViet = '" + language.Tiengviet + "', "); stringBuilder.Append(" English = '" + language.English + "', "); stringBuilder.Append(" Chinese = '" + language.Chinese + "' "); stringBuilder.Append(" where 1=1 "); stringBuilder.Append(" and FunctionGroup = '" + language.functionGroup + "' "); stringBuilder.Append(" and FunctionName = '" + language.functionName + "' "); sqlCON sqlCON = new sqlCON(); return(sqlCON.sqlExecuteNonQuery(stringBuilder.ToString(), false)); } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "UpdateLanguageSetting(LanguageClass language)", ex.Message); return(false); } }
public DataTable SearchLanguageSetting(LanguageClass language) { DataTable dt = new DataTable(); try { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" select FunctionGroup,FunctionName,TiengViet,English,Chinese from t_language "); stringBuilder.Append(" where 1=1 "); if (language.functionGroup != "") { stringBuilder.Append(" and FunctionGroup like '%" + language.functionGroup + "%' "); } if (language.functionName != "") { stringBuilder.Append(" and FunctionName like '%" + language.functionName + "%' "); } sqlCON sqlCON = new sqlCON(); sqlCON.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt); return(dt); } catch (Exception) { return(dt); } }
private void Btn_delete_Click(object sender, EventArgs e) { try { LanguageClass language = new LanguageClass(); language.functionGroup = txt_functionGroup.Text; language.functionName = txt_functionName.Text; language.Tiengviet = txt_tiengViet.Text; language.English = txt_english.Text; language.Chinese = txt_Chinese.Text; LanguageSetting languageSetting = new LanguageSetting(); languageSetting.DeleteRowofLanguageSetting(language); string sqlQuerry = "select FunctionGroup,FunctionName,TiengViet,English,Chinese from t_language "; sqlCON sqlcon = new sqlCON(); DataTable dt = new DataTable(); sqlcon.sqlDataAdapterFillDatatable(sqlQuerry, ref dt); dtgv_SettingLanguage.DataSource = null; dtgv_SettingLanguage.DataSource = dt; } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "delete row", ex.Message); } }
private void Btn_Search_Click(object sender, EventArgs e) { try { LanguageClass language = new LanguageClass(); language.functionGroup = txt_groupFilter.Text.Trim(); language.functionName = txt_NameFilter.Text.Trim(); LanguageSetting languageSetting = new LanguageSetting(); DataTable dt = languageSetting.SearchLanguageSetting(language); dtgv_SettingLanguage.DataSource = null; dtgv_SettingLanguage.DataSource = dt; } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "Btn_Search_Click(object sender, EventArgs e)", ex.Message); } }
public bool DeleteRowofLanguageSetting(LanguageClass language) { try { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" delete from t_language "); stringBuilder.Append(" where 1=1 "); stringBuilder.Append(" and FunctionGroup = '" + language.functionGroup + "' "); stringBuilder.Append(" and FunctionName = '" + language.functionName + "' "); sqlCON sqlCON = new sqlCON(); return(sqlCON.sqlExecuteNonQuery(stringBuilder.ToString(), false)); } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "DeleteRowofLanguageSetting(LanguageClass language)", ex.Message); return(false); } }
public bool InsertLanguageSetting(LanguageClass language) { try { StringBuilder stringBuilder = new StringBuilder(); string user = Class.valiballecommon.GetStorage().UserName; string CreateDate = DateTime.Now.ToString("yyyyMMdd"); string PC = Class.valiballecommon.GetStorage().PCName; stringBuilder.Append(" insert into t_language (Create_User, Create_Date, Create_App, Modifier,Modify_Date,Modify_App,FunctionGroup,FunctionName,TiengViet,English,Chinese,DateTime ) values "); stringBuilder.Append("( '"); stringBuilder.Append(user + "','" + CreateDate + "','" + PC + "','" + "" + "','" + "" + "','" + "" + "','" + language.functionGroup + "','" + language.functionName + "','" + language.Tiengviet + "','" + language.English + "','" + language.Chinese + "'," + "GETDATE()"); stringBuilder.Append(") "); sqlCON sqlCON = new sqlCON(); return(sqlCON.sqlExecuteNonQuery(stringBuilder.ToString(), false)); } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "InsertLanguageSetting(LanguageClass language)", ex.Message); return(false); } }
private void Btn_uploadfile_Click(object sender, EventArgs e) { try { if (txt_SettingFile.Text != "") { DataTable dt = new DataTable(); Class.ToolSupport toolSupport = new Class.ToolSupport(); dt = toolSupport.ReadexcelToDatatable("SettingLanguage", txt_SettingFile.Text); for (int i = 0; i < dt.Rows.Count; i++) { LanguageClass language = new LanguageClass(); language.functionGroup = dt.Rows[i][0].ToString(); language.functionName = dt.Rows[i][1].ToString(); language.Tiengviet = dt.Rows[i][2].ToString(); language.English = dt.Rows[i][3].ToString(); language.Chinese = dt.Rows[i][4].ToString(); LanguageSetting languageSetting = new LanguageSetting(); languageSetting.InsertLanguageSetting(language); // languageClasses.Add(language); string sqlQuerry = "select FunctionGroup,FunctionName,TiengViet,English,Chinese from t_language "; sqlCON sqlcon = new sqlCON(); DataTable dta = new DataTable(); sqlcon.sqlDataAdapterFillDatatable(sqlQuerry, ref dta); dtgv_SettingLanguage.DataSource = null; dtgv_SettingLanguage.DataSource = dta; } // toolSupport.openExcelList("SettingLanguage", txt_SettingFile.Text, ref dt); } } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "Btn_uploadfile_Click(object sender, EventArgs e)", ex.Message); } }