Exemple #1
0
 public static void sysprint()
 {
     if (reportdb != 1)
     {
         reportdb = 2;
     }
     //  SQLstr = Rsql;
     formreport.frmrpt frmrpt = new formreport.frmrpt();
     frmrpt.ShowDialog();
 }
Exemple #2
0
 public static void sysprint(string Rsql, string Rsql_sld)
 {
     if (reportdb != 1)
     {
         reportdb = 0;
     }
     SQLstr  = Rsql;
     SQLstr1 = Rsql_sld;
     formreport.frmrpt frmrpt = new formreport.frmrpt();
     frmrpt.ShowDialog();
 }
Exemple #3
0
        private void button1_Click(object sender, EventArgs e)
        {
            if (checkEmptyComp(pantax) == 0)
            {
                Static_class.reportdb = 2;
                Static_class.rptlbl5  = "الكــل";

                string frm = "", tom = "";

                switch (combTAX.SelectedIndex)
                {
                case 0:
                {
                    frm = "1"; tom = "12";
                } break;

                case 1:
                {
                    frm = "1"; tom = "3";
                } break;

                case 2:
                {
                    frm = "4"; tom = "6";
                } break;

                case 3:
                {
                    frm = "7"; tom = "9";
                } break;

                case 4:
                {
                    frm = "10"; tom = "12";
                } break;
                }


                string tblsql = "";

                string txt = "  جميع الشيكات مسددة باسم / الادارة العامة لتجميع نماذج الخصم و التحصيل تحت حساب الضريبة باسم / مأمورية ضرائب الشركات المساهمة شارع حسين حجازي- الفلكي-القاهرة  ";

                if (taxcd == "03")
                {
                    tblsql = @"SELECT    ' " + txt + @" '  as notes , dbo.tblMovment.prftcred as [credsum], supnm,  dbo.tblMovment.mov_date  as date, CASE WHEN MONTH(convert(datetime,dbo.tblMovment.mov_date,103)) < 4 THEN 'الأولــــى' WHEN MONTH(convert(datetime,dbo.tblMovment.mov_date,103)) < 7 THEN 'الثانية' WHEN MONTH(convert(datetime,dbo.tblMovment.mov_date,103)) 
                      < 10 THEN 'الثالثة' ELSE 'الرابعة' END AS period, dbo.taxkd.taxprc
FROM         dbo.tblMovment INNER JOIN
                      dbo.TBLsuppliers ON dbo.tblMovment.supcd = dbo.TBLsuppliers.supcd INNER JOIN
                      dbo.taxkd ON dbo.TBLsuppliers.taxcd = dbo.taxkd.taxcd  
                      WHERE   tblMovment.yr= " + txtyr.Text + @" AND MONTH(CONVERT(datetime, tblMovment.mov_date, 103))>=" + frm + @"  and MONTH(CONVERT(datetime, tblMovment.mov_date, 103))<=" + tom + @"  and tblMovment.supcd='" + txtsupcd.Text + "'  order by mov_date";
                }
                else
                {
                    tblsql = @"SELECT    ' " + txt + @" '  as notes , dbo.tblMovment.credsum, supnm,  dbo.tblMovment.mov_date  as date, CASE WHEN MONTH(convert(datetime,dbo.tblMovment.mov_date,103)) < 4 THEN 'الأولــــى' WHEN MONTH(convert(datetime,dbo.tblMovment.mov_date,103)) < 7 THEN 'الثانية' WHEN MONTH(convert(datetime,dbo.tblMovment.mov_date,103)) 
                      < 10 THEN 'الثالثة' ELSE 'الرابعة' END AS period, dbo.taxkd.taxprc
FROM         dbo.tblMovment INNER JOIN
                      dbo.TBLsuppliers ON dbo.tblMovment.supcd = dbo.TBLsuppliers.supcd INNER JOIN
                      dbo.taxkd ON dbo.TBLsuppliers.taxcd = dbo.taxkd.taxcd  
                      WHERE   tblMovment.yr= " + txtyr.Text + @" AND MONTH(CONVERT(datetime, tblMovment.mov_date, 103))>=" + frm + @"  and MONTH(CONVERT(datetime, tblMovment.mov_date, 103))<=" + tom + @"  and tblMovment.supcd='" + txtsupcd.Text + "'  order by mov_date";
                }

                SqlDataAdapter adreport = new SqlDataAdapter(tblsql, Static_class.con);
                DataTable      dt       = new DataTable();
                adreport.Fill(dt);

                dt.Columns.Add("checkNo", typeof(string));
                dt.Columns.Add("checkDate", typeof(DateTime));
                dt.Columns.Add("bank", typeof(string));


                SqlDataAdapter da_tblCheckNo = new SqlDataAdapter(@"SELECT  checkPeriod, checkNo, checkDate,bank
                FROM tblCheckNo  where yr=" + txtyr.Text, Static_class.con);

                DataTable dt_tblCheckNo = new DataTable();

                da_tblCheckNo.Fill(dt_tblCheckNo);
                dt_tblCheckNo.PrimaryKey = new DataColumn[1] {
                    dt_tblCheckNo.Columns["checkPeriod"]
                };
                if (dt_tblCheckNo.Rows.Count > 0)
                {
                    #region checkRegion
                    foreach (DataRow dr in dt.Rows)
                    {
                        string period = dr["period"].ToString();

                        switch (period)
                        {
                        case "الأولــــى":
                        {
                            dr["checkNo"]   = dt_tblCheckNo.Rows[dt_tblCheckNo.Rows.IndexOf(dt_tblCheckNo.Rows.Find(1))]["checkNo"];
                            dr["checkDate"] = dt_tblCheckNo.Rows[dt_tblCheckNo.Rows.IndexOf(dt_tblCheckNo.Rows.Find(1))]["checkDate"];
                            dr["bank"]      = dt_tblCheckNo.Rows[dt_tblCheckNo.Rows.IndexOf(dt_tblCheckNo.Rows.Find(1))]["bank"];
                        } break;

                        case "الثانية":
                        {
                            dr["checkNo"]   = dt_tblCheckNo.Rows[dt_tblCheckNo.Rows.IndexOf(dt_tblCheckNo.Rows.Find(2))]["checkNo"];
                            dr["checkDate"] = dt_tblCheckNo.Rows[dt_tblCheckNo.Rows.IndexOf(dt_tblCheckNo.Rows.Find(2))]["checkDate"];
                            dr["bank"]      = dt_tblCheckNo.Rows[dt_tblCheckNo.Rows.IndexOf(dt_tblCheckNo.Rows.Find(2))]["bank"];
                        } break;

                        case "الثالثة":
                        {
                            dr["checkNo"]   = dt_tblCheckNo.Rows[dt_tblCheckNo.Rows.IndexOf(dt_tblCheckNo.Rows.Find(3))]["checkNo"];
                            dr["checkDate"] = dt_tblCheckNo.Rows[dt_tblCheckNo.Rows.IndexOf(dt_tblCheckNo.Rows.Find(3))]["checkDate"];
                            dr["bank"]      = dt_tblCheckNo.Rows[dt_tblCheckNo.Rows.IndexOf(dt_tblCheckNo.Rows.Find(3))]["bank"];
                        } break;

                        case "الرابعة":
                        {
                            dr["checkNo"]   = dt_tblCheckNo.Rows[dt_tblCheckNo.Rows.IndexOf(dt_tblCheckNo.Rows.Find(4))]["checkNo"];
                            dr["checkDate"] = dt_tblCheckNo.Rows[dt_tblCheckNo.Rows.IndexOf(dt_tblCheckNo.Rows.Find(4))]["checkDate"];
                            dr["bank"]      = dt_tblCheckNo.Rows[dt_tblCheckNo.Rows.IndexOf(dt_tblCheckNo.Rows.Find(4))]["bank"];
                        } break;
                        }
                    }
                    #endregion
                }
                Static_class.reportDataSrc.Clear();
                Static_class.reportDataSrc = dt;
                Static_class.reportname    = "taxdecl";


                formreport.frmrpt frmrpt = new formreport.frmrpt();
                frmrpt.ShowDialog();
            }
        }