Esempio n. 1
0
 private void RrqIxZxw5(object sender, PrintEventArgs e)
 {
     this.xrtableCell_0.Text = Class13.smethod_1(Class7.smethod_14("m_name").ToString(), Class13.string_0);
     this.xrtableCell_1.Text = Class13.smethod_1(Class7.smethod_14("m_address").ToString(), Class13.string_0);
     this.xrtableCell_2.Text = Class13.smethod_1(Class7.smethod_14("m_phone").ToString(), Class13.string_0);
     this.string_0           = "SELECT [trans_num] ,[idx],[goods_id],[Name],[qty],[unit],[price] ,[rt_discpc],[pc_disc],[card_disc],[user_id],[pos_id]  FROM [pos_data].[dbo].[tblSuspend] WHERE (trans_num = '" + Class6.transNum + "')";
     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();
         base.DataAdapter = this.oleDbDataAdapter_0;
         base.DataSource  = set.Tables[0];
     }
     this.xrtableCell_14.DataBindings.Add("Text", base.DataSource, "idx", "{0:n0}");
     this.xrtableCell_15.DataBindings.Add("Text", base.DataSource, "goods_id", "");
     this.xrtableCell_16.DataBindings.Add("Text", base.DataSource, "name", "");
     this.xrtableCell_18.DataBindings.Add("Text", base.DataSource, "price", "{0:n0}");
     this.xrtableCell_20.DataBindings.Add("Text", base.DataSource, "qty", "{0:n2}");
     this.xrtableCell_19.DataBindings.Add("Text", base.DataSource, "totalamt", "{0:n0}");
     this.xrtableCell_7.Text  = DateTime.Now.ToString("dd/MM/yyyy");
     this.xrtableCell_5.Text  = Class6.transNum;
     this.xrtableCell_8.Text  = DateTime.Now.ToString("HH:mm");
     this.xrtableCell_10.Text = Class7.Name;
 }
Esempio n. 2
0
        private void reportHeaderBand_0_BeforePrint(object sender, PrintEventArgs e)
        {
            this.xrlabel_2.Text = Class13.smethod_1(Class7.smethod_14("m_name").ToString(), Class13.string_0);
            this.xrlabel_4.Text = Class13.smethod_1(Class7.smethod_14("m_vatnum").ToString(), Class13.string_0);
            this.pfeZyQnoF.Text = Class6.string_10.ToUpper();
            string str  = string.Format("{0:dd/MM/yyyy}", Class7.dateTimeFrom);
            string str2 = string.Format("{0:dd/MM/yyyy}", Class7.dateTimeTo);

            this.xrlabel_0.Text = (Class7.dateTimeFrom == Class7.dateTimeTo) ? ("Trong ng\x00e0y " + str) : ("Từ ng\x00e0y :" + str + " đến ng\x00e0y :" + str2);
        }
Esempio n. 3
0
 private void FrmSystemInfo_Load(object sender, EventArgs e)
 {
     this.Text                = "Chỉnh sửa th\x00f4ng số hệ thống";
     this.Txt_Address.Text    = Class13.smethod_1(Class7.smethod_14("m_address").ToString(), Class13.string_0);
     this.Txt_Fax.Text        = Class13.smethod_1(Class7.smethod_14("m_fax").ToString(), Class13.string_0);
     this.Txt_Phone.Text      = Class13.smethod_1(Class7.smethod_14("m_phone").ToString(), Class13.string_0);
     this.Txt_FullName.Text   = Class13.smethod_1(Class7.smethod_14("m_name").ToString(), Class13.string_0);
     this.Txt_VatNumb.Text    = Class13.smethod_1(Class7.smethod_14("m_vatnum").ToString(), Class13.string_0);
     this.Chk_Minus.Checked   = Class7.smethod_14("m_minus").ToString() == "1";
     this.btn_Confirm.Enabled = Class7.smethod_50();
 }
