示例#1
0
        private void toolStripLabelPrint_Click(object sender, EventArgs e)
        {
            string ProductionCheckId = dataGridView1.SelectedRows[0].Cells["ProductionCheckId"].Value.ToString();
            string ProductionWaitId = dataGridView1.SelectedRows[0].Cells["ProductionWaitId"].Value.ToString();

            if (Convert.ToDouble(CountProduct(ProductionWaitId)) < 1)
            {
                if (dataGridView1.RowCount <= 0) return;
                if (dataGridView1.SelectedRows.Count <= 0) return;

                StringBuilder sql = new StringBuilder();
                sql.Append("SELECT pwh.ProductionWaitId,e.EmployerName, s.ShipperName, pwh.ProductionWaitDate, pf.FmName, pc.ProductionCateName, pwd.ProductionWaitPallet, pwd.ProductionWaitDetailQuantity,pf.FmId ");
                sql.Append("FROM dbo.ProductionWaitDetail AS pwd INNER JOIN " +
                             "dbo.ProductionWaitHead AS pwh ON pwd.ProductionWaitId = pwh.ProductionWaitId INNER JOIN " +
                             "dbo.EMPLOYER AS e ON pwh.EmployerId = e.EmployerId INNER JOIN " +
                             "dbo.SHIPPER AS s ON pwh.ShipperId = s.ShipperId INNER JOIN " +
                             "dbo.ProductionFormular AS pf ON pwd.FmId = pf.FmId INNER JOIN " +
                             "dbo.ProductionCate AS pc ON pf.ProductionCateId = pc.ProductionCateId ");
                sql.Append("WHERE pwh.ProductionWaitId = '" + ProductionWaitId + "' ");//ดึงรายการสินค้ารอตรวจ

                DataTable data = Class.DBConnString.clsDB.QueryDataTable(sql.ToString());
                data.TableName = "ReceiveNetFromJ";

                Report.Production.CtrReceiveNetFromJm r = new Report.Production.CtrReceiveNetFromJm();//เรียกหน้าออกรายงาน
                r.SetDataSource(data);

                ProductionNew.RptProductionReq ctr = new RptProductionReq(r);//เรียกหน้าออกรายงาน
                ctr.StartPosition = FormStartPosition.CenterScreen;
                ctr.ShowDialog();
            }
            else
            {
                if (dataGridView1.RowCount <= 0) return;
                if (dataGridView1.SelectedRows.Count <= 0) return;

                StringBuilder sql = new StringBuilder();
                sql.Append("select c.ProductionWaitId,e.EmployerName,sh.ShipperName,convert(varchar, DATEADD(YEAR,543,wh.ProductionWaitDate),103) ProductionWaitDate,w.ProductionCheckId,w.ProductId FmId,w.ProductId ProductionCateName,p.ProductName FmName,");
                sql.Append("sum(w.Quantity) ProductionWaitDetailQuantity,u.UnitSaleName,pcs.productioncheckstatusname " +
                             "from ProductionCheckWell w inner join product p on w.productid = p.productid " +
                             "inner join unitsale u on p.unitsaleid = u.unitsaleid " +
                             "inner join productioncheckstatus pcs on w.productioncheckstatusid = pcs.productioncheckstatusid " +
                             "inner join ProductionCheck c on c.ProductionCheckId=w.ProductionCheckId " +
                             "inner join ProductionWaitHead wh on wh.ProductionWaitId=c.ProductionWaitId " +
                             "inner join EMPLOYER e on e.EmployerId=wh.EmployerId " +
                             "inner join SHIPPER sh ON sh.ShipperId=wh.ShipperId " +
                             "where w.ProductionCheckId='" + ProductionCheckId + "' " +
                             "group by c.ProductionWaitId,e.EmployerName,sh.ShipperName,wh.ProductionWaitDate,u.UnitSaleName,pcs.productioncheckstatusname," +
                             "w.ProductionCheckId,w.ProductId,p.ProductName ");

                DataTable data = Class.DBConnString.clsDB.QueryDataTable(sql.ToString());
                data.TableName = "ReceiveNetFromJ";

                Report.Production.CtrReceiveNetFromProduct r = new Report.Production.CtrReceiveNetFromProduct();//เรียกหน้าออกรายงาน
                r.SetDataSource(data);

                ProductionNew.RptProductionReq ctr = new RptProductionReq(r);//เรียกหน้าออกรายงาน
                ctr.StartPosition = FormStartPosition.CenterScreen;
                ctr.ShowDialog();
            }
        }
