private void btnCreateTrans_Click(object sender, EventArgs e)
{
if (Class7.ShowMessageBox("Bạn c\x00f3 chắc chắn tạo giao dịch đặt h\x00e0ng n\x00e0y kh\x00f4ng ?", 2) == 1)
{
Class6 class2 = new Class6();
string str = class2.method_5("H");
string str2 = DateTime.ParseExact(this.Txt_DtDelivery.Text, "dd/MM/yyyy", null).ToString();
string str3 = Class7.smethod_53();
string str4 = (this.Txt_Remark.Text == string.Empty) ? "Đặt h\x00e0ng từ nh\x00e0 cung cấp" : this.Txt_Remark.Text;
string str5 = this.Txt_ExpID.Text.Trim();
if (this.Lbl_ExpName.Text == string.Empty)
{
Class7.ShowMessageBox("Bạn chưa chọn m\x00e3 nh\x00e0 cung cấp", 1);
this.Txt_ExpID.Focus();
}
else
{
using (WaitDialogForm form = new WaitDialogForm())
{
form.Caption = "Tạo giao dịch số " + str;
this.oleDbDataAdapter_0 = new OleDbDataAdapter("select goods_id,unitsymb, Name, qty, price,end_qty from " + this.string_0, this.oleDbConnection_0);
using (DataTable table = new DataTable())
{
this.oleDbDataAdapter_0.Fill(table);
this.oleDbConnection_0.Close();
foreach (DataRow row in table.Rows)
{
this.string_2 = string.Concat(new object[] {
"INSERT INTO tblOn_order (tran_date, tran_time, deliver_dt, trans_num, trans_code, exp_id, goods_id, qty, unit_symb, price, merc_type, user_id, remark,status,end_qty) VALUES ('", Class7.smethod_19(), "','", str3, "','", str2, "','", str, "','30','", str5, "','", row["goods_id"], "',", row["qty"], ",'", row["unitsymb"],
"',", row["price"], ",'01',", Class7.GetUserId(), ",N'", str4, "',1,", row["end_qty"], ") "
});
this.oleDbDataAdapter_0 = new OleDbDataAdapter(this.string_2, this.oleDbConnection_0);
using (DataSet set = new DataSet())
{
this.oleDbDataAdapter_0.Fill(set);
this.oleDbConnection_0.Close();
continue;
}
}
}
this.oleDbDataAdapter_0 = new OleDbDataAdapter("DELETE FROM " + this.string_0, this.oleDbConnection_0);
using (DataSet set2 = new DataSet())
{
this.oleDbDataAdapter_0.Fill(set2);
this.oleDbConnection_0.Close();
}
form.Close();
this.Txt_GoodsId.Text = string.Empty;
this.Txt_ExpID.Text = string.Empty;
this.Txt_ExpID.Enabled = true;
this.Lbl_ExpName.Text = string.Empty;
this.Lbl_MercName.Text = string.Empty;
class2.ComputeTransnum("H");
Class6.transNum = str;
this.method_0();
this.Txt_ExpID.Focus();
}
}
}
}
private void btn_Correct_Click(object sender, EventArgs e)
{
if (this.GridView1.RowCount != 0)
{
if (this.Lbl_StockName.Text == string.Empty)
{
Class7.ShowMessageBox("Bạn chưa chọn m\x00e3 kho, quầy !", 1);
this.Txt_StockId.Focus();
}
else if (Class7.ShowMessageBox("Bạn c\x00f3 chắc chắn hiệu chỉnh kh\x00f4ng ?", 2) == 1)
{
Class6 class2 = new Class6();
string str5 = class2.method_5("K");
WaitDialogForm form = new WaitDialogForm();
form.Caption = "Tạo giao dịch " + str5;
this.oleDbDataAdapter_0 = new OleDbDataAdapter("select tblAdjust.*, tblgoods.piceunit from tblAdjust inner join tblgoods on tblAdjust.goods_id = tblgoods.goods_id where tblAdjust.real_qty <> 0 ", this.oleDbConnection_0);
DataTable dataTable = new DataTable();
this.oleDbDataAdapter_0.Fill(dataTable);
this.oleDbConnection_0.Close();
if (dataTable.Rows.Count == 0)
{
Class7.ShowMessageBox("Kh\x00f4ng c\x00f3 sự ch\x00eanh lệch, kh\x00f4ng cần hiệu chỉnh !", 1);
form.Close();
}
else
{
string str = Class7.smethod_19();
string str2 = Class7.smethod_53();
string str3 = this.Txt_StockId.Text.Trim();
string str4 = "Giao dịch c\x00e2n đối kiểm k\x00ea tự động";
int num = 1;
foreach (DataRow row in dataTable.Rows)
{
string str6 = (Class7.ParseDoubleValue(row["real_qty"].ToString()) > 0.0) ? "" : str3;
string str7 = (Class7.ParseDoubleValue(row["real_qty"].ToString()) < 0.0) ? "" : str3;
double num2 = Math.Abs(Class7.ParseDoubleValue(row["real_qty"].ToString()));
double num3 = num2 * Class7.ParseDoubleValue(row["averimppr"].ToString());
string selectCommandText = string.Concat(new object[] {
"INSERT INTO tblTransaction(tran_date, tran_time, trans_num, trans_code, voucher, invoice, post, exp_id, imp_id,goods_id, qty, unit_symb, amount, discount, vat_amt, surplus, commis_amt, user_id,cs_id,remark, updated, merc_type, tax_code, vat_incl, discpervat, disc_incl, copies, recnum, Status) VALUES('", str, "','", str2, "','", str5, "','", this.string_0, "','','',0,'", str6, "','", str7, "','", row["goods_id"], "',", num2,
",'", row["piceunit"], "',", num3, ",0,0,0,0, ", Class7.GetUserId(), ",'',N'", str4, "',0,'01','',0,0,0,0,", num, ",1)"
});
this.oleDbDataAdapter_0 = new OleDbDataAdapter(selectCommandText, this.oleDbConnection_0);
using (DataSet set = new DataSet())
{
this.oleDbDataAdapter_0.Fill(set);
this.oleDbConnection_0.Close();
}
num++;
}
class2.ComputeTransnum("K");
form.Caption = "Tạo giao dịch " + str5;
this.method_2();
Class7.ShowMessageBox("Hiệu chỉnh dữ liệu th\x00e0nh c\x00f4ng !", 1);
form.Close();
}
}
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
if (this.Lbl_ImpName.Text == string.Empty)
{
Class7.ShowMessageBox("Bạn chưa khai b\x00e1o nơi nhập h\x00e0ng", 1);
this.Txt_ImpID.Focus();
}
else if (this.Lbl_ExpName.Text == string.Empty)
{
Class7.ShowMessageBox("Bạn chưa khai b\x00e1o nơi xuất h\x00e0ng", 1);
this.Txt_ExpID.Focus();
}
else if (this.TransDetail.RowCount == 0)
{
this.Txt_GoodsId.Focus();
}
else
{
string str2 = this.Txt_TransNum.Text.Trim();
string str3 = this.Txt_ExpID.Text.Trim();
string str4 = this.Txt_ImpID.Text.Trim();
string str5 = this.Txt_Remark.Text.Trim();
string str6 = this.Txt_Voucher.Text.Trim();
if (this.TransDetail.RowCount != 0)
{
Class6 class2 = new Class6();
string str = Class11.string_0;
if (str != null)
{
if (!(str == "N"))
{
if (str == "E")
{
this.btn_Skip_Click(this, new EventArgs());
class2.method_20(str2);
class2.method_10(str2);
class2.method_13(str2);
class2.method_6(this.string_0, str2, this.string_1, str3, str4, str6, str5, this.string_3);
class2.method_9(str2, str3);
}
}
else
{
this.btn_Skip_Click(this, new EventArgs());
class2.ComputeTransnum("K");
string str7 = Class7.smethod_53();
class2.method_6(this.string_0, str2, this.string_1, str3, str4, str6, str5, str7);
class2.method_19(str2);
class2.method_9(str2, str3);
}
}
Class6.transNum = str2;
v_tosupp sup = new v_tosupp();
sup.ShowPreviewDialog();
}
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
if (this.Lbl_ImpName.Text == string.Empty)
{
Class7.ShowMessageBox("Bạn chưa khai b\x00e1o nơi nhập h\x00e0ng", 1);
this.Txt_ImpID.Focus();
}
else if (this.Lbl_ExpName.Text == string.Empty)
{
Class7.ShowMessageBox("Bạn chưa khai b\x00e1o nơi xuất h\x00e0ng", 1);
this.Txt_ExpID.Focus();
}
else if (this.TransDetail.RowCount == 0)
{
this.Txt_GoodsId.Focus();
}
else
{
string str2 = this.Txt_TransNum.Text.Trim();
this.Txt_ExpID.Text.Trim();
this.Txt_ImpID.Text.Trim();
this.Txt_Remark.Text.Trim();
this.Txt_Voucher.Text.Trim();
if (this.TransDetail.RowCount != 0)
{
Class6 class2 = new Class6();
string str = Class11.string_0;
if (str != null)
{
if (!(str == "N"))
{
if (str == "E")
{
this.btn_Skip_Click(this, new EventArgs());
class2.method_10(str2);
this.method_5(str2);
class2.method_13(str2);
this.method_3();
this.method_6();
this.method_4();
}
}
else
{
this.btn_Skip_Click(this, new EventArgs());
class2.ComputeTransnum("K");
this.method_3();
this.method_6();
this.method_4();
}
}
Class6.transNum = str2;
Class7.CreateReportInstance(Class6.string_3).ShowPreviewDialog();
Class7.CreateReportInstance(Class6.string_4).ShowPreviewDialog();
}
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
if (this.Lbl_ExpName.Text == string.Empty)
{
this.Txt_ExpID.Focus();
}
else if (this.TransDetail.RowCount == 0)
{
this.Txt_GoodsId.Focus();
}
else
{
string str2 = this.Txt_TransNum.Text.Trim();
string str3 = this.Txt_ExpID.Text.Trim();
string str5 = this.Txt_Remark.Text.Trim();
string str4 = string.Empty;
if (this.TransDetail.RowCount != 0)
{
Class6 class2 = new Class6();
string str = Class11.string_0;
if (str != null)
{
if (!(str == "N"))
{
if (str == "E")
{
this.btn_Skip_Click(this, new EventArgs());
class2.method_10(str2);
class2.method_13(str2);
class2.method_6(this.string_1, str2, this.string_2, str3, "", str4, str5, this.string_3);
class2.method_9(str2, str3);
}
}
else
{
this.btn_Skip_Click(this, new EventArgs());
class2.ComputeTransnum("K");
string str6 = Class7.smethod_53();
class2.method_6(this.string_1, str2, this.string_2, str3, "", str4, str5, str6);
class2.method_9(str2, str3);
}
}
Class6.transNum = str2;
Class7.CreateReportInstance(Class6.string_3).ShowPreviewDialog();
}
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
if (this.Lbl_StockName.Text == string.Empty)
{
this.Txt_StockId.Focus();
}
else if (this.TransDetail.RowCount != 0)
{
string str5 = Class7.smethod_19();
string str4 = DateTime.Now.ToString("HH:mm");
string str3 = this.Txt_TransNum.Text.Trim();
string str2 = this.Txt_StockId.Text.Trim();
string str = this.Txt_Remark.Text.Trim();
Class6 class2 = new Class6();
string str6 = Class11.string_0;
if (str6 != null)
{
if (!(str6 == "N"))
{
if (str6 == "E")
{
this.bool_0 = false;
this.btn_Skip_Click(this, new EventArgs());
this.method_4();
class2.method_13(str3);
this.method_3();
this.method_2();
}
}
else
{
this.bool_0 = true;
this.btn_Skip_Click(this, new EventArgs());
class2.ComputeTransnum("K");
this.method_3();
this.method_2();
}
}
Class6.string_8 = str;
Class6.string_9 = str2;
Class6.transNum = str3;
Class6.string_6 = str4;
Class6.string_7 = str5;
Class7.CreateReportInstance(Class6.string_3).ShowPreviewDialog();
}
}
private void kCnalMegv(object sender, EventArgs e)
{
if (this.Lbl_ImpName.Text == string.Empty)
{
this.Txt_ImpID.Focus();
}
else if (this.Lbl_ExpName.Text == string.Empty)
{
this.Txt_ExpID.Focus();
}
else if (this.TransDetail.RowCount == 0)
{
this.Txt_GoodsId.Focus();
}
else
{
string str = this.Txt_TransNum.Text.Trim();
string str3 = this.Txt_ExpID.Text.Trim();
string str2 = this.Txt_ImpID.Text.Trim();
this.Txt_Remark.Text.Trim();
this.Txt_Voucher.Text.Trim();
int num1 = this.chk_inclVat.Checked ? 1 : 0;
int num2 = this.Chk_includedisc.Checked ? 1 : 0;
int num3 = this.Chk_discpervat.Checked ? 1 : 0;
this.Cmb_TaxCode.Text.Trim();
if (this.TransDetail.RowCount != 0)
{
Class6 class2 = new Class6();
string str4 = this.string_3;
if (str4 != null)
{
if (!(str4 == "N"))
{
if (str4 == "E")
{
this.bool_0 = false;
this.btn_Skip_Click(this, new EventArgs());
class2.method_18(str);
class2.method_8(str);
class2.method_13(str);
this.method_4();
class2.method_17(str);
class2.method_7(str, str2);
class2.kCnalMegv(this.string_0);
class2.method_11(this.string_0, str3);
}
}
else
{
this.bool_0 = true;
this.btn_Skip_Click(this, new EventArgs());
WaitDialogForm form = new WaitDialogForm();
form.Caption = "Xin đợi một ch\x00fat ....";
class2.ComputeTransnum("K");
this.method_4();
class2.method_17(str);
class2.method_7(str, str2);
class2.kCnalMegv(this.string_0);
class2.method_11(this.string_0, str3);
this.string_2 = "UPDATE tblOn_order SET status = 0 WHERE trans_num = '" + this.Txt_OrderNumber.Text + "' ";
this.oleDbDataAdapter_0 = new OleDbDataAdapter(this.string_2, this.oleDbConnection_0);
using (DataSet set = new DataSet())
{
this.oleDbDataAdapter_0.Fill(set);
this.oleDbConnection_0.Close();
}
form.Close();
}
}
Class6.transNum = str;
Class7.CreateReportInstance("v_frsupp").ShowPreviewDialog();
}
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
if (this.Lbl_ImpName.Text == string.Empty)
{
Class7.ShowMessageBox("Bạn chưa khai b\x00e1o nơi nhập h\x00e0ng", 1);
this.Txt_ImpID.Focus();
}
else if (this.Lbl_ExpName.Text == string.Empty)
{
Class7.ShowMessageBox("Bạn chưa khai b\x00e1o nơi xuất h\x00e0ng", 1);
this.Txt_ExpID.Focus();
}
else if (this.TransDetail.RowCount == 0)
{
this.Txt_GoodsId.Focus();
}
else
{
string str2 = this.Txt_TransNum.Text.Trim();
string str4 = this.Txt_ExpID.Text.Trim();
string str3 = this.Txt_ImpID.Text.Trim();
this.Txt_Remark.Text.Trim();
this.Txt_Voucher.Text.Trim();
int num1 = this.chk_inclVat.Checked ? 1 : 0;
int num2 = this.Chk_includedisc.Checked ? 1 : 0;
int num3 = this.Chk_discpervat.Checked ? 1 : 0;
this.CgeIdZyqWF.Text.Trim();
if (this.TransDetail.RowCount != 0)
{
Class6 class2 = new Class6();
string str5 = this.string_3;
if (str5 != null)
{
if (!(str5 == "N"))
{
if (str5 == "E")
{
this.iWyIskLbe(this, new EventArgs());
class2.method_18(str2);
class2.method_8(str2);
class2.method_13(str2);
this.method_4();
class2.method_17(str2);
class2.method_7(str2, str3);
class2.kCnalMegv(this.string_0);
class2.method_11(this.string_0, str4);
}
}
else
{
this.iWyIskLbe(this, new EventArgs());
class2.ComputeTransnum("K");
this.method_4();
class2.method_17(str2);
class2.method_7(str2, str3);
class2.kCnalMegv(this.string_0);
class2.method_11(this.string_0, str4);
}
}
if (this.chkLabelPrn.Checked)
{
this.oleDbDataAdapter_0 = new OleDbDataAdapter("DELETE FROM tblLABELS", this.oleDbConnection_0);
DataSet dataSet = new DataSet();
this.oleDbDataAdapter_0.Fill(dataSet);
this.oleDbConnection_0.Close();
string selectCommandText = "SELECT A.goods_id, A.full_name, A.grp_id,A.piceunit, A.merc_type, B.rtprice, C.trans_num,C.qty, C.exp_id,C.imp_id, C.recnum FROM tblGoods AS A INNER JOIN tblPrice AS B ON A.goods_id = B.goods_id INNER JOIN tblTransaction AS C ON A.goods_id = C.goods_id where C.trans_num = '" + str2 + "' ";
this.oleDbDataAdapter_0 = new OleDbDataAdapter(selectCommandText, Class7.oleDbConnection_1);
DataTable dataTable = new DataTable();
this.oleDbDataAdapter_0.Fill(dataTable);
Class7.oleDbConnection_1.Close();
foreach (DataRow row in dataTable.Rows)
{
selectCommandText = "INSERT INTO tblLABELS([idx],[timeinput],[goods_id],[fullname],[shortname],[grp_id],[supp_id],[rtprice],[qty],user_id) ";
object obj2 = selectCommandText;
obj2 = string.Concat(new object[] { obj2, "VALUES(", row["recnum"], ",'", row["recnum"].ToString(), "','", row["goods_id"], "','", row["full_name"], "','", row["full_name"], "'," });
OleDbDataAdapter adapter = new OleDbDataAdapter(string.Concat(new object[] { obj2, "'", row["grp_id"], "','", row["exp_id"], "','", row["rtprice"], "',", row["qty"], ",", Class7.GetUserId(), ")" }), this.oleDbConnection_0);
using (DataSet set = new DataSet())
{
adapter.Fill(set);
}
this.oleDbConnection_0.Close();
}
}
Class6.transNum = str2;
Class7.CreateReportInstance("v_frsupp").ShowPreviewDialog();
}
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
if (this.Lbl_ImpName.Text == string.Empty)
{
Class7.ShowMessageBox("Bạn chưa khai b\x00e1o nơi nhập h\x00e0ng", 1);
this.Txt_ImpID.Focus();
}
else if (this.Lbl_ExpName.Text == string.Empty)
{
Class7.ShowMessageBox("Bạn chưa khai b\x00e1o nơi xuất h\x00e0ng", 1);
this.Txt_ExpID.Focus();
}
else if (this.TransDetail.RowCount == 0)
{
this.Txt_GoodsId.Focus();
}
else
{
string str = this.Txt_TransNum.Text.Trim();
string str3 = this.Txt_ExpID.Text.Trim();
string str4 = this.Txt_ImpID.Text.Trim();
string str6 = this.Txt_Remark.Text.Trim();
string str5 = string.Empty;
if (this.TransDetail.RowCount != 0)
{
Class6 class2 = new Class6();
WaitDialogForm form = new WaitDialogForm();
form.Caption = "Xin chờ một ch\x00fat ....";
string str7 = Class11.string_0;
if (str7 != null)
{
if (!(str7 == "N"))
{
if (str7 == "E")
{
this.iWyIskLbe(this, new EventArgs());
class2.method_18(str);
this.IjSwogAv6();
this.method_4();
this.method_2();
this.method_3();
class2.method_13(str);
class2.method_6(this.string_1, str, this.string_4, str3, str4, str5, str6, this.string_3);
}
}
else
{
this.iWyIskLbe(this, new EventArgs());
class2.ComputeTransnum("K");
string str8 = Class7.smethod_53();
class2.method_6(this.string_1, str, this.string_4, str3, str4, str5, str6, str8);
class2.method_17(str);
this.method_3();
this.method_2();
}
}
if (this.chkLabelPrn.Checked)
{
this.oleDbDataAdapter_0 = new OleDbDataAdapter("DELETE FROM tblLABELS", this.oleDbConnection_1);
DataSet dataSet = new DataSet();
this.oleDbDataAdapter_0.Fill(dataSet);
this.oleDbConnection_1.Close();
string selectCommandText = "SELECT A.goods_id, A.full_name, A.grp_id,A.piceunit, A.merc_type, B.rtprice, C.trans_num,C.qty, C.exp_id,C.imp_id, C.recnum FROM tblGoods AS A INNER JOIN tblPrice AS B ON A.goods_id = B.goods_id INNER JOIN tblTransaction AS C ON A.goods_id = C.goods_id where C.trans_num = '" + str + "' ";
this.oleDbDataAdapter_0 = new OleDbDataAdapter(selectCommandText, Class7.oleDbConnection_1);
DataTable dataTable = new DataTable();
this.oleDbDataAdapter_0.Fill(dataTable);
Class7.oleDbConnection_1.Close();
foreach (DataRow row in dataTable.Rows)
{
selectCommandText = "INSERT INTO tblLABELS([idx],[timeinput],[goods_id],[fullname],[shortname],[grp_id],[supp_id],[rtprice],[qty],user_id) ";
object obj2 = selectCommandText;
obj2 = string.Concat(new object[] { obj2, "VALUES(", row["recnum"], ",'", row["recnum"].ToString(), "','", row["goods_id"], "','", row["full_name"], "','", row["full_name"], "'," });
OleDbDataAdapter adapter = new OleDbDataAdapter(string.Concat(new object[] { obj2, "'", row["grp_id"], "','", row["exp_id"], "','", row["rtprice"], "',", row["qty"], ",", Class7.GetUserId(), ")" }), this.oleDbConnection_1);
using (DataSet set2 = new DataSet())
{
adapter.Fill(set2);
}
this.oleDbConnection_1.Close();
}
}
form.Close();
Class6.transNum = str;
Class7.CreateReportInstance("v_mercmove").ShowPreviewDialog();
Class7.CreateReportInstance("v_mercmove1").ShowPreviewDialog();
}
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
if (this.Sales_View.RowCount != 0)
{
this.Txt_Barcode.Enabled = false;
this.Txt_Qty.Enabled = false;
this.Txt_Unit.Enabled = false;
this.btn_New.Enabled = true;
this.btn_Save.Enabled = false;
Class6 class2 = new Class6();
class2.ComputeTransnum("P");
Class6.transNum = this.Txt_TransNum.Text.Trim();
string str5 = Class7.smethod_19();
string str2 = Class7.smethod_40();
string str6 = Class7.smethod_53();
int num12 = Class7.GetUserId();
string str8 = "B\x00e1n lẻ h\x00e0ng h\x00f3a";
string str4 = "";
this.string_1 = "select idx, goods_id,price, qty, qty*price as amount,(qty*price)*(rt_discpc + pc_disc + card_disc) as discamt, kit_qty, kit_id from " + this.string_0 + " where goods_id <> '' ";
this.oleDbDataAdapter_0 = new OleDbDataAdapter(this.string_1, this.oleDbConnection_0);
DataTable dataTable = new DataTable();
this.oleDbDataAdapter_0.Fill(dataTable);
this.oleDbConnection_0.Close();
string str7 = this.Txt_Unit.Text.Trim();
foreach (DataRow row in dataTable.Rows)
{
string str = row["goods_id"].ToString().Trim();
double num2 = class2.method_16(str2, str);
double num3 = Class7.smethod_2(row["qty"]);
double num4 = Class7.smethod_2(row["kit_qty"]);
string str3 = row["kit_id"].ToString().Trim();
double num5 = Class7.smethod_2(row["price"]);
Math.Round((double)(num2 * num3), 2);
double num6 = Class7.smethod_2(row["discamt"]);
double num7 = Class7.smethod_2(row["amount"]) - num6;
double num8 = Math.Round((double)((num7 / (1.0 + (Class10.smethod_1(str) / 100.0))) * (Class10.smethod_1(str) / 100.0)), 2);
double num9 = Math.Round((double)((((num5 - num2) * num3) - num8) - num6), 2);
int num10 = Class7.smethod_51();
str4 = Class10.smethod_1(str).ToString();
this.string_1 = string.Concat(new object[] {
"INSERT INTO tblTransaction(tran_date, tran_time, trans_num, trans_code, voucher, kit_id, kit_qty, goods_id, qty,unit_symb, amount, discount, surplus, vat_amt, commis_amt, user_id, ref, custax_id,card_id, exp_id, cs_id, merc_type, tax_code, vat_incl, invoice, updated, copies, Shift, recnum,remark, status, discpervat, disc_incl,station) VALUES('", str5, "','", str6, "','", Class6.transNum, "','00','','", str3, "', ", num4, ",'", str, "',", num3, ",'", str7,
"',", num5 * num3, ",", num6, ",", num9, ",", num8, ",0,", num12, ",'','','','", str2, "','','01','", str4, "',0,'',0,1,0,", row["idx"],
",N'", str8, "',1,0,0,", num10, ")"
});
this.oleDbDataAdapter_0 = new OleDbDataAdapter(this.string_1, this.oleDbConnection_0);
using (DataSet set2 = new DataSet())
{
this.oleDbDataAdapter_0.Fill(set2);
}
this.oleDbConnection_0.Close();
}
this.oleDbDataAdapter_0 = new OleDbDataAdapter("SELECT goods_id,qty,amount FROM tblTransaction where trans_num = '" + Class6.transNum + "'", this.oleDbConnection_0);
DataTable table = new DataTable();
this.oleDbDataAdapter_0.Fill(table);
this.oleDbConnection_0.Close();
foreach (DataRow row in table.Rows)
{
double num13 = class2.method_16(str2, row["goods_id"].ToString()) * Class7.ParseDoubleValue(row["qty"].ToString());
this.string_1 = string.Concat(new object[] {
"IF EXISTS (SELECT id FROM tblStockInfo WHERE id = '", str2, "' AND goods_id = '", row["goods_id"], "') UPDATE tblStockInfo SET exp_qty = exp_qty + ", row["qty"], " , exp_amt = exp_amt + ", num13, ", last_date ='", str5, "' WHERE id = '", str2, "' AND goods_id = '", row["goods_id"], "' Else INSERT INTO tblStockInfo(id,goods_id, exp_qty,exp_amt,last_date ) VALUES('", str2,
"','", row["goods_id"], "',", row["qty"], ",", num13, ",'", str5, "')"
});
this.oleDbDataAdapter_0 = new OleDbDataAdapter(this.string_1, this.oleDbConnection_0);
using (DataSet set3 = new DataSet())
{
this.oleDbDataAdapter_0.Fill(set3);
}
this.oleDbConnection_0.Close();
}
this.string_2 = "D";
if (Class10.double_2 != 0.0)
{
double num = Class7.ParseDoubleValue(this.Lbl_LastAmount.Text);
this.string_1 = string.Concat(new object[] { "INSERT INTO tblTransValue([trans_num],[amount],[frcustomer]) VALUES('", Class6.transNum, "',", num, ",", Class10.double_2, ")" });
this.oleDbDataAdapter_0 = new OleDbDataAdapter(this.string_1, this.oleDbConnection_0);
using (DataSet set = new DataSet())
{
this.oleDbDataAdapter_0.Fill(set);
this.oleDbConnection_0.Close();
}
}
Class11.string_1 = "N";
voucher_1 r_ = new voucher_1();
r_.PrintingSystem.ShowMarginsWarning = false;
r_.PrintingSystem.ShowPrintStatusDialog = false;
this.btn_Skip_Click(this, new EventArgs());
this.btn_New.Focus();
try
{
r_.Print();
}
catch (Exception)
{
Class7.ShowMessageBox("Kh\x00f4ng t\x00ecm thấy m\x00e1y in", 1);
}
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
string str7;
string str = this.Txt_TransNum.Text.Trim();
string str2 = this.Txt_OldTrans.Text.Trim();
string str3 = this.Txt_ExpID.Text.Trim();
string str4 = this.Txt_ImpID.Text.Trim();
string str5 = this.Txt_Remark.Text.Trim();
string str6 = this.Txt_Voucher.Text.Trim();
if (this.TransDetail.RowCount == 0)
{
return;
}
Class6 class2 = new Class6();
if (!class2.method_22())
{
this.string_4 = "select goods_id, imp_id, qty from tblTransaction where trans_num = '" + str2 + "'";
this.oleDbDataAdapter_0 = new OleDbDataAdapter(this.string_4, this.oleDbConnection_1);
using (DataTable table = new DataTable())
{
this.oleDbDataAdapter_0.Fill(table);
this.oleDbConnection_1.Close();
IEnumerator enumerator = table.Rows.GetEnumerator();
while (enumerator.MoveNext())
{
DataRow current = (DataRow)enumerator.Current;
if (class2.method_21(current["goods_id"].ToString(), current["imp_id"].ToString()) < Class7.smethod_2(current["qty"]))
{
goto Label_0149;
}
}
goto Label_0183;
Label_0149:
Class7.ShowMessageBox("Số lượng tồn kh\x00f4ng đủ để xuất kho !", 1);
return;
}
}
Label_0183:
str7 = Class11.string_0;
if (str7 != null)
{
if (!(str7 == "N"))
{
if (str7 == "E")
{
this.btn_Skip_Click(this, new EventArgs());
class2.method_20(str);
class2.method_10(str);
class2.method_13(str);
class2.method_6(this.string_0, str, this.string_1, str3, str4, str6, str5, this.string_3);
class2.method_9(str, str3);
}
}
else
{
this.btn_Skip_Click(this, new EventArgs());
class2.ComputeTransnum("K");
this.ddvqeXfa4(this.string_0, str, this.string_1, str3, str4, str6, str5);
class2.method_19(str);
class2.method_9(str, str3);
}
}
Class6.transNum = str;
Class7.CreateReportInstance(Class6.string_3).ShowPreviewDialog();
}