private void btn_login_Click(object sender, EventArgs e) { if (checkdata() == false) { return; } string sqlusername = "******" + cmb_user.Text + "'"; string sqlpass = "******" + cmb_user.Text + "'"; string sqlpermission = "select distinct permission from m_user where usercode = '" + cmb_user.Text + "'"; sqlCON connect = new sqlCON(); if (connect.sqlExecuteScalarString(sqlpass) != txt_pass.Text) { infomesge mes = new infomesge(); mes.ErrorMesger("Password is not correct", "Warning System", this); txt_pass.Text = ""; return; } sqlCON connected = new sqlCON(); sqlCON permi = new sqlCON(); Class.valiballecommon va = Class.valiballecommon.GetStorage(); va.UserName = connected.sqlExecuteScalarString(sqlusername); va.Permission = permi.sqlExecuteScalarString(sqlpermission); va.UserCode = cmb_user.Text; MainFr newfr = new MainFr(); newfr.Show(); //this.Hide(); }
private void Form1_Load(object sender, EventArgs e) { string sql = "select distinct usercode from m_user "; sqlCON connect = new sqlCON(); connect.getComboBoxData(sql, ref cmb_user); if (System.Deployment.Application.ApplicationDeployment.IsNetworkDeployed) { Version deploy = System.Deployment.Application.ApplicationDeployment.CurrentDeployment.CurrentVersion; StringBuilder version = new StringBuilder(); //version.Append("VERSION: "); version.Append("TechLink Version: "); version.Append(deploy.Major); version.Append("_"); version.Append(deploy.Minor); version.Append("_"); version.Append(deploy.Build); version.Append("_"); version.Append(deploy.Revision); Version_lbl.Text = version.ToString(); Class.valiballecommon.GetStorage()._version = Version_lbl.Text; } cb_Language.Items.Add("English"); cb_Language.Items.Add("TiengViet"); cb_Language.Items.Add("Chinese"); cb_Database.Items.Add("TECHLINK"); cb_Database.Items.Add("TLVN2"); cb_Database.Items.Add("TEST03152021"); Class.valiballecommon SettingGet = new Class.valiballecommon(); if (File.Exists(PathSaveConfig)) { SettingGet = (Class.valiballecommon)SaveObject.Load_data(PathSaveConfig); if (SettingGet.Language == null) { cb_Language.SelectedItem = "English"; } if (SettingGet.DBERP == null) { cb_Database.SelectedItem = "TLVN2"; } Class.valiballecommon.GetStorage().Warehouse = SettingGet.Warehouse; Class.valiballecommon.GetStorage().Department = SettingGet.Department; Class.valiballecommon.GetStorage().Currency = SettingGet.Currency; Class.valiballecommon.GetStorage().Client = SettingGet.Client; //tuanngoc Class.valiballecommon.GetStorage().DocNo = SettingGet.DocNo; } else { cb_Language.SelectedItem = "English"; cb_Database.SelectedItem = "TLVN2"; } if (SettingGet.DBERP != null) { cb_Database.SelectedItem = SettingGet.DBERP; } if (SettingGet.UserCode != null) { cmb_user.SelectedItem = SettingGet.UserCode; } if (SettingGet.Language != null) { cb_Language.SelectedItem = SettingGet.Language; } }
private void btn_login_Click(object sender, EventArgs e) { //MySql_importfg_warehouse tem = new MySql_importfg_warehouse(); //if (tem.Open()) //{ // MessageBox.Show("Connect Mysql sucess"); // return; //} //else //{ // return; //} if (checkdata() == false) { return; } string sqlusername = "******" + cmb_user.Text + "'"; string sqlpass = "******" + cmb_user.Text + "'"; string sqlpermission = "select distinct permission from m_user where usercode = '" + cmb_user.Text + "'"; sqlCON connect = new sqlCON(); if (connect.sqlExecuteScalarString(sqlpass) != txt_pass.Text) { infomesge mes = new infomesge(); mes.ErrorMesger("Password is not correct", "Warning System", this); txt_pass.Text = ""; return; } sqlCON connected = new sqlCON(); sqlCON permi = new sqlCON(); Class.valiballecommon va = Class.valiballecommon.GetStorage(); va.UserName = connected.sqlExecuteScalarString(sqlusername); va.Permission = permi.sqlExecuteScalarString(sqlpermission); va.UserCode = cmb_user.Text; if (cb_Language.SelectedItem != null) { va.Language = (string)cb_Language.SelectedItem; } if (cb_Database.SelectedItem != null) { if (cb_Database.SelectedItem.ToString() == "TECHLINK") { va.DBERP = "TECHLINK"; va.DBSFT = "SFT_TECHLINK"; } else if (cb_Database.SelectedItem.ToString() == "TLVN2") { va.DBERP = "TLVN2"; va.DBSFT = "SFT_TLVN2"; } else if (cb_Database.SelectedItem.ToString() == "TEST03152021") { va.DBERP = "TEST03152021"; va.DBSFT = "SFT_TEST03152021"; } } MainLayout mainLayout = new MainLayout(); mainLayout.Show(); //this.Hide(); //MainFr newfr = new MainFr(); //newfr.Show(); // this.Hide(); }