示例#2
0
        private void รายงานหมายเลข7ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            string sqlhead = "select ph.pmwheadid,CONVERT(VARCHAR(10),DATEADD(YEAR,543,ph.pmwheaddate),103) as pmwheaddate,e.employername,a.Accountnoprison,a.Accountnameprison,b.bankbranchname AS bankbranchnameprison \n" +
                                "from ProductionMakingNetsWage_Head ph                                                                           \n" +
                                "inner join employer e on e.employerid = ph.employerid                                                           \n" +
                                "left join AccountPrison a on a.employerid = ph.employerid                                                       \n" +
                                "left join BankBranch b on b.bankbranchid = a.bankbranchid                                                       \n" +
                                "where ph.pmwheadid = '" + DgvHead.SelectedRows[0].Cells[0].Value.ToString() + "'";
            DataTable DtHead = Class.DBConnString.clsDB.QueryDataTable(sqlhead);

            string sqldetail = "select t.typeplusdelname,pd.fmid,f.fmname,pd.pmwdetailquantityn7,pd.pmwdetailquantityoutside,                         \n" +
                            "pd.pwn7,pd.pwoutside,pmwdetailsumn7,pmwdetailsumoutside,pmwdetailsumn7+pmwdetailsumoutside AS TotalSum                   \n" +
                            "from ProductionMakingNetsWage_Detail pd                                                                                  \n" +
                            "inner join ProductionFormular f on pd.fmid = f.fmid                                                                      \n" +
                            "inner join ProductionMakingNetsWage_TypeNet t on pd.typeplusdel = t.typeplusdel                                          \n" +
                            "where pd.pmwheadid = '" + DgvHead.SelectedRows[0].Cells[0].Value.ToString() + "' and pd.typeplusdel = 1 and pd.pmwdetailquantityn7 <> 0";

            DataTable Dt = Class.DBConnString.clsDB.QueryDataTable(sqldetail);

            System.Data.DataSet ds = new System.Data.DataSet();
            DtHead.TableName = "MakingNetsHead";
            Dt.TableName = "MakingNetsDetail";

            ds.Tables.Add(DtHead);
            ds.Tables.Add(Dt);

            Report.Production.CtrMakingNetsReportN7 j = new Report.Production.CtrMakingNetsReportN7();
            j.SetDataSource(ds);
            j.SetParameterValue("Company", "บจก. เคทีซี เน็ตติ้ง");

            RptProductionReq CtrV = new RptProductionReq(j);
            CtrV.StartPosition = FormStartPosition.CenterParent;
            CtrV.ShowDialog();
        }
        private void toolStripLabelPrint_Click(object sender, EventArgs e)
        {
            if (DgvHead.Rows.Count <= 0) return;
            if (DgvHead.SelectedRows.Count != 1) return;

            string TransferMoneyNo = DgvHead.SelectedRows[0].Cells["TransferMoneyNo"].Value.ToString();

            string sql = "SELECT *                                                                                       \n" +
                        "FROM ProductionTransferMoneyHead pth                                                            \n" +
                        "INNER JOIN ProductionTransferMoneyDetail ptd ON pth.TransferMoneyNo = ptd.TransferMoneyNo       \n" +
                        "INNER JOIN EMPLOYER e ON pth.EmployerId = e.EmployerId                                          \n" +
                        "INNER JOIN ProductionPrisonWage ppw ON ptd.PwId = ppw.PwId                                      \n" +
                        "INNER JOIN UserLogin u ON pth.UserName = u.UserName where pth.TransferMoneyNo = '" + TransferMoneyNo + "'";

            DataTable data = Class.DBConnString.clsDB.QueryDataTable(sql);
            data.TableName = "TransferMoneyToJ";

            Report.Production.CtrTransferMoneyJ j = new Report.Production.CtrTransferMoneyJ();
            j.SetDataSource(data);
            j.SetParameterValue("Company", Class.DBConnString.sDb);

            RptProductionReq CtrV = new RptProductionReq(j);
            CtrV.StartPosition = FormStartPosition.CenterParent;
            CtrV.ShowDialog();
        }