Esempio n. 4
0
        private void sumsaler_BeforePrint(object sender, PrintEventArgs e)
        {
            this.string_0           = string.Concat(new object[] { "SELECT DISTINCT ptr.user_id, tblUser.name, SUM(CASE ptr.trans_code WHEN '01' THEN ptr.amount ELSE 0 END) AS rtamount, COUNT(ptr.trans_num) AS ctrannum, SUM(CASE ptr.trans_code WHEN '00' THEN ptr.amount ELSE 0 END) AS amount, SUM(ptr.discount) AS discount, ptr.Status, tblStations.name AS station FROM tblTransaction AS ptr INNER JOIN tblUser ON ptr.user_id = tblUser.ID INNER JOIN  tblStations ON ptr.station = tblStations.id WHERE ptr.status = 1 AND ptr.trans_code IN('00','01') AND ( ptr.tran_date between  '", Class7.dateTimeFrom, "' and '", Class7.dateTimeTo, "') GROUP BY ptr.user_id, tblUser.name,ptr.status, tblStations.name " });
            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();
                base.DataAdapter = this.oleDbDataAdapter_0;
                base.DataSource  = set.Tables[0];
            }
            this.xrtableCell_4.DataBindings.Add("Text", base.DataSource, "amount", "{0:n2}");
            this.xrtableCell_3.DataBindings.Add("Text", base.DataSource, "discount", "{0:n2}");
            this.xrtableCell_14.DataBindings.Add("Text", base.DataSource, "ctrannum", "{0:n0}");
            this.xrtableCell_17.DataBindings.Add("Text", base.DataSource, "station", "");
            this.xrtableCell_1.DataBindings.Add("Text", base.DataSource, "name", "");
            this.xrtableCell_0.DataBindings.Add("Text", base.DataSource, "user_id", "{0:n0}");
            this.xrtableCell_2.DataBindings.Add("Text", base.DataSource, "rtamount", "{0:n2}");
            XRSummary summary = new XRSummary();

            this.xrtableCell_8.DataBindings.Add("Text", base.DataSource, "amount", "{0:n2}");
            summary.Running            = SummaryRunning.Report;
            summary.FormatString       = "{0:n2}";
            this.xrtableCell_8.Summary = summary;
            XRSummary summary2 = new XRSummary();

            this.xrtableCell_7.DataBindings.Add("Text", base.DataSource, "discount", "{0:n2}");
            summary2.Running           = SummaryRunning.Report;
            summary2.FormatString      = "{0:n2}";
            this.xrtableCell_7.Summary = summary2;
            XRSummary summary3 = new XRSummary();

            this.xrtableCell_6.DataBindings.Add("Text", base.DataSource, "rtamount", "{0:n2}");
            summary3.Running           = SummaryRunning.Report;
            summary3.FormatString      = "{0:n2}";
            this.xrtableCell_6.Summary = summary3;
            XRSummary summary4 = new XRSummary();

            this.xrtableCell_16.DataBindings.Add("Text", base.DataSource, "ctrannum", "{0:n0}");
            summary4.Running            = SummaryRunning.Report;
            summary4.FormatString       = "{0:n0}";
            this.xrtableCell_16.Summary = summary4;
            this.xrlabel_6.Text         = Class13.smethod_1(Class7.smethod_14("m_name").ToString(), Class13.string_0);
            this.xrlabel_5.Text         = Class13.smethod_1(Class7.smethod_14("m_address").ToString(), Class13.string_0);
            this.xrlabel_2.Text         = Class13.smethod_1(Class7.smethod_14("m_phone").ToString(), Class13.string_0);
            this.xrlabel_0.Text         = Class13.smethod_1(Class7.smethod_14("m_vatnum").ToString(), Class13.string_0);
            this.xrlabel_8.Text         = Class6.string_10.ToUpper();
            string str  = string.Format("{0:dd/MM/yyyy}", Class7.dateTimeFrom);
            string str2 = string.Format("{0:dd/MM/yyyy}", Class7.dateTimeTo);

            this.xrlabel_7.Text = (Class7.dateTimeFrom == Class7.dateTimeTo) ? ("Trong ng\x00e0y " + str) : ("Từ ng\x00e0y :" + str + " đến ng\x00e0y :" + str2);
        }
