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);
}
}