示例#4
0
        private void รายงานภายนอกToolStripMenuItem_Click(object sender, EventArgs e)
        {
            string sqlhead = "select ph.pmwheadid,CONVERT(VARCHAR(10),DATEADD(YEAR,543,ph.pmwheaddate),103) as pmwheaddate,e.employername,               \n" +
                             "ph.PmwHeadCountPB,ph.PmwHeadPwPB,ph.PmwHeadPB,ph.PmwHeadCountTranspot,ph.PmwHeadPwTranspot,ph.PmwHeadTranspot,ph.PmwHeadShip, \n" +
                             "ph.PmwHeadSumN7,ph.PmwHeadSumOutSide,ph.PmwHeadSumN7Out,ph.PmwNote,a.Accountnoprison,a.Accountnameprison,o.BookNo,o.BookName,b.bankbranchname,br.bankbranchname AS bankbranchnameprison  \n" +
                             "from ProductionMakingNetsWage_Head ph                                                                                      \n" +
                             "inner join employer e on e.employerid = ph.employerid                                                                      \n" +
                             "left join AccountPrison a on a.employerid = ph.employerid                                                                  \n" +
                             "left join OWNACCOUNT o on o.BookNo = ph.PmwAccount                                                                         \n" +
                             "left join BankBranch b on b.bankbranchid = a.bankbranchid                                                                  \n" +
                             "left join BankBranch br on br.bankbranchid = o.bankbranchid                                                                \n" +
                             "where ph.pmwheadid = '" + DgvHead.SelectedRows[0].Cells[0].Value.ToString() + "'";
            DataTable DtHead = Class.DBConnString.clsDB.QueryDataTable(sqlhead);

            string sqldetail = "select t.typeplusdelname,pd.fmid,f.fmname,pd.pmwdetailquantityn7,pd.pmwdetailquantityoutside,                         \n" +
                            "pd.pwn7,pd.pwoutside,pmwdetailsumn7,pmwdetailsumoutside,pmwdetailsumn7+pmwdetailsumoutside AS TotalSum,                  \n" +
                            "case when pd.typeplusdel in (2,3) then 'บวก' when pd.typeplusdel in (4,5) then 'หัก' else '' end AS Type                  \n" +
                            "from ProductionMakingNetsWage_Detail pd                                                                                  \n" +
                            "inner join ProductionFormular f on pd.fmid = f.fmid                                                                      \n" +
                            "inner join ProductionMakingNetsWage_TypeNet t on pd.typeplusdel = t.typeplusdel                                          \n" +
                            "where pd.pmwheadid = '" + DgvHead.SelectedRows[0].Cells[0].Value.ToString() + "' and t.typeplusdel <> 1";

            DataTable Dt = Class.DBConnString.clsDB.QueryDataTable(sqldetail);

            string sqldetailsub = "select t.typeplusdelname,pd.fmid,f.fmname,pd.pmwdetailquantityn7,pd.pmwdetailquantityoutside,                      \n" +
                            "pd.pwn7,pd.pwoutside,pmwdetailsumn7,pmwdetailsumoutside,pmwdetailsumn7+pmwdetailsumoutside AS TotalSum,                  \n" +
                            "case when pd.typeplusdel in (2,3) then 'บวก' when pd.typeplusdel in (4,5) then 'หัก' else '' end AS Type                  \n" +
                            "from ProductionMakingNetsWage_Detail pd                                                                                  \n" +
                            "left join ProductionFormular f on pd.fmid = f.fmid                                                                       \n" +
                            "inner join ProductionMakingNetsWage_TypeNet t on pd.typeplusdel = t.typeplusdel                                          \n" +
                            "where pd.pmwheadid = '" + DgvHead.SelectedRows[0].Cells[0].Value.ToString() + "' and t.typeplusdel = 1";

            DataTable DtSub = Class.DBConnString.clsDB.QueryDataTable(sqldetailsub);

            System.Data.DataSet ds = new System.Data.DataSet();
            DtHead.TableName = "MakingNetsHead";
            Dt.TableName = "MakingNetsDetail";
            DtSub.TableName = "MakingNetsDetailSub";

            ds.Tables.Add(DtHead);
            ds.Tables.Add(Dt);
            ds.Tables.Add(DtSub);

            Report.Production.CtrMakingNetsReportOutSide j = new Report.Production.CtrMakingNetsReportOutSide();
            j.SetDataSource(ds);
            j.SetParameterValue("Company", Class.DBConnString.sDb);

            RptProductionReq CtrV = new RptProductionReq(j);
            CtrV.StartPosition = FormStartPosition.CenterParent;
            CtrV.ShowDialog();
        }