Esempio n. 5
0
        private void reportHeaderBand_0_BeforePrint(object sender, PrintEventArgs e)
        {
            if (FrmReports._sumrp)
            {
                this.detailBand_0.Visible = false;
            }
            this.xrlabel_2.Text = Class13.smethod_1(Class7.smethod_14("m_name").ToString(), Class13.string_0);
            this.xrlabel_4.Text = Class13.smethod_1(Class7.smethod_14("m_vatnum").ToString(), Class13.string_0);
            this.xrlabel_0.Text = "SỔ CHI TIẾT TK : " + Class12.string_3;
            string str  = string.Format("{0:dd/MM/yyyy}", Class7.dateTimeFrom);
            string str2 = string.Format("{0:dd/MM/yyyy}", Class7.dateTimeTo);

            this.xrlabel_1.Text = (Class7.dateTimeFrom == Class7.dateTimeTo) ? ("Trong ng\x00e0y " + str) : ("Từ ng\x00e0y :" + str + " đến ng\x00e0y :" + str2);
            string str3 = null;

            Class7.smethod_17("name", "tblAccount", "account_id", Class12.string_3, "", this.oleDbConnection_0, ref str3);
            this.xrlabel_12.Text = str3;
        }
Esempio n. 6
0
 private void RrqIxZxw5(object sender, PrintEventArgs e)
 {
     this.string_0           = "SELECT tr.goods_id, gs.full_name, tr.trans_num, tr.corr_tran AS oldtran, tr.tran_date, tr.trans_code, tr.tran_time, tr.exp_id, tr.cs_id, tr.qty, tr.due_date, tr.user_id, tr.remark,  cs.fullname AS csname, cs.address, cs.phone FROM tblLoanTran AS tr INNER JOIN tblGoods AS gs ON tr.goods_id = gs.goods_id INNER JOIN tblCustomer AS cs ON tr.cs_id = cs.id WHERE tr.trans_num = '" + Class6.transNum + "'";
     this.oleDbDataAdapter_0 = new OleDbDataAdapter(this.string_0, this.oleDbConnection_0);
     using (DataSet set = new DataSet())
     {
         this.oleDbDataAdapter_0.Fill(set, "loantran");
         this.oleDbConnection_0.Close();
         this.dataSet1.Merge(set.Tables[0]);
     }
     for (int i = 0; i < this.dataSet1.Tables["loantran"].Rows.Count; i++)
     {
         this.dataSet1.Tables["loantran"].Rows[i]["idx"] = i + 1;
     }
     this.xrlabel_7.Text = Class13.smethod_1(Class7.smethod_14("m_name").ToString(), Class13.string_0);
     this.xrlabel_6.Text = Class13.smethod_1(Class7.smethod_14("m_address").ToString(), Class13.string_0);
     this.xrlabel_2.Text = Class13.smethod_1(Class7.smethod_14("m_phone").ToString(), Class13.string_0);
 }
Esempio n. 7
0
    public static string smethod_5(string string_9)
    {
        string str = null;

        try
        {
            string       str2;
            StreamReader reader = System.IO.File.OpenText(string.Format(@"{0}\config.ini", Application.StartupPath));
            while (!string.IsNullOrEmpty(str2 = reader.ReadLine()))
            {
                if (Class13.smethod_1(str2, Class13.string_0).Substring(0, Class13.smethod_1(str2, Class13.string_0).IndexOf('=')) == string_9)
                {
                    str = Class13.smethod_1(str2, Class13.string_0).Substring(Class13.smethod_1(str2, Class13.string_0).IndexOf('=') + 1);
                }
            }
            reader.Close();
        }
        catch (FileNotFoundException)
        {
            str = "";
        }
        return(str);
    }
