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();
}
void getERPdata()
{
DateTime dateto = dtp_to.Value.Date;
DateTime datefrom = dtp_from.Value.Date;
dt = new DataTable();
StringBuilder sql = new StringBuilder();
sql.Append(@"select
CONVERT(date,coptcs.CREATE_DATE) as Create_Date,
coptcs.TC001 as Code_Type,
coptcs.TC002 as Code_No,
coptcs.TC012 as Customer_No
from COPTC coptcs
where 1=1 ");
//if(ChooseDeptoSQLcommand(trv_department) != "")
// {
// sql.Append(ChooseDeptoSQLcommand(trv_department));
// }
if (cmd_COPTC_TC001.Text != "")
{
sql.Append(" and coptcs.TC001 = '" + cmd_COPTC_TC001.Text + "'");
}
if (cmd_COPTC_TC002.Text != "")
{
sql.Append(" and coptcs.TC002 = '" + cmd_COPTC_TC002.Text + "'");
}
else
{
sql.Append(" and CONVERT(date,coptcs.CREATE_DATE) >= '" + datefrom + "' ");
sql.Append(" and CONVERT(date,coptcs.CREATE_DATE) <= '" + dateto + "' ");
}
sql.Append(@" group by
coptcs.CREATE_DATE,
coptcs.TC001 ,
coptcs.TC002 ,
coptcs.TC012
");
sql.Append(" order by coptcs.TC001, coptcs.TC002");
sqlERPCON con = new sqlERPCON();
con.sqlDataAdapterFillDatatable(sql.ToString(), ref dt);
//checkdata
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string sqlcheck = "";
string NgayTaoDon = dt.Rows[i]["Create_Date"].ToString().Replace("'", "");
string MaTaoDon = dt.Rows[i]["Code_Type"].ToString().Replace("'", "");
string codeDon = dt.Rows[i]["Code_No"].ToString().Replace("'", "");
string MAHK = dt.Rows[i]["Customer_No"].ToString().Replace("'", "");
sqlcheck = "select COUNT(*) from t_OCTM where TM01 = '" + NgayTaoDon + "' and TM02 ='" + MaTaoDon + "' and TM03= '" + codeDon + "' and TM04 = '" + MAHK + "'";
sqlCON check = new sqlCON();
if (int.Parse(check.sqlExecuteScalarString(sqlcheck)) == 0) //insert
{
string list = "";
for (int j = 0; j < dt.Columns.Count; j++)
{
list += "'";
list += dt.Rows[i][j].ToString().Replace("'", "") + "',";
}
StringBuilder sqlinsert = new StringBuilder();
sqlinsert.Append("insert into t_OCTM ");
sqlinsert.Append(@"(TM01,TM02,TM03,TM04,UserName,datetimeRST) values ( ");
sqlinsert.Append(list);
sqlinsert.Append("'" + Class.valiballecommon.GetStorage().UserName + "',GETDATE())");
sqlCON insert = new sqlCON();
insert.sqlExecuteNonQuery(sqlinsert.ToString(), false);
}
}
}
}
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();
}