Esempio n. 1
0
        private void memberLoadData(int pageNum)
        {
            dgvMember.Rows.Clear();
            DataGridViewRowCollection rows = dgvMember.Rows;
            RosterInfo vRoster             = new RosterInfo(APConfig.Conn);

            vRoster.Conditions = " 1=1 ";
            if (!string.IsNullOrEmpty(txtMemberName.Text))
            {
                vRoster.Conditions += " AND " + vRoster.getCondition(RosterInfo.ncConditions.name.ToString(), txtMemberName.Text);
            }
            if (!string.IsNullOrEmpty(txtMemberTel.Text))
            {
                vRoster.Conditions += " AND " + vRoster.getCondition(RosterInfo.ncConditions.phoneLike.ToString(), txtMemberTel.Text);
            }
            if (!string.IsNullOrEmpty(txtMemberAddr.Text))
            {
                vRoster.Conditions += " AND " + vRoster.getCondition(RosterInfo.ncConditions.address.ToString(), txtMemberAddr.Text);
            }
            if (!string.IsNullOrEmpty(dpkMemberInsertSDTTM.Value.ToString()) && ckbMemberInsertDTTM.Checked)
            {
                vRoster.Conditions += " AND " + vRoster.getCondition(RosterInfo.ncConditions.createSDTTM.ToString(), dpkMemberInsertSDTTM.Value.ToString("yyyy/MM/dd"));
            }
            if (!string.IsNullOrEmpty(dpkMemberInsertEDTTM.Value.ToString()) && ckbMemberInsertDTTM.Checked)
            {
                vRoster.Conditions += " AND " + vRoster.getCondition(RosterInfo.ncConditions.createEDTTM.ToString(), dpkMemberInsertEDTTM.Value.ToString("yyyy/MM/dd"));
            }
            if (!string.IsNullOrEmpty(dpkMemberModifySDTTM.Value.ToString()) && ckbMemberModifyDTTM.Checked)
            {
                vRoster.Conditions += " AND " + vRoster.getCondition(RosterInfo.ncConditions.modifySDTTM.ToString(), dpkMemberModifySDTTM.Value.ToString("yyyy/MM/dd"));
            }
            if (!string.IsNullOrEmpty(dpkMemberModifyEDTTM.Value.ToString()) && ckbMemberModifyDTTM.Checked)
            {
                vRoster.Conditions += " AND " + vRoster.getCondition(RosterInfo.ncConditions.modifyEDTTM.ToString(), dpkMemberModifyEDTTM.Value.ToString("yyyy/MM/dd"));
            }
            //組排序指令
            if (dgvMember.SortedColumn is null)
            {
                vRoster.OrderBy = vRoster.getOptionOrderBy(RosterInfo.ncSort.Default.ToString());
            }
            else
            {
                string sortname = dgvMember.SortedColumn.Name;
                string sortmode = APConfig.GetValueFromDescription <SortMode>(dgvMember.SortOrder.ToString()).ToString();
                vRoster.OrderBy = string.Format("{0} {1}", vRoster.getOptionOrderBy(sortname), sortmode);
            }
            //查詢頁數初始化且自動跳轉至第一頁
            if (pageNum == 0)
            {
                APConfig.loadPage(ddlMemberPage, vRoster.calculatePage(APConfig.PageCount));
                return;
            }
            //塞入資料
            lblMemberTotal.Text = vRoster.calculateCount().ToString();
            DataSet ds = APConfig.GoPage(vRoster.SQLStatement, pageNum);

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                rows.Add(new Object[] { dr.ItemArray[0], dr.ItemArray[1], dr.ItemArray[6], dr.ItemArray[4], dr.ItemArray[5], dr.ItemArray[8], dr.ItemArray[10], dr.ItemArray[13] });
            }
        }