示例#5
0
        private void บตรแขงToolStripMenuItem_Click(object sender, EventArgs e)
        {
            string sql = "select ph.pmwheadid,e.employername,CONVERT(VARCHAR(10),DATEADD(YEAR,543,ph.pmwheaddate),103) as pmwheaddate,                        \n" +
                        "CONVERT(VARCHAR(10),DATEADD(YEAR,543,pc.pmwcarddate),103) as pmwcarddate,f.fmid,f.fmname,pc.pmwcardquantity,pct.Pmwcardstatusname    \n" +
                        "from ProductionMakingNetsWage_Card pc                                                                                                \n" +
                        "inner join ProductionMakingNetsWage_Detail pd on pd.Pmwdetailid = pc.Pmwdetailid                                                     \n" +
                        "inner join ProductionMakingNetsWage_Head ph on ph.Pmwheadid = pd.Pmwheadid                                                           \n" +
                        "inner join ProductionMakingNetsWage_StatusCard pct on pc.Pmwcardstatus = pct.Pmwcardstatus                                           \n" +
                        "inner join Employer e on e.Employerid = ph.Employerid                                                                                \n" +
                        "inner join ProductionFormular f on pd.fmid = f.fmid                                                                                  \n" +
                        "where ph.Pmwheadid = '" + DgvHead.SelectedRows[0].Cells[0].Value.ToString() + "'";

            DataTable Dt = Class.DBConnString.clsDB.QueryDataTable(sql);

            System.Data.DataSet ds = new System.Data.DataSet();
            Dt.TableName = "MakingNetsCard";

            ds.Tables.Add(Dt);

            Report.Production.CtrMakingNetsReportCard j = new Report.Production.CtrMakingNetsReportCard();
            j.SetDataSource(ds);
            j.SetParameterValue("Company", Class.DBConnString.sDb);

            RptProductionReq CtrV = new RptProductionReq(j);
            CtrV.StartPosition = FormStartPosition.CenterParent;
            CtrV.ShowDialog();
        }