Esempio n. 8
0
 private void voucher_2_BeforePrint(object sender, PrintEventArgs e)
 {
     this.xrtableCell_0.Text = Class13.smethod_1(Class7.smethod_14("m_name").ToString(), Class13.string_0);
     this.xrtableCell_1.Text = Class13.smethod_1(Class7.smethod_14("m_address").ToString(), Class13.string_0);
     this.xrtableCell_2.Text = Class13.smethod_1(Class7.smethod_14("m_phone").ToString(), Class13.string_0);
     this.string_0           = "SELECT  ptr.tran_date, ptr.tran_time, ptr.trans_num, ptr.trans_code, ptr.goods_id, ptr.qty,ptr.amount , ptr.discount, ptr.surplus, ptr.vat_amt, ptr.commis_amt, ptr.user_id, ptr.ref, ptr.custax_id, ptr.card_id, ptr.exp_id, ptr.cs_id, ptr.merc_type, ptr.tax_code, ptr.vat_incl, ptr.invoice, ptr.updated, ptr.copies, ptr.Shift, ptr.recnum, ptr.kit_id, ptr.kit_qty, gs.full_name, gs.piceunit, ptr.status, ptr.amount  + ptr.discount / ptr.qty AS price, us.name, tblStore.Name AS posname, tblStore.address, tblStore.phone,  (ptr.amount + ptr.discount) as totalamt , (ptr.amount - ptr.discount) as payamt  FROM  tblTransaction AS ptr INNER JOIN  tblGoods AS gs ON ptr.goods_id = gs.goods_id INNER JOIN  tblUser AS us ON ptr.user_id = us.ID INNER JOIN  tblStore ON ptr.exp_id = tblStore.id  WHERE (ptr.trans_num = '" + Class6.transNum + "')";
     this.oleDbDataAdapter_0 = new OleDbDataAdapter(this.string_0, this.AhxsdynSH);
     using (DataSet set = new DataSet())
     {
         this.oleDbDataAdapter_0.Fill(set);
         this.AhxsdynSH.Close();
         base.DataAdapter = this.oleDbDataAdapter_0;
         base.DataSource  = set.Tables[0];
     }
     this.xrtableCell_14.DataBindings.Add("Text", base.DataSource, "recnum", "{0:n0}");
     this.xrtableCell_15.DataBindings.Add("Text", base.DataSource, "goods_id", "");
     this.xrtableCell_16.DataBindings.Add("Text", base.DataSource, "full_name", "");
     this.xrtableCell_18.DataBindings.Add("Text", base.DataSource, "price", "{0:n0}");
     this.xrtableCell_26.DataBindings.Add("Text", base.DataSource, "qty", "{0:n2}");
     this.xrtableCell_19.DataBindings.Add("Text", base.DataSource, "totalamt", "{0:n0}");
     this.xrtableCell_7.DataBindings.Add("Text", base.DataSource, "tran_date", "{0:dd/MM/yyyy}");
     this.xrtableCell_5.DataBindings.Add("Text", base.DataSource, "trans_num", "");
     this.xrtableCell_8.DataBindings.Add("Text", base.DataSource, "tran_time", "");
     this.xrtableCell_10.DataBindings.Add("Text", base.DataSource, "name", "");
     this.xrtableCell_22.DataBindings.Add("Text", base.DataSource, "totalamt", "{0:n0}");
     this.xrsummary_0.Running      = SummaryRunning.Report;
     this.xrsummary_0.FormatString = "{0:n0}";
     this.xrtableCell_22.Summary   = this.xrsummary_0;
     this.xrtableCell_25.DataBindings.Add("Text", base.DataSource, "discount", "{0:n0}");
     this.xrsummary_1.Running      = SummaryRunning.Report;
     this.xrsummary_1.FormatString = "{0:n0}";
     this.xrtableCell_25.Summary   = this.xrsummary_1;
     this.xrtableCell_29.DataBindings.Add("Text", base.DataSource, "amount", "{0:n0}");
     this.xrsummary_2.Running      = SummaryRunning.Report;
     this.xrsummary_2.FormatString = "{0:n0}";
     this.xrtableCell_29.Summary   = this.xrsummary_2;
 }