Esempio n. 2
0
        private void inventoryLoadData(int pageNum)
        {
            int importTotal = 0, exportTotal = 0, itemTotal = 0, postTotal = 0, returnTotal = 0;

            dgvInventory.Rows.Clear();
            DataGridViewRowCollection rows = dgvInventory.Rows;
            InventroyRPTInfo          view = new InventroyRPTInfo(APConfig.Conn);

            view.Conditions = " 1=1 ";
            if (!string.IsNullOrEmpty(txtInventoryName.Text))
            {
                view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.name.ToString(), txtInventoryName.Text);
            }
            if (!string.IsNullOrEmpty(txtInventoryCode.Text))
            {
                view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.code.ToString(), txtInventoryCode.Text);
            }
            if (!string.IsNullOrEmpty(dpkInventoryINSDTTM.Value.ToString()) && ckbInventoryINDTTM.Checked)
            {
                view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.importSDTTM.ToString(), dpkInventoryINSDTTM.Value.ToString("yyyy/MM/dd"));
            }
            if (!string.IsNullOrEmpty(dpkInventoryINEDTTM.Value.ToString()) && ckbInventoryINDTTM.Checked)
            {
                view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.importEDTTM.ToString(), dpkInventoryINEDTTM.Value.ToString("yyyy/MM/dd"));
            }
            if (!string.IsNullOrEmpty(dpkInventoryOUTSDTTM.Value.ToString()) && ckbInventoryOUTDTTM.Checked)
            {
                view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.exportSDTTM.ToString(), dpkInventoryOUTSDTTM.Value.ToString("yyyy/MM/dd"));
            }
            if (!string.IsNullOrEmpty(dpkInventoryOUTEDTTM.Value.ToString()) && ckbInventoryOUTDTTM.Checked)
            {
                view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.exportEDTTM.ToString(), dpkInventoryOUTEDTTM.Value.ToString("yyyy/MM/dd"));
            }
            if (!string.IsNullOrEmpty(dpkInventoryPOSTSDTTM.Value.ToString()) && ckbInventoryPOSTDTTM.Checked)
            {
                view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.postSDTTM.ToString(), dpkInventoryPOSTSDTTM.Value.ToString("yyyy/MM/dd"));
            }
            if (!string.IsNullOrEmpty(dpkInventoryPOSTEDTTM.Value.ToString()) && ckbInventoryPOSTDTTM.Checked)
            {
                view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.postEDTTM.ToString(), dpkInventoryPOSTEDTTM.Value.ToString("yyyy/MM/dd"));
            }
            if (!string.IsNullOrEmpty(dpkInventoryRETURNSDTTM.Value.ToString()) && ckbInventoryRETURNDTTM.Checked)
            {
                view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.returnSDTTM.ToString(), dpkInventoryRETURNSDTTM.Value.ToString("yyyy/MM/dd"));
            }
            if (!string.IsNullOrEmpty(dpkInventoryRETURNEDTTM.Value.ToString()) && ckbInventoryRETURNDTTM.Checked)
            {
                view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.returnEDTTM.ToString(), dpkInventoryRETURNEDTTM.Value.ToString("yyyy/MM/dd"));
            }

            if (ddlInventoryDealer.SelectedIndex != 0)
            {
                view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.dealer.ToString(), ddlInventoryDealer.SelectedItem.ToString());
            }
            if (ddlInventoryStatus.SelectedIndex != 0)
            {
                view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.status.ToString(), ddlInventoryStatus.SelectedItem.ToString());
            }

            view.condFormat(string.Format(" AND {0} ", view.Conditions));



            //組排序指令
            if (dgvInventory.SortedColumn is null)
            {
                view.OrderBy = view.getOptionOrderBy(RosterDial_RInfo.ncSort.Default.ToString());
            }
            else
            {
                string sortname = dgvInventory.SortedColumn.Name;
                string sortmode = APConfig.GetValueFromDescription <SortMode>(dgvInventory.SortOrder.ToString()).ToString();
                view.OrderBy = string.Format("{0} {1}", view.getOptionOrderBy(sortname), sortmode);
            }
            //查詢頁數初始化且自動跳轉至第一頁
            if (pageNum == 0)
            {
                APConfig.loadPage(ddlInventoryPage, view.calculatePage(APConfig.PageCount));
                return;
            }
            //塞入資料
            DataSet ds = APConfig.GoPage(view.SQLStatement, pageNum);

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                rows.Add(new Object[] { dr.ItemArray[1], dr.ItemArray[0], dr.ItemArray[2], dr.ItemArray[3], dr.ItemArray[4], dr.ItemArray[5], dr.ItemArray[6] });
            }
            //計算總合
            if (view.load())
            {
                while (!view.IsEof)
                {
                    importTotal += view.INAMT;
                    exportTotal += view.OUTAMT;
                    postTotal   += view.POSTAMT;
                    returnTotal += view.RETURNAMT;
                    itemTotal   += Convert.ToInt32(view.ITEMTOTAL);
                    view.next();
                }
            }
            lblInventoryTotal.Text     = string.Format("{0}", itemTotal.ToString());
            lblInventoryINAMT.Text     = string.Format("{0:n0} 元", importTotal);
            lblInventoryOUTAMT.Text    = string.Format("{0:n0} 元", exportTotal);
            lblInventoryPOSTAMT.Text   = string.Format("{0:n0} 元", postTotal);
            lblInventoryRETURNAMT.Text = string.Format("{0:n0} 元", returnTotal);
        }
