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