示例#6
0
        private void toolStripButton3_Click(object sender, EventArgs e)
        {
            string sqlhead = "SELECT CONVERT(VARCHAR(10),DATEADD(YEAR,543,ph.PrmHeadNetDateOld),103) AS PrmHeadNetDateOld,CONVERT(VARCHAR(10),DATEADD(YEAR,543,ph.PrmHeadNetDate),103) AS PrmHeadNetDate,   \n" +
                            "ph.PrmHeadNetNumOld,ph.PrmHeadSumProduction,ph.PrmHeadNetNum,ph.PrmHeadNetSumTotal,ph.PrmHeadNetFailOldPrison,ph.PrmHeadNetFailOldCompany,ph.PrmHeadNetFailPrison,             \n" +
                            "ph.PrmHeadNetFailCompany,ph.PrmHeadCatePrison,ph.PrmHeadCateCompany,ph.PrmHeadSumFailPrison,ph.PrmHeadSumFailCompany,ph.PrmHeadSumReceive,                                     \n" +
                            "CONVERT(VARCHAR(10),DATEADD(YEAR,543,ph.TransferMoneyDate),103) AS TransferMoneyDate,ph.TransferMoneyNo,ph.TransferCount,ph.PrmHeadid,                                         \n" +
                            "CONVERT(VARCHAR(10),DATEADD(YEAR,543,ph.PrmHeadNetDate),103) AS PrmHeadDate,e.EmployerName                                                                                     \n" +
                            "FROM ProductionReportMonth_Head ph INNER JOIN Employer e ON ph.Employerid = e.Employerid WHERE PrmHeadId = '" + DgvHead.SelectedRows[0].Cells[0].Value.ToString() + "'";

            DataTable DtHead = Class.DBConnString.clsDB.QueryDataTable(sqlhead);

            string sqldetail = "SELECT CONVERT(VARCHAR(10),DATEADD(YEAR,543,pd.ProductionWaitDate),103) AS ProductionWaitDate,                                                     \n" +
                            "pd.ProductionWaitId,pd.FmName,pd.ProductionWaitHand,c.ProductionCateName,pdnc.PCateName,pd.Quantity,pd.NetWell,pd.NetFailPrison,pd.NetFailCompany,    \n" +
                            "CAST(CAST(((pd.NetFailPrison + pd.NetFailCompany) * 100) AS DECIMAL(10,2)) / CAST(pd.NetNum AS DECIMAL(10,2)) AS DECIMAL(10,2)) AS [Percent],         \n" +
                            "pd.NetNum,pd.NetLost,pd.PrmDetailTotalPay,pd.PrmDetailTotalUnPay                                                                                      \n" +
                            "FROM ProductionReportMonth_Detail pd                                                                                                                  \n" +
                            "INNER JOIN Productioncate c ON c.ProductionCateId = pd.ProductionCateId                                                                               \n" +
                            "INNER JOIN productionnetcate pdnc ON pdnc.PCateId = pd.PCateId                                                                                        \n" +
                            "WHERE pd.PrmHeadId = '" + DgvHead.SelectedRows[0].Cells[0].Value.ToString() + "'";

            DataTable Dt = Class.DBConnString.clsDB.QueryDataTable(sqldetail);

            System.Data.DataSet ds = new System.Data.DataSet();
            DtHead.TableName = "ReportMonthHead";
            Dt.TableName = "ReportMonthDetail";

            ds.Tables.Add(DtHead);
            ds.Tables.Add(Dt);

            Report.Production.CtrProductionReportMonth j = new Report.Production.CtrProductionReportMonth();
            j.SetDataSource(ds);
            j.SetParameterValue("Company", Class.DBConnString.sDb);

            RptProductionReq CtrV = new RptProductionReq(j);
            CtrV.StartPosition = FormStartPosition.CenterParent;
            CtrV.ShowDialog();
        }
        /*ดึงข้อมูลออกรายงานในส่งซ่อม*/
        private void toolStripLabelPrint_Click(object sender, EventArgs e)
        {
            if (dataGridView1.Rows.Count <= 0) return;
            if (dataGridView1.SelectedRows.Count <= 0) return;

            string ProductionRepairHeadId = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();//เก็บเลขที่ใบซ่อม

            StringBuilder sql = new StringBuilder();
            sql.Append("SELECT prh.ProductionRepairHeadDate, e.EmployerName, pcate.ProductionCateName, pf.FmName, pnf.NetFName, prd.Quantity, pc.ProductionWaitId, pf.FmId, prh.ProductionRepairHeadId, pwh.ProductionWaitDate ");
            sql.Append("FROM dbo.ProductionRepairDetail AS prd INNER JOIN " +
                         "dbo.ProductionRepairHead AS prh ON prd.ProductionRepairHeadId = prh.ProductionRepairHeadId INNER JOIN " +
                         "dbo.ProductionCheckFail AS pcf ON prd.ProductionCheckFailId = pcf.ProductionCheckFailId INNER JOIN " +
                         "dbo.ProductionNettingFail AS pnf ON pcf.NetFId = pnf.NetFId INNER JOIN " +
                         "dbo.ProductionCheck AS pc ON pcf.ProductionCheckId = pc.ProductionCheckId INNER JOIN " +
                         "dbo.ProductionFormular AS pf ON prd.FmId = pf.FmId INNER JOIN " +
                         "dbo.ProductionCate AS pcate ON pf.ProductionCateId = pcate.ProductionCateId INNER JOIN " +
                         "dbo.EMPLOYER AS e ON prh.EmployerId = e.EmployerId  INNER JOIN " +
                         "dbo.ProductionWaitHead AS pwh ON pc.ProductionWaitId = pwh.ProductionWaitId ");
            sql.Append("WHERE prh.ProductionRepairHeadId = '" + ProductionRepairHeadId + "' ");

            DataTable data = Class.DBConnString.clsDB.QueryDataTable(sql.ToString());
            data.TableName = "SendNetFailur";

            Report.Production.CtrSendNetRepair r = new Report.Production.CtrSendNetRepair();
            r.SetDataSource(data);

            ProductionNew.RptProductionReq ctr = new RptProductionReq(r);
            ctr.StartPosition = FormStartPosition.CenterScreen;
            ctr.ShowDialog();
        }
示例#8
0
        private void showReport(string strTranfNo)
        {
            string sql = "SELECT *                                                                                       \n" +
                        "FROM ProductionTransferMoneyHead pth                                                            \n" +
                        "INNER JOIN ProductionTransferMoneyDetail ptd ON pth.TransferMoneyNo = ptd.TransferMoneyNo       \n" +
                        "INNER JOIN EMPLOYER e ON pth.EmployerId = e.EmployerId                                          \n" +
                        "INNER JOIN ProductionPrisonWage ppw ON ptd.PwId = ppw.PwId                                      \n" +
                        "INNER JOIN UserLogin u ON pth.UserName = u.UserName where pth.TransferMoneyNo = '" + strTranfNo + "'";

            DataTable data = Class.DBConnString.clsDB.QueryDataTable(sql);
            data.TableName = "TransferMoneyToJ";

            Report.Production.CtrTransferMoneyJ j = new Report.Production.CtrTransferMoneyJ();
            j.SetDataSource(data);
            j.SetParameterValue("Company", DBConnString.sDb);

            RptProductionReq CtrV = new RptProductionReq(j);
            CtrV.StartPosition = FormStartPosition.CenterParent;
            CtrV.ShowDialog();
        }