Esempio n. 3
0
        private void saleLoadData(int pageNum)
        {
            int total = 0;

            dgvSale.Rows.Clear();
            DataGridViewRowCollection rows = dgvSale.Rows;
            RosterDial_RInfo          view = new RosterDial_RInfo(APConfig.Conn);

            view.Conditions = " 1=1 ";
            if (!string.IsNullOrEmpty(txtSaleItem.Text))
            {
                view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.item.ToString(), txtSaleItem.Text);
            }
            if (!string.IsNullOrEmpty(txtSaleMain.Text))
            {
                view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.main.ToString(), txtSaleMain.Text);
            }
            if (!string.IsNullOrEmpty(txtSaleName.Text))
            {
                view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.name.ToString(), txtSaleName.Text);
            }
            if (!string.IsNullOrEmpty(txtSaleComment.Text))
            {
                view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.comment.ToString(), txtSaleComment.Text);
            }
            //if (!string.IsNullOrEmpty(dpkSaleInsertSDTTM.Value.ToString()) && ckbSaleInsertDTTM.Checked)
            //    view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.createSDTTM.ToString(), dpkSaleInsertSDTTM.Value.ToString("yyyy/MM/dd"));
            //if (!string.IsNullOrEmpty(dpkSaleInsertSDTTM.Value.ToString()) && ckbSaleInsertDTTM.Checked)
            //    view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.createEDTTM.ToString(), dpkSaleInsertSDTTM.Value.ToString("yyyy/MM/dd"));
            if (!string.IsNullOrEmpty(dpkSaleModifySDTTM.Value.ToString()) && ckbSaleModifyDTTM.Checked)
            {
                view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.modifySDTTM.ToString(), dpkSaleModifySDTTM.Value.ToString("yyyy/MM/dd"));
            }
            if (!string.IsNullOrEmpty(dpkSaleModifyEDTTM.Value.ToString()) && ckbSaleModifyDTTM.Checked)
            {
                view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.modifyEDTTM.ToString(), dpkSaleModifyEDTTM.Value.ToString("yyyy/MM/dd"));
            }
            if (!string.IsNullOrEmpty(dpkSaleDealSDTTM.Value.ToString()) && ckbSaleDealDTTM.Checked)
            {
                view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.dealSDTTM.ToString(), dpkSaleDealSDTTM.Value.ToString("yyyy/MM/dd"));
            }
            if (!string.IsNullOrEmpty(dpkSaleDealEDTTM.Value.ToString()) && ckbSaleDealDTTM.Checked)
            {
                view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.dealEDTTM.ToString(), dpkSaleDealEDTTM.Value.ToString("yyyy/MM/dd"));
            }
            if (ddlSaleDealer.SelectedIndex != 0)
            {
                view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.dealer.ToString(), ddlSaleDealer.SelectedItem.ToString());
            }
            if (ddlSaleStatus.SelectedIndex != 0)
            {
                view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.status.ToString(), ddlSaleStatus.SelectedItem.ToString());
            }
            if (ddlSaleType.SelectedIndex != 0)
            {
                if (ddlSaleType.SelectedItem.ToString() == "銷貨淨值") //Harsh Code
                {
                    view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.typelist.ToString(), " '銷貨收入','銷貨折扣'");
                }
                else
                {
                    view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.type.ToString(), ddlSaleType.SelectedItem.ToString());
                }
            }
            //組排序指令
            if (dgvSale.SortedColumn is null)
            {
                view.OrderBy = view.getOptionOrderBy(RosterDial_RInfo.ncSort.Default.ToString());
            }
            else
            {
                string sortname = dgvSale.SortedColumn.Name;
                string sortmode = APConfig.GetValueFromDescription <SortMode>(dgvSale.SortOrder.ToString()).ToString();
                view.OrderBy = string.Format("{0} {1}", view.getOptionOrderBy(sortname), sortmode);
            }
            //查詢頁數初始化且自動跳轉至第一頁
            if (pageNum == 0)
            {
                APConfig.loadPage(ddlSalePage, view.calculatePage(APConfig.PageCount));
                return;
            }
            //計算總合
            if (view.load())
            {
                while (!view.IsEof)
                {
                    total += int.Parse(view.RSD_AMOUNT);
                    view.next();
                }
            }
            //塞入資料
            DataSet ds = APConfig.GoPage(view.SQLStatement, pageNum);

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                rows.Add(new Object[] { dr.ItemArray[0], dr.ItemArray[14], dr.ItemArray[13], dr.ItemArray[1], dr.ItemArray[2], dr.ItemArray[3], dr.ItemArray[6], dr.ItemArray[4], dr.ItemArray[5], dr.ItemArray[7], dr.ItemArray[10] });
            }
            lblSaleTotal.Text       = view.calculateCount().ToString();
            lblSaleTotalAmount.Text = string.Format("{0:n0} 元", total);
        }