Esempio n. 9
0
 private void Txt_Id_EditValueChanged(object sender, EventArgs e)
 {
     if (!(Class11.string_0 != "S"))
     {
         OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM " + base.Tag.ToString() + " WHERE ID = '" + this.Txt_Id.Text + "' ", Class7.oleDbConnection_1);
         DataSet          dataSet = new DataSet();
         adapter.Fill(dataSet);
         Class7.oleDbConnection_1.Close();
         if (dataSet.Tables[0].Rows.Count != 0)
         {
             this.Txt_ShortName.Text      = dataSet.Tables[0].Rows[0]["Name"].ToString();
             this.Txt_FullName.Text       = dataSet.Tables[0].Rows[0]["full_name"].ToString();
             this.Txt_Password.Text       = string.IsNullOrEmpty(dataSet.Tables[0].Rows[0]["passw"].ToString()) ? "" : Class13.smethod_1(dataSet.Tables[0].Rows[0]["passw"].ToString(), Class13.string_0);
             this.Cmb_Group.SelectedIndex = int.Parse(dataSet.Tables[0].Rows[0]["groups"].ToString()) - 1;
             this.Txt_Password1.Text      = string.IsNullOrEmpty(dataSet.Tables[0].Rows[0]["passw"].ToString()) ? "" : Class13.smethod_1(dataSet.Tables[0].Rows[0]["passw"].ToString(), Class13.string_0);
             this.Txt_Status.Text         = (dataSet.Tables[0].Rows[0]["status"].ToString() == "True") ? "Đang hoạt động" : "Đ\x00e3 bị x\x00f3a";
             Class11.smethod_3(this);
             Class11.smethod_5(this, "F");
             this.btn_Delete.Text = (dataSet.Tables[0].Rows[0]["status"].ToString() == "True") ? "&X\x00f3a" : "&Phục hồi";
         }
     }
 }
Esempio n. 10
0
        private void voucher_1_BeforePrint(object sender, PrintEventArgs e)
        {
            DataSet set;

            this.xrtableCell_0.Text = Class13.smethod_1(Class7.smethod_14("m_name").ToString(), Class13.string_0);
            this.xrtableCell_1.Text = Class13.smethod_1(Class7.smethod_14("m_address").ToString(), Class13.string_0);
            this.xrtableCell_2.Text = Class13.smethod_1(Class7.smethod_14("m_phone").ToString(), Class13.string_0);
            this.string_0           = "SELECT  ptr.tran_date, ptr.tran_time, ptr.trans_num, ptr.trans_code, ptr.goods_id, ptr.qty,ptr.amount , ptr.discount, ptr.surplus, ptr.vat_amt, ptr.commis_amt, ptr.user_id, ptr.ref, ptr.custax_id, ptr.card_id, ptr.exp_id, ptr.cs_id, ptr.merc_type, ptr.tax_code, ptr.vat_incl, ptr.invoice, ptr.updated, ptr.copies, ptr.Shift, ptr.recnum, ptr.kit_id, ptr.kit_qty, gs.full_name, gs.piceunit, ptr.status, ptr.amount / ptr.qty AS price, us.name, tblStore.Name AS posname, tblStore.address, tblStore.phone,  ptr.amount as totalamt, (ptr.amount - ptr.discount) as payamt  FROM  tblTransaction AS ptr INNER JOIN  tblGoods AS gs ON ptr.goods_id = gs.goods_id INNER JOIN  tblUser AS us ON ptr.user_id = us.ID INNER JOIN  tblStore ON ptr.exp_id = tblStore.id  WHERE (ptr.trans_num = '" + Class6.transNum + "')";
            this.oleDbDataAdapter_0 = new OleDbDataAdapter(this.string_0, this.oleDbConnection_0);
            using (set = new DataSet())
            {
                this.oleDbDataAdapter_0.Fill(set);
                this.oleDbConnection_0.Close();
                base.DataAdapter = this.oleDbDataAdapter_0;
                base.DataSource  = set.Tables[0];
            }
            this.xrtableCell_14.DataBindings.Add("Text", base.DataSource, "recnum", "{0:n0}");
            this.xrtableCell_15.DataBindings.Add("Text", base.DataSource, "goods_id", "");
            this.xrtableCell_16.DataBindings.Add("Text", base.DataSource, "full_name", "");
            this.xrtableCell_18.DataBindings.Add("Text", base.DataSource, "price", "{0:n0}");
            this.xrtableCell_26.DataBindings.Add("Text", base.DataSource, "qty", "{0:n2}");
            this.xrtableCell_19.DataBindings.Add("Text", base.DataSource, "totalamt", "{0:n0}");
            this.xrtableCell_7.DataBindings.Add("Text", base.DataSource, "tran_date", "{0:dd/MM/yyyy}");
            this.xrtableCell_5.DataBindings.Add("Text", base.DataSource, "trans_num", "");
            this.xrtableCell_8.DataBindings.Add("Text", base.DataSource, "tran_time", "");
            this.xrtableCell_10.DataBindings.Add("Text", base.DataSource, "name", "");
            this.xrtableCell_22.DataBindings.Add("Text", base.DataSource, "totalamt", "{0:n0}");
            this.ecgIrJiEyW.Running      = SummaryRunning.Report;
            this.ecgIrJiEyW.FormatString = "{0:n0}";
            this.xrtableCell_22.Summary  = this.ecgIrJiEyW;
            this.xrtableCell_25.DataBindings.Add("Text", base.DataSource, "discount", "{0:n0}");
            this.xrsummary_0.Running      = SummaryRunning.Report;
            this.xrsummary_0.FormatString = "{0:n0}";
            this.xrtableCell_25.Summary   = this.xrsummary_0;
            this.xrtableCell_29.DataBindings.Add("Text", base.DataSource, "payamt", "{0:n0}");
            this.xrsummary_1.Running      = SummaryRunning.Report;
            this.xrsummary_1.FormatString = "{0:n0}";
            this.xrtableCell_29.Summary   = this.xrsummary_1;
            this.string_0           = "SELECT [trans_num],[frcustomer], [frcustomer] - [amount] AS payback FROM [tblTransValue] WHERE trans_num = '" + Class6.transNum + "' ";
            this.oleDbDataAdapter_0 = new OleDbDataAdapter(this.string_0, this.oleDbConnection_0);
            using (set = new DataSet())
            {
                this.oleDbDataAdapter_0.Fill(set);
                this.oleDbConnection_0.Close();
                if (set.Tables[0].Rows.Count != 0)
                {
                    this.xrtableCell_30.Text = string.Format("{0:n0}", set.Tables[0].Rows[0]["frcustomer"]);
                    this.xrtableCell_37.Text = string.Format("{0:n0}", set.Tables[0].Rows[0]["payback"]);
                }
                else
                {
                    this.xrtableCell_30.Text = string.Empty;
                    this.xrtableCell_37.Text = string.Empty;
                }
            }
            if (Class11.string_1 == "R")
            {
                base.Watermark.Text = "doublicate invoice";
            }
            else
            {
                base.Watermark.Text = "";
            }
        }
