private void Txt_DbAccId_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
string str2 = (this.Txt_DbAccId.EditValue.ToString().Length != 0) ? this.Txt_DbAccId.EditValue.ToString().Substring(0, 3) : string.Empty;
this.string_0 = "SELECT account_id AS [Số TK], abbreviat AS [T\x00ean viết tắt], mof_gl AS [Cấp 3], name AS [T\x00ean đầy đủ] FROM tblAccount where status = 1 and account_id LIKE '" + str2 + "%'";
Class7.BrowserForm1(this.string_0, this.oleDbConnection_0);
this.Txt_DbAccId.Text = BrowseForm.strReturn;
}
if (e.KeyCode == Keys.Return)
{
string str = "0" + this.Txt_DbAccId.Text.Replace("-", "").Substring(5, 4);
this.string_0 = "SELECT id, fullname, bankname, bank_br, accnum FROM tblStore where id = '" + str + "' ";
this.oleDbDataAdapter_0 = new OleDbDataAdapter(this.string_0, this.oleDbConnection_0);
using (DataSet set = new DataSet())
{
this.oleDbDataAdapter_0.Fill(set);
this.oleDbConnection_0.Close();
if (set.Tables[0].Rows.Count != 0)
{
this.Txt_Beneficiary.Text = set.Tables[0].Rows[0]["fullname"].ToString();
this.Txt_BenBank.Text = set.Tables[0].Rows[0]["bankname"].ToString();
this.Txt_BenAccId.Text = set.Tables[0].Rows[0]["accnum"].ToString();
this.Txt_BenBranch.Text = set.Tables[0].Rows[0]["bank_br"].ToString();
}
}
}
}
private void btn_History_Click(object sender, EventArgs e)
{
DataSet set;
OleDbDataAdapter adapter = new OleDbDataAdapter("DELETE FROM " + this.string_0, Class7.oleDbConnection_1);
using (set = new DataSet())
{
adapter.Fill(set);
}
Class7.oleDbConnection_1.Close();
new FrmGetDates().ShowDialog();
if (Class7.IsInputDate)
{
this.string_1 = string.Concat(new object[] { "select * from tblTransaction where goods_id = '", this.string_2, "' and (tran_date between '", Class7.dateTimeFrom, "' and '", Class7.dateTimeTo, "') and status = 1 order by tran_date, tran_time " });
OleDbDataAdapter adapter3 = new OleDbDataAdapter(this.string_1, Class7.oleDbConnection_1);
DataTable dataTable = new DataTable();
adapter3.Fill(dataTable);
Class7.oleDbConnection_1.Close();
foreach (DataRow row in dataTable.Rows)
{
string str = string.Format("{0:dd/MM/yyyy}", row["tran_date"]);
string str2 = string.Format("{0:n2}", row["amount"]);
OleDbDataAdapter adapter2 = new OleDbDataAdapter(string.Concat(new object[] {
"insert into ", this.string_0, "(tran_date, trans_num, tran_time, trans_code, exp_id, imp_id, qty, amount,remark) Values('", str, "','", row["trans_num"], "', '", row["tran_time"], "', '", row["trans_code"], "', '", row["exp_id"], "', '", row["imp_id"], "',", row["qty"],
",'", str2, "',N'", row["remark"], "')"
}), Class7.oleDbConnection_1);
set = new DataSet();
adapter2.Fill(set);
Class7.oleDbConnection_1.Close();
}
Class7.BrowserForm1("select * from " + this.string_0, Class7.oleDbConnection_1);
}
}
private void IjSwogAv6_KeyDown(object sender, KeyEventArgs e)
{
if ((e.KeyCode == Keys.F2) & (Class11.string_0 == "S"))
{
Class7.BrowserForm1("select Id AS 'M\x00e3 số', Name as 'T\x00ean nh\x00f3m', Descript as 'Diễn giải', Status from " + base.Tag.ToString(), Class7.oleDbConnection_1);
this.IjSwogAv6.Text = BrowseForm.strReturn;
}
}
private void kCnalMegv(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
Class7.BrowserForm1("select goods_id as 'M\x00e3 số', full_name AS 'Diễn giải' from tblGoods where status = 1 and mbc = 0", this.oleDbConnection_1);
this.Txt_GoodsId.Text = BrowseForm.strReturn;
}
}
private void Txt_Id_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
Class7.BrowserForm1("select Id as 'K\x00fd hiệu', Description AS 'Diễn giải', exchange as 'Tỷ gi\x00e1', Status from " + base.Tag.ToString(), this.oleDbConnection_0);
this.Txt_Id.Text = BrowseForm.strReturn;
}
}
private void Txt_Id_KeyDown(object sender, KeyEventArgs e)
{
if ((e.KeyCode == Keys.F2) & (Class11.string_0 == "S"))
{
Class7.BrowserForm1("select Id AS 'M\x00e3 số', Name as 'T\x00ean sử dụng', full_name as 'Diễn giải', Status from " + base.Tag.ToString(), Class7.oleDbConnection_1);
this.Txt_Id.Text = BrowseForm.strReturn;
}
}
private void Txt_Id_KeyDown(object sender, KeyEventArgs e)
{
if ((e.KeyCode == Keys.F2) && (Class11.string_0 == "S"))
{
Class7.BrowserForm1("select Id as 'M\x00e3 số', Description AS 'Diễn giải', Status from " + base.Tag.ToString(), this.oleDbConnection_0);
this.Txt_Id.Text = BrowseForm.strReturn;
}
}
private void txtSymbol_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
Class7.BrowserForm1("select loc_id AS [M\x00e3 kệ], stk_id as [Quầy/Kho], Description AS [Diễn giải], Status from " + base.Tag.ToString(), this.oleDbConnection_0);
this.txtSymbol.Text = BrowseForm.strReturn;
}
}
private void txtId_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
Class7.BrowserForm1("select trans_code, trans_name, status from " + base.Tag.ToString(), this.oleDbConnection_0);
this.txtId.Text = BrowseForm.strReturn;
}
}
private void Txt_GoodsId_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
Class7.BrowserForm1("select id as 'M\x00e3 số', description AS 'M\x00f4 tả', rtprice AS [Gi\x00e1 b\x00e1n] from tblKit where status = 1", Class7.oleDbConnection_1);
this.Txt_GoodsId.Text = BrowseForm.strReturn;
}
}
private void Txt_GoodsId_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
Class7.BrowserForm1("SELECT ptr.goods_id, gs.full_name, ptr.qty, ptr.amount, ptr.trans_num FROM tblTransaction AS ptr INNER JOIN tblGoods AS gs ON ptr.goods_id = gs.goods_id where ptr.trans_num = '" + this.Txt_OldTrans.Text + "'", this.oleDbConnection_0);
this.Txt_GoodsId.Text = BrowseForm.strReturn;
}
}
private void Txt_GoodsId_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
Class7.BrowserForm1("SELECT tr.goods_id, gs.full_name, tr.unit_symb, tr.qty, tr.amount, tr.discount, tr.vat_amt, tr.surplus, tr.trans_num FROM tblGoods AS gs INNER JOIN tblTransaction AS tr ON gs.goods_id = tr.goods_id where tr.trans_num = '" + this.string_1 + "'", this.oleDbConnection_1);
this.Txt_GoodsId.Text = BrowseForm.strReturn;
}
}
private void Txt_GoodsGrp_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
Class7.BrowserForm1("select Id as 'M\x00e3 số', description AS 'Diễn giải', Status from tblGoodsGrp", this.oleDbConnection_0);
this.Txt_GoodsGrp.Text = BrowseForm.strReturn;
}
}
private void Txt_ImpID_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
Class7.BrowserForm1("SELECT Id AS 'M\x00e3 số', Name AS 'T\x00ean KH', fullname AS 'Diễn giải' FROM tblStore " + ("where id <> '" + this.Txt_ExpID.Text.Trim() + "' and type IN('02','01') and status = 1"), this.oleDbConnection_1);
this.Txt_ImpID.Text = BrowseForm.strReturn;
this.Txt_ImpID.SelectAll();
}
}
private void pfeZyQnoF(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
Class7.BrowserForm1("select goods_id as [M\x00e3 h\x00e0ng], full_name AS [Diễn giải], piceunit AS [Đơn vị] from tblGoods where status = 1 and mbc = 0", this.oleDbConnection_0);
this.Txt_GoodsId.Text = BrowseForm.strReturn;
this.Txt_GoodsId.SelectAll();
}
}
private void Txt_GoodsId_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
Class7.BrowserForm1("select goods_id as 'M\x00e3 h\x00e0ng',supp_id AS NCC, full_name AS 'Diễn giải', piceunit AS [Đơn vị] from tblGoods where status = 1 and mbc = 0", Class7.oleDbConnection_1);
this.Txt_GoodsId.Text = BrowseForm.strReturn;
this.Txt_GoodsId.SelectAll();
}
}
private void btn_Search_Click(object sender, EventArgs e)
{
Class11.smethod_2(this);
Class11.smethod_8(this);
this.IjSwogAv6.Enabled = true;
Class7.BrowserForm1("select Id AS 'M\x00e3 số', Name as 'T\x00ean nh\x00f3m', Descript as 'Diễn giải', Status from " + base.Tag.ToString(), Class7.oleDbConnection_1);
this.IjSwogAv6.Text = BrowseForm.strReturn;
this.IjSwogAv6.Focus();
}
private void Txt_ThirdLevel_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
this.string_0 = "select mof_gl, mof_name FROM tblMof_sys where glevel = 3 ";
Class7.BrowserForm1(this.string_0, this.oleDbConnection_0);
this.Txt_ThirdLevel.Text = BrowseForm.strReturn;
}
}
private void Txt_CustId_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
string str = "SELECT Id AS [M\x00e3 số], Name AS [T\x00ean KH], fullname AS [Diễn giải] FROM tblStore WHERE Type IN('05','06') and status = 1 ";
Class7.BrowserForm1(str, this.oleDbConnection_0);
this.Txt_CustId.Text = BrowseForm.strReturn;
}
}
private void txtCsId_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
this.string_0 = "SELECT id AS [M\x00e3 thẻ], fullname AS [Họ v\x00e0 t\x00ean], phone AS [Số ĐT], status AS [Trạng th\x00e1i] from tblCustomer";
Class7.BrowserForm1(this.string_0, this.oleDbConnection_0);
this.txtCsId.Text = BrowseForm.strReturn;
}
}
private void Txt_Id_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
Class7.BrowserForm1("SELECT Id AS 'M\x00e3 số', Name AS 'T\x00ean kho quầy', fullname AS 'Diễn giải' FROM " + base.Tag.ToString() + " WHERE Type IN('01','02') ", this.oleDbConnection_0);
this.Txt_Id.Text = BrowseForm.strReturn;
this.Txt_Id.SelectAll();
}
}
private void Txt_GoodsId_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
Class7.BrowserForm1("SELECT goods_id AS 'M\x00e3 số',short_name AS 'Diễn giải',Grp_id AS 'Nh\x00f3m', Status FROM tblGoods ", Class7.oleDbConnection_1);
this.Txt_GoodsId.Text = BrowseForm.strReturn;
this.Txt_GoodsId.SelectAll();
}
}
private void txtSymbol_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
this.string_0 = "select loc_id AS [M\x00e3 kệ], Description AS [Diễn giải] from tblLocation where stk_id = '" + this.txtStkId.Text.Trim() + "' and status = 1";
Class7.BrowserForm1(this.string_0, this.oleDbConnection_0);
this.txtSymbol.Text = BrowseForm.strReturn;
}
}
private void Txt_FirstLevel_KeyDown(object sender, KeyEventArgs e)
{
if ((e.KeyCode == Keys.F2) && (this.string_1 == "S"))
{
this.string_0 = "select mof_gl, mof_name, mof_nameb FROM " + base.Tag.ToString() + " where glevel = 1 ";
Class7.BrowserForm1(this.string_0, this.oleDbConnection_0);
this.Txt_FirstLevel.Text = BrowseForm.strReturn;
}
}
private void Txt_DbAccId_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
string str = (this.Txt_DbAccId.EditValue.ToString().Length != 0) ? this.Txt_DbAccId.EditValue.ToString().Substring(0, 3) : string.Empty;
this.string_1 = "SELECT account_id AS [Số TK], abbreviat AS [T\x00ean viết tắt], mof_gl AS [Cấp 3], name AS [T\x00ean đầy đủ] FROM tblAccount where status = 1 and account_id LIKE '" + str + "%'";
Class7.BrowserForm1(this.string_1, this.oleDbConnection_0);
this.Txt_DbAccId.Text = BrowseForm.strReturn;
}
}
private void txtGoodsid_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
this.string_0 = "SELECT gs.goods_id AS [M\x00e3 số],gs.short_name AS [T\x00ean s\x00e1ch],grp.description AS [Loại s\x00e1ch], PARSENAME(convert(varchar,convert(MONEY,pr.rtprice),1),0 ) AS [Gi\x00e1 b\x00eca], gs.Status AS [Trạng th\x00e1i] FROM tblGoods AS gs INNER JOIN tblGoodsGrp AS grp ON gs.grp_id = grp.id INNER JOIN tblPrice AS pr ON gs.goods_id = pr.goods_id ";
Class7.BrowserForm1(this.string_0, Class7.oleDbConnection_1);
this.txtGoodsid.Text = BrowseForm.strReturn;
this.txtGoodsid.SelectAll();
}
}
private void btnSuppMerc_Click(object sender, EventArgs e)
{
string str = this.Txt_Id.Text.Trim();
if (!(str == string.Empty))
{
this.string_0 = "SELECT stk.id AS [M\x00e3 kho], gs.goods_id AS [M\x00e3 h\x00e0ng], gs.full_name AS [T\x00ean h\x00e0ng], gs.piceunit AS [Đơn vị], stk.begin_qty - stk.exp_qty + stk.imp_qty AS Tồn, stk.averimppr AS [Gi\x00e1 vốn] FROM tblGoods AS gs INNER JOIN tblStockInfo AS stk ON gs.goods_id = stk.goods_id WHERE gs.supp_id = '" + str + "'";
Class7.BrowserForm1(this.string_0, this.oleDbConnection_0);
}
}
private void txtStkId_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
string str = "SELECT Id AS [M\x00e3 số], Name AS [T\x00ean kho, quầy], fullname AS 'Diễn giải' FROM tblStore WHERE Type IN('01','02') and status = 1";
Class7.BrowserForm1(str, this.oleDbConnection_0);
this.txtStkId.Text = BrowseForm.strReturn;
this.txtStkId.SelectAll();
}
}
private void Txt_Id_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
this.string_0 = "SELECT Id AS 'M\x00e3 số', Name AS 'T\x00ean KH', fullname AS 'Diễn giải', Status FROM tblStore WHERE Type > '02' AND Status = 1";
Class7.BrowserForm1(this.string_0, this.oleDbConnection_0);
this.Txt_Id.Text = BrowseForm.strReturn;
this.Txt_Id.SelectAll();
}
}
private void Txt_ImpID_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F2)
{
string str = "SELECT Id AS 'M\x00e3 số', Name AS 'T\x00ean KH', fullname AS 'Diễn giải' FROM tblStore WHERE Type IN('05','06') and status = 1";
Class7.BrowserForm1(str, this.oleDbConnection_1);
this.Txt_ImpID.Text = BrowseForm.strReturn;
this.Txt_ImpID.SelectAll();
}
}