Esempio n. 11
0
 // Token: 0x060002C5 RID: 709 RVA: 0x0001750C File Offset: 0x0001570C
 private void method_4(string string_0, string string_1)
 {
     this.httpClient_0.DefaultRequestHeaders.Remove("X-Request-Auth");
     if (string_0.Contains("footpatrol"))
     {
         this.httpClient_0.DefaultRequestHeaders.TryAddWithoutValidation("X-Request-Auth", Class13.smethod_0(string_0, string_1));
         return;
     }
     if (string_0.Contains("thehipstore"))
     {
         this.httpClient_0.DefaultRequestHeaders.TryAddWithoutValidation("X-Request-Auth", Class13.smethod_1(string_0, string_1));
     }
 }
Esempio n. 12
0
 // Token: 0x060002C5 RID: 709 RVA: 0x00019ABC File Offset: 0x00017CBC
 private void method_4(string string_0, string string_1)
 {
     this.httpClient_0.DefaultRequestHeaders.Remove(Class185.smethod_0(537711332));
     if (string_0.Contains(Class185.smethod_0(537700113)))
     {
         this.httpClient_0.DefaultRequestHeaders.TryAddWithoutValidation(Class185.smethod_0(537711332), Class13.smethod_0(string_0, string_1));
         return;
     }
     if (string_0.Contains(Class185.smethod_0(537700185)))
     {
         this.httpClient_0.DefaultRequestHeaders.TryAddWithoutValidation(Class185.smethod_0(537711332), Class13.smethod_1(string_0, string_1));
     }
 }
Esempio n. 13
0
 private void btnDecrypt_Click(object sender, EventArgs e)
 {
     this.txtDecrypted.Text = Class13.smethod_1(this.txtEncrypted1.Text.Trim(), this.txtPassword1.Text.Trim());
 }