コード例 #1
0
        public void Insert(string CompanyName, string PhoneNumber, string LicenseCode, string Address, string SubCompanyNumber, string SubCompanyName, string Postalcode, string ShopHours, string StartTicketNumber, string SetupDate)
        {
            DDCompanyInfo item = new DDCompanyInfo();

            item.CompanyName = CompanyName;

            item.PhoneNumber = PhoneNumber;

            item.LicenseCode = LicenseCode;

            item.Address = Address;

            item.SubCompanyNumber = SubCompanyNumber;

            item.SubCompanyName = SubCompanyName;

            item.Postalcode = Postalcode;

            item.ShopHours = ShopHours;

            item.StartTicketNumber = StartTicketNumber;

            item.SetupDate = SetupDate;


            item.Save(UserName);
        }
コード例 #2
0
        public void Update(int CompanyID, string CompanyName, string PhoneNumber, string LicenseCode, string Address, string SubCompanyNumber, string SubCompanyName, string Postalcode, string ShopHours, string StartTicketNumber, string SetupDate)
        {
            DDCompanyInfo item = new DDCompanyInfo();

            item.MarkOld();
            item.IsLoaded = true;

            item.CompanyID = CompanyID;

            item.CompanyName = CompanyName;

            item.PhoneNumber = PhoneNumber;

            item.LicenseCode = LicenseCode;

            item.Address = Address;

            item.SubCompanyNumber = SubCompanyNumber;

            item.SubCompanyName = SubCompanyName;

            item.Postalcode = Postalcode;

            item.ShopHours = ShopHours;

            item.StartTicketNumber = StartTicketNumber;

            item.SetupDate = SetupDate;

            item.Save(UserName);
        }
コード例 #3
0
ファイル: ViewPawnTicketForm.cs プロジェクト: demonzhq/Mine
        private void LoadCompanyInfo(int intCompanyID)
        {
            DDCompanyInfo company = new DDCompanyInfo("CompanyID", intCompanyID);

            this.tbxCompanyName.Text  = company.CompanyName;
            this.tbxCompanyPhone.Text = company.PhoneNumber;
            this.tbxCompanyAdd.Text   = company.Address;
            this.tbxLicenseCode.Text  = company.LicenseCode;
        }
コード例 #4
0
        public MainForm()
        {
            InitializeComponent();
            InitializeOutlookbar();

            //CreatePawnForm frmCreatePawn = new CreatePawnForm();
            //frmCreatePawn.Show(this.dockPanel1);
            //pCurrentWin = this;


            //读取精度和计费模式
            DDCompanyInfo newCompanyInfo = new DDCompanyInfo("CompanyID", 0);

            AmountAccuracy = Convert.ToInt32(newCompanyInfo.AmountAccuracy);
            CountDayMode   = newCompanyInfo.CountDayMode;

            skinh = new SkinH_Net();
            skinh.Attach();
        }
コード例 #5
0
        private void LoadCompanyInfo()
        {
            DDCompanyInfo      company  = new DDCompanyInfo("CompanyID", 1);
            DDGeneralParemeter newParem = new DDGeneralParemeter("ParamName", "CurrentTicketNumber");

            this.tbxCompanyName.Text             = company.CompanyName;
            this.tbxLicenseCode.Text             = company.LicenseCode;
            this.tbxSubCompanyNumber.Text        = company.SubCompanyNumber;
            this.tbxSubCompanyName.Text          = company.SubCompanyName;
            this.tbxCompanyAdd.Text              = company.Address;
            this.tbxCompanyPhone.Text            = company.PhoneNumber;
            this.tbxPostalCode.Text              = company.Postalcode;
            this.tbxShopHours.Text               = company.ShopHours;
            this.tbxSetupDate.Text               = company.SetupDate;
            this.tbxStartTicketNumber.Text       = company.StartTicketNumber;
            this.cbxAmountAccuracy.SelectedIndex = Convert.ToInt32(company.AmountAccuracy);
            this.cbxCountDayMode.SelectedIndex   = Convert.ToInt32(company.CountDayMode);
            this.tbxTicketNumber.Text            = newParem.ParamValue;
        }
コード例 #6
0
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            DDCompanyInfo      company  = new DDCompanyInfo("CompanyID", 1);
            DDGeneralParemeter newParem = new DDGeneralParemeter("ParamName", "CurrentTicketNumber");

            company.CompanyName       = this.tbxCompanyName.Text;
            company.LicenseCode       = this.tbxLicenseCode.Text;
            company.SubCompanyNumber  = this.tbxSubCompanyNumber.Text;
            company.SubCompanyName    = this.tbxSubCompanyName.Text;
            company.Address           = this.tbxCompanyAdd.Text;
            company.PhoneNumber       = this.tbxCompanyPhone.Text;
            company.Postalcode        = this.tbxPostalCode.Text;
            company.ShopHours         = this.tbxShopHours.Text;
            company.SetupDate         = this.tbxSetupDate.Text;
            company.StartTicketNumber = this.tbxStartTicketNumber.Text;
            company.AmountAccuracy    = this.cbxAmountAccuracy.SelectedIndex.ToString();
            newParem.ParamValue       = this.tbxTicketNumber.Text;
            company.CountDayMode      = this.cbxCountDayMode.SelectedIndex;
            MainForm.AmountAccuracy   = this.cbxAmountAccuracy.SelectedIndex;
            MainForm.CountDayMode     = this.cbxCountDayMode.SelectedIndex;
            company.Save();
            newParem.Save();
            MessageBox.Show("典当行信息更新成功!");
        }
コード例 #7
0
 public bool Destroy(object CompanyID)
 {
     return(DDCompanyInfo.Destroy(CompanyID) == 1);
 }
コード例 #8
0
 public bool Delete(object CompanyID)
 {
     return(DDCompanyInfo.Delete(CompanyID) == 1);
 }
コード例 #9
0
        private void LoadTemplate(RenewPawnOperationForm frmRenewPawnOperation, int iTicketID)
        {
            MSExcel.Application excelApp;              //Excel应用程序变量
            MSExcel.Workbook    excelDoc;              //Excel文档变量
            excelApp = new MSExcel.ApplicationClass(); //初始化
            //由于使用的是COM库,因此有许多变量需要用Nothing代替
            Object Nothing = Missing.Value;

            excelDoc = excelApp.Workbooks._Open(Application.StartupPath + @"\Pram\RenewTemplate.dd", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

            //使用第一个工作表作为插入数据的工作表
            MSExcel.Worksheet ws = (MSExcel.Worksheet)excelDoc.Sheets[1];

            //声明一个MSExcel.Range 类型的变量r
            MSExcel.Range r;

            DDCompanyInfo company = new DDCompanyInfo("CompanyID", 1);

            //this.lblCompanyName.Text = company.CompanyName;
            //this.lblOldTicketNumber.Text = frmRenewPawnOperation.lblOldTicketNum.Text;
            r = ws.get_Range(("F" + 4), ("F" + 4)); r.Value2 = company.CompanyName;
            r = ws.get_Range(("M" + 4), ("M" + 4)); r.Value2 = frmRenewPawnOperation.lblOldTicketNum.Text;

            m_TicketID = iTicketID;
            DDPawnTicket   newTicket   = new DDPawnTicket("TicketID", iTicketID);
            DDCustomerInfo newCustomer = new DDCustomerInfo("CustomerID", newTicket.CustomerID);

            //this.lblCustomerName.Text = newCustomer.CustomerName;
            //this.lblContactPerson.Text = newCustomer.ContactPerson;
            r = ws.get_Range(("F" + 5), ("F" + 5)); r.Value2 = newCustomer.CustomerName;
            r = ws.get_Range(("M" + 5), ("M" + 5)); r.Value2 = newCustomer.ContactPerson;

            //this.lblAmount.Text = frmRenewPawnOperation.tbxTotalAmount.Text;
            //this.lblAmountChinese.Text = newChinese.toChineseChar(Convert.ToDecimal(frmRenewPawnOperation.tbxTotalAmount.Text));
            //this.lblServiceFee.Text = frmRenewPawnOperation.tbxServiceFee.Text;
            //this.lblServiceFeeChinese.Text = newChinese.toChineseChar(Convert.ToDecimal(frmRenewPawnOperation.tbxServiceFee.Text));
            //this.lblPaidInterestFee.Text = frmRenewPawnOperation.lblPaidInterest.Text;
            //this.lblPaidInterestFeeChinese.Text = newChinese.toChineseChar(Convert.ToDecimal(frmRenewPawnOperation.lblPaidInterest.Text));
            r = ws.get_Range(("M" + 6), ("M" + 6)); r.Value2 = Convert.ToDouble(frmRenewPawnOperation.tbxTotalAmount.Text).ToString("0.00");
            r = ws.get_Range(("H" + 6), ("H" + 6)); r.Value2 = newChinese.toChineseChar(Convert.ToDecimal(frmRenewPawnOperation.tbxTotalAmount.Text));
            r = ws.get_Range(("M" + 7), ("M" + 7)); r.Value2 = Convert.ToDouble(frmRenewPawnOperation.tbxServiceFee.Text).ToString("0.00");
            r = ws.get_Range(("H" + 7), ("H" + 7)); r.Value2 = newChinese.toChineseChar(Convert.ToDecimal(frmRenewPawnOperation.tbxServiceFee.Text));
            r = ws.get_Range(("M" + 8), ("M" + 8)); r.Value2 = Convert.ToDouble(frmRenewPawnOperation.tbxLastInterestFee.Text).ToString("0.00");
            r = ws.get_Range(("H" + 8), ("H" + 8)); r.Value2 = newChinese.toChineseChar(Convert.ToDecimal(frmRenewPawnOperation.tbxLastInterestFee.Text));

            double totalPaidFee = Convert.ToDouble(frmRenewPawnOperation.tbxServiceFee.Text) + Convert.ToDouble(frmRenewPawnOperation.tbxLastInterestFee.Text);

            //this.lblPaidFee.Text = totalPaidFee.ToString();
            //this.lblPaidFeeChinese.Text = newChinese.toChineseChar(Convert.ToDecimal(totalPaidFee));
            r = ws.get_Range(("H" + 9), ("H" + 9)); r.Value2 = newChinese.toChineseChar(Convert.ToDecimal(totalPaidFee));
            r = ws.get_Range(("M" + 9), ("M" + 9)); r.Value2 = totalPaidFee.ToString("0.00");

            DateTime startDate     = Convert.ToDateTime(frmRenewPawnOperation.tbxStartDate.Text);
            DateTime endDate       = Convert.ToDateTime(frmRenewPawnOperation.tbxEndDate.Text);
            DateTime operationDate = Convert.ToDateTime(frmRenewPawnOperation.tbxOperationDate.Text);

            //this.lblStartYear.Text = startDate.Year.ToString();
            //this.lblStartMonth.Text = startDate.Month.ToString();
            //this.lblStartDay.Text = startDate.Day.ToString();
            //this.lblEndYear.Text = endDate.Year.ToString();
            //this.lblEndMonth.Text = endDate.Month.ToString();
            //this.lblEndDay.Text = endDate.Day.ToString();
            //this.lblOperationYear.Text = operationDate.Year.ToString();
            //this.lblOperationMonth.Text = operationDate.Month.ToString();
            //this.lblOperationDay.Text = operationDate.Day.ToString();
            r = ws.get_Range(("F" + 10), ("F" + 10)); r.Value2 = startDate.Year.ToString();
            r = ws.get_Range(("I" + 10), ("I" + 10)); r.Value2 = startDate.Month.ToString();
            r = ws.get_Range(("J" + 10), ("J" + 10)); r.Value2 = startDate.Day.ToString();
            r = ws.get_Range(("K" + 10), ("K" + 10)); r.Value2 = endDate.Year.ToString();
            r = ws.get_Range(("L" + 10), ("L" + 10)); r.Value2 = endDate.Month.ToString();
            r = ws.get_Range(("M" + 10), ("M" + 10)); r.Value2 = endDate.Day.ToString();
            r = ws.get_Range(("M" + 13), ("M" + 13)); r.Value2 = operationDate.Year.ToString();
            r = ws.get_Range(("O" + 13), ("O" + 13)); r.Value2 = operationDate.Month.ToString();
            r = ws.get_Range(("Q" + 13), ("Q" + 13)); r.Value2 = operationDate.Day.ToString();


            double serviceFeeRate = Convert.ToDouble(frmRenewPawnOperation.dataGridView1.Rows[0].Cells["FeeRate"].Value);
            double interestRate   = Convert.ToDouble(frmRenewPawnOperation.dataGridView1.Rows[0].Cells["InterestRate"].Value);

            //this.lblMonthFeeRate.Text = serviceFeeRate.ToString();
            //this.lblInterestFeeRate.Text = interestRate.ToString();
            //this.lblOperater.Text = MainForm.AccountName;
            r = ws.get_Range(("D" + 11), ("D" + 11)); r.Value2 = serviceFeeRate.ToString();
            r = ws.get_Range(("D" + 12), ("D" + 12)); r.Value2 = interestRate.ToString();

            DDUser newUser = new DDUser("AccountName", MainForm.AccountName);

            r = ws.get_Range(("I" + 13), ("I" + 13)); r.Value2 = newUser.UserName;

            //WdSaveFormat为Excel文档的保存格式
            object format = MSExcel.XlFileFormat.xlWorkbookNormal;

            //将excelDoc文档对象的内容保存为dd文档
            //excelDoc.Save();
            //excelDoc.SaveAs(path, format, Nothing, Nothing, Nothing, Nothing, MSExcel.ddaveAsAccessMode.xlExclusive, Nothing, Nothing, Nothing, Nothing, Nothing);

            excelDoc.PrintOut(Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing);

            if (File.Exists(Application.StartupPath + @"\Pram\dump.dd"))
            {
                try
                {
                    File.Delete(Application.StartupPath + @"\Pram\dump.dd");
                }
                catch (FieldAccessException e)
                {
                    MessageBox.Show("记录文件正在被使用,请退出Excel\n" + e.ToString());
                }
            }
            excelDoc.SaveAs(Application.StartupPath + @"\Pram\dump.dd", format, Nothing, Nothing, Nothing, Nothing, MSExcel.XlSaveAsAccessMode.xlExclusive, Nothing, Nothing, Nothing, Nothing, Nothing);


            //关闭excelDoc文档对象
            excelDoc.Close(Nothing, Nothing, Nothing);

            //关闭excelApp组件对象
            excelApp.Quit();
            //MessageBox.Show("生成成功");
            //PrintReceipt();
        }
コード例 #10
0
        private void LoadTemplate(int iTicketID, string strOperationNumber)
        {
            double TotalAmount          = 0;
            double TotalServiceFee      = 0;
            double TotalLastInterestFee = 0;

            DDPawnTicket newTicket = new DDPawnTicket("TicketID", m_TicketID);

            Query queryOperation = new Query(DDOperation.Schema);

            queryOperation.AddWhere("TicketID", m_TicketID);
            queryOperation.AddWhere("OperationNumber", strOperationNumber);
            queryOperation.AddWhere("OperationType", Comparison.NotEquals, 6);
            DataTable dtOperation = queryOperation.ExecuteDataSet().Tables[0];

            for (int i = 0; i < dtOperation.Rows.Count; i++)
            {
                TotalAmount          += Convert.ToDouble(dtOperation.Rows[i]["Amount"].ToString());
                TotalServiceFee      += Convert.ToDouble(dtOperation.Rows[i]["ServiceFee"].ToString());
                TotalLastInterestFee += Convert.ToDouble(dtOperation.Rows[i]["InterestFee"].ToString());
            }
            TotalAmount          = DianDangFunction.myRound(TotalAmount, MainForm.AmountAccuracy);
            TotalServiceFee      = DianDangFunction.myRound(TotalServiceFee, MainForm.AmountAccuracy);
            TotalLastInterestFee = DianDangFunction.myRound(TotalLastInterestFee, MainForm.AmountAccuracy);


            MSExcel.Application excelApp;              //Excel应用程序变量
            MSExcel.Workbook    excelDoc;              //Excel文档变量
            excelApp = new MSExcel.ApplicationClass(); //初始化
            //由于使用的是COM库,因此有许多变量需要用Nothing代替
            Object Nothing = Missing.Value;

            excelDoc = excelApp.Workbooks._Open(Application.StartupPath + @"\Pram\RenewTemplate.dd", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

            //使用第一个工作表作为插入数据的工作表
            MSExcel.Worksheet ws = (MSExcel.Worksheet)excelDoc.Sheets[1];

            //声明一个MSExcel.Range 类型的变量r
            MSExcel.Range r;

            DDCompanyInfo company = new DDCompanyInfo("CompanyID", 1);

            //this.lblCompanyName.Text = company.CompanyName;
            //this.lblOldTicketNumber.Text = frmRenewPawnOperation.lblOldTicketNum.Text;
            r = ws.get_Range(("F" + 4), ("F" + 4)); r.Value2 = company.CompanyName;
            r = ws.get_Range(("M" + 4), ("M" + 4)); r.Value2 = newTicket.TicketNumber.ToString();
            ;
            DDCustomerInfo newCustomer = new DDCustomerInfo("CustomerID", newTicket.CustomerID);

            //this.lblCustomerName.Text = newCustomer.CustomerName;
            //this.lblContactPerson.Text = newCustomer.ContactPerson;
            r = ws.get_Range(("F" + 5), ("F" + 5)); r.Value2 = newCustomer.CustomerName;
            r = ws.get_Range(("M" + 5), ("M" + 5)); r.Value2 = newCustomer.ContactPerson;

            //this.lblAmount.Text = frmRenewPawnOperation.tbxTotalAmount.Text;
            //this.lblAmountChinese.Text = newChinese.toChineseChar(Convert.ToDecimal(frmRenewPawnOperation.tbxTotalAmount.Text));
            //this.lblServiceFee.Text = frmRenewPawnOperation.tbxServiceFee.Text;
            //this.lblServiceFeeChinese.Text = newChinese.toChineseChar(Convert.ToDecimal(frmRenewPawnOperation.tbxServiceFee.Text));
            //this.lblPaidInterestFee.Text = frmRenewPawnOperation.lblPaidInterest.Text;
            //this.lblPaidInterestFeeChinese.Text = newChinese.toChineseChar(Convert.ToDecimal(frmRenewPawnOperation.lblPaidInterest.Text));
            r = ws.get_Range(("M" + 6), ("M" + 6)); r.Value2 = TotalAmount.ToString("0.00");
            r = ws.get_Range(("H" + 6), ("H" + 6)); r.Value2 = newChinese.toChineseChar(Convert.ToDecimal(TotalAmount));
            r = ws.get_Range(("M" + 7), ("M" + 7)); r.Value2 = TotalServiceFee.ToString("0.00");
            r = ws.get_Range(("H" + 7), ("H" + 7)); r.Value2 = newChinese.toChineseChar(Convert.ToDecimal(TotalServiceFee));
            r = ws.get_Range(("M" + 8), ("M" + 8)); r.Value2 = TotalLastInterestFee.ToString("0.00");
            r = ws.get_Range(("H" + 8), ("H" + 8)); r.Value2 = newChinese.toChineseChar(Convert.ToDecimal(TotalLastInterestFee));

            double totalPaidFee = TotalServiceFee + TotalLastInterestFee;

            //this.lblPaidFee.Text = totalPaidFee.ToString();
            //this.lblPaidFeeChinese.Text = newChinese.toChineseChar(Convert.ToDecimal(totalPaidFee));
            r = ws.get_Range(("H" + 9), ("H" + 9)); r.Value2 = newChinese.toChineseChar(Convert.ToDecimal(totalPaidFee));
            r = ws.get_Range(("M" + 9), ("M" + 9)); r.Value2 = totalPaidFee.ToString("0.00");

            DateTime startDate     = Convert.ToDateTime(dtOperation.Rows[0]["StartDate"].ToString());
            DateTime endDate       = Convert.ToDateTime(dtOperation.Rows[0]["EndDate"].ToString());
            DateTime operationDate = Convert.ToDateTime(dtOperation.Rows[0]["OperationDate"].ToString());

            //this.lblStartYear.Text = startDate.Year.ToString();
            //this.lblStartMonth.Text = startDate.Month.ToString();
            //this.lblStartDay.Text = startDate.Day.ToString();
            //this.lblEndYear.Text = endDate.Year.ToString();
            //this.lblEndMonth.Text = endDate.Month.ToString();
            //this.lblEndDay.Text = endDate.Day.ToString();
            //this.lblOperationYear.Text = operationDate.Year.ToString();
            //this.lblOperationMonth.Text = operationDate.Month.ToString();
            //this.lblOperationDay.Text = operationDate.Day.ToString();
            r = ws.get_Range(("F" + 10), ("F" + 10)); r.Value2 = startDate.Year.ToString();
            r = ws.get_Range(("I" + 10), ("I" + 10)); r.Value2 = startDate.Month.ToString();
            r = ws.get_Range(("J" + 10), ("J" + 10)); r.Value2 = startDate.Day.ToString();
            r = ws.get_Range(("K" + 10), ("K" + 10)); r.Value2 = endDate.Year.ToString();
            r = ws.get_Range(("L" + 10), ("L" + 10)); r.Value2 = endDate.Month.ToString();
            r = ws.get_Range(("M" + 10), ("M" + 10)); r.Value2 = endDate.Day.ToString();
            r = ws.get_Range(("M" + 13), ("M" + 13)); r.Value2 = operationDate.Year.ToString();
            r = ws.get_Range(("O" + 13), ("O" + 13)); r.Value2 = operationDate.Month.ToString();
            r = ws.get_Range(("Q" + 13), ("Q" + 13)); r.Value2 = operationDate.Day.ToString();


            double serviceFeeRate = Convert.ToDouble(dtOperation.Rows[0]["ServiceFeeRate"].ToString());
            double interestRate   = Convert.ToDouble(dtOperation.Rows[0]["InterestFeeRate"].ToString());

            //this.lblMonthFeeRate.Text = serviceFeeRate.ToString();
            //this.lblInterestFeeRate.Text = interestRate.ToString();
            //this.lblOperater.Text = MainForm.AccountName;
            r = ws.get_Range(("D" + 11), ("D" + 11)); r.Value2 = serviceFeeRate.ToString();
            r = ws.get_Range(("D" + 12), ("D" + 12)); r.Value2 = interestRate.ToString();

            DDUser newUser = new DDUser("AccountName", MainForm.AccountName);

            r = ws.get_Range(("I" + 13), ("I" + 13)); r.Value2 = newUser.UserName;

            //WdSaveFormat为Excel文档的保存格式
            object format = MSExcel.XlFileFormat.xlWorkbookNormal;

            //将excelDoc文档对象的内容保存为dd文档
            //excelDoc.Save();
            //excelDoc.SaveAs(path, format, Nothing, Nothing, Nothing, Nothing, MSExcel.ddaveAsAccessMode.xlExclusive, Nothing, Nothing, Nothing, Nothing, Nothing);

            excelDoc.PrintOut(Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing);

            if (File.Exists(Application.StartupPath + @"\Pram\dump.dd"))
            {
                try
                {
                    File.Delete(Application.StartupPath + @"\Pram\dump.dd");
                }
                catch (FieldAccessException e)
                {
                    MessageBox.Show("记录文件正在被使用,请退出Excel\n" + e.ToString());
                }
            }
            excelDoc.SaveAs(Application.StartupPath + @"\Pram\dump.dd", format, Nothing, Nothing, Nothing, Nothing, MSExcel.XlSaveAsAccessMode.xlExclusive, Nothing, Nothing, Nothing, Nothing, Nothing);


            //关闭excelDoc文档对象
            excelDoc.Close(Nothing, Nothing, Nothing);

            //关闭excelApp组件对象
            excelApp.Quit();
            //MessageBox.Show("生成成功");
            //PrintReceipt();
        }
コード例 #11
0
        private void LoadTemplate(int iTicketID, string strOperationNumber)
        {
            double        TotalAmount          = 0;
            double        TotalServiceFee      = 0;
            double        TotalLastInterestFee = 0;
            double        TotalReturnFee       = 0;
            double        TotalOverdueFee      = 0;
            double        FirstTotalServiceFee = 0;
            double        FirstTotalAmount     = 0;
            List <string> strList = new List <string>();

            DDPawnTicket   newTicket   = new DDPawnTicket("TicketID", m_TicketID);
            DDCustomerInfo newCustomer = new DDCustomerInfo("CustomerID", newTicket.CustomerID);

            Query queryOperation = new Query(DDOperation.Schema);

            queryOperation.AddWhere("TicketID", m_TicketID);
            queryOperation.AddWhere("OperationNumber", strOperationNumber);
            queryOperation.AddWhere("OperationType", Comparison.NotEquals, 6);
            DataTable dtOperation = queryOperation.ExecuteDataSet().Tables[0];

            for (int i = 0; i < dtOperation.Rows.Count; i++)
            {
                TotalAmount          += Convert.ToDouble(dtOperation.Rows[i]["Amount"].ToString());
                TotalServiceFee      += Convert.ToDouble(dtOperation.Rows[i]["ServiceFee"].ToString());
                TotalLastInterestFee += Convert.ToDouble(dtOperation.Rows[i]["InterestFee"].ToString());
                TotalReturnFee       += Convert.ToDouble(dtOperation.Rows[i]["ReturnFee"].ToString());
                TotalOverdueFee      += Convert.ToDouble(dtOperation.Rows[i]["OverdueFee"].ToString());
            }
            TotalAmount          = DianDangFunction.myRound(TotalAmount, MainForm.AmountAccuracy);
            TotalServiceFee      = DianDangFunction.myRound(TotalServiceFee, MainForm.AmountAccuracy);
            TotalLastInterestFee = DianDangFunction.myRound(TotalLastInterestFee, MainForm.AmountAccuracy);
            TotalReturnFee       = DianDangFunction.myRound(TotalReturnFee, MainForm.AmountAccuracy);
            TotalOverdueFee      = DianDangFunction.myRound(TotalOverdueFee, MainForm.AmountAccuracy);

            queryOperation = new Query(DDOperation.Schema);
            queryOperation.AddWhere("TicketID", m_TicketID);
            queryOperation.AddWhere("PreOperationID", 0);
            queryOperation.AddWhere("OperationType", Comparison.NotEquals, 6);
            dtOperation = queryOperation.ExecuteDataSet().Tables[0];
            for (int i = 0; i < dtOperation.Rows.Count; i++)
            {
                FirstTotalAmount     += Convert.ToDouble(dtOperation.Rows[i]["Amount"].ToString());
                FirstTotalServiceFee += Convert.ToDouble(dtOperation.Rows[i]["ServiceFee"].ToString());
            }
            FirstTotalAmount     = DianDangFunction.myRound(FirstTotalAmount, MainForm.AmountAccuracy);
            FirstTotalServiceFee = DianDangFunction.myRound(FirstTotalServiceFee, MainForm.AmountAccuracy);



            MSExcel.Application excelApp;              //Excel应用程序变量
            MSExcel.Workbook    excelDoc;              //Excel文档变量
            excelApp = new MSExcel.ApplicationClass(); //初始化
            //由于使用的是COM库,因此有许多变量需要用Nothing代替
            Object Nothing = Missing.Value;

            excelDoc = excelApp.Workbooks._Open(Application.StartupPath + @"\Pram\RedeemTemplate_TongBao.dd", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

            //使用第一个工作表作为插入数据的工作表
            MSExcel.Worksheet ws = (MSExcel.Worksheet)excelDoc.Sheets[1];

            //声明一个MSExcel.Range 类型的变量r
            MSExcel.Range r;

            DDCompanyInfo company = new DDCompanyInfo("CompanyID", 1);

            //r = ws.get_Range(("F" + 4), ("F" + 4)); r.Value2 = company.CompanyName;
            r = ws.get_Range(("K" + 5), ("K" + 5)); r.Value2 = newTicket.TicketNumber.ToString();

            r = ws.get_Range(("D" + 5), ("D" + 5)); r.Value2 = newCustomer.CustomerName;


            //TotalAmount:
            string strTotalMount = TotalAmount.ToString("0.00");

            r = ws.get_Range(("D" + 7), ("D" + 7)); r.Value2 = newChinese.toChineseChar(strTotalMount);
            r = ws.get_Range(("M" + 7), ("M" + 7)); r.Value2 = strTotalMount;


            //Fee
            string strFirstGive = (FirstTotalAmount - FirstTotalServiceFee).ToString("0.00");

            r = ws.get_Range(("E" + 13), ("E" + 13)); r.Value2 = newChinese.toChineseChar(strFirstGive);
            r = ws.get_Range(("L" + 13), ("L" + 13)); r.Value2 = strFirstGive;

            string strFirstServiceFee = FirstTotalServiceFee.ToString("0.00");

            r = ws.get_Range(("E" + 15), ("E" + 15)); r.Value2 = newChinese.toChineseChar(strFirstServiceFee);
            r = ws.get_Range(("L" + 15), ("L" + 15)); r.Value2 = strFirstServiceFee;

            string strOverdue = (Math.Abs(TotalLastInterestFee + TotalOverdueFee - TotalReturnFee + TotalServiceFee)).ToString("0.00");

            r = ws.get_Range(("E" + 17), ("E" + 17)); r.Value2 = newChinese.toChineseChar(strOverdue);
            r = ws.get_Range(("L" + 17), ("L" + 17)); r.Value2 = strOverdue;

            string strAll = (TotalAmount + TotalLastInterestFee + TotalOverdueFee + TotalServiceFee - TotalReturnFee).ToString("0.00");

            strList = newChinese.toStrList(strAll, 5, 2);
            r       = ws.get_Range(("D" + 19), ("D" + 19)); r.Value2 = strList[0];
            r       = ws.get_Range(("E" + 19), ("E" + 19)); r.Value2 = strList[1];
            r       = ws.get_Range(("G" + 19), ("G" + 19)); r.Value2 = strList[2];
            r       = ws.get_Range(("H" + 19), ("H" + 19)); r.Value2 = strList[3];
            r       = ws.get_Range(("I" + 19), ("I" + 19)); r.Value2 = strList[4];
            r       = ws.get_Range(("J" + 19), ("J" + 19)); r.Value2 = strList[5];
            r       = ws.get_Range(("L" + 19), ("L" + 19)); r.Value2 = strList[6];
            r       = ws.get_Range(("N" + 19), ("N" + 19)); r.Value2 = strAll;

            //日期
            DDOperation ThisOperation = new DDOperation("OperationNumber", strOperationNumber);
            DDOperation LastOperation = new DDOperation("OperationID", ThisOperation.PreOperationID);

            DateTime operationDate = Convert.ToDateTime(ThisOperation.OperationDate);
            DateTime lastStartDate = Convert.ToDateTime(LastOperation.StartDate);
            DateTime lastEndDate   = Convert.ToDateTime(LastOperation.EndDate);

            r = ws.get_Range(("C" + 9), ("C" + 9)); r.Value2 = lastStartDate.Year.ToString();
            r = ws.get_Range(("E" + 9), ("E" + 9)); r.Value2 = lastStartDate.Month.ToString();
            r = ws.get_Range(("G" + 9), ("G" + 9)); r.Value2 = lastStartDate.Day.ToString();
            r = ws.get_Range(("I" + 9), ("I" + 9)); r.Value2 = lastEndDate.Year.ToString();
            r = ws.get_Range(("J" + 9), ("J" + 9)); r.Value2 = lastEndDate.Month.ToString();
            r = ws.get_Range(("L" + 9), ("L" + 9)); r.Value2 = lastEndDate.Day.ToString();


            r = ws.get_Range(("B" + 11), ("B" + 11)); r.Value2 = operationDate.Year.ToString();
            r = ws.get_Range(("D" + 11), ("D" + 11)); r.Value2 = operationDate.Month.ToString();
            r = ws.get_Range(("G" + 11), ("G" + 11)); r.Value2 = operationDate.Day.ToString();
            r = ws.get_Range(("L" + 3), ("L" + 3)); r.Value2 = operationDate.Year.ToString();
            r = ws.get_Range(("N" + 3), ("N" + 3)); r.Value2 = operationDate.Month.ToString();
            r = ws.get_Range(("O" + 3), ("O" + 3)); r.Value2 = operationDate.Day.ToString();

            //double serviceFeeRate = Convert.ToDouble(dtOperation.Rows[0]["ServiceFeeRate"].ToString());
            //double interestRate = Convert.ToDouble(dtOperation.Rows[0]["InterestFeeRate"].ToString());
            //r = ws.get_Range(("D" + 11), ("D" + 11)); r.Value2 = serviceFeeRate.ToString();
            //r = ws.get_Range(("D" + 12), ("D" + 12)); r.Value2 = interestRate.ToString();

            DDUser newUser = new DDUser("AccountName", MainForm.AccountName);

            r = ws.get_Range(("K" + 21), ("K" + 21)); r.Value2 = newUser.UserName;

            //WdSaveFormat为Excel文档的保存格式
            object format = MSExcel.XlFileFormat.xlWorkbookNormal;

            //将excelDoc文档对象的内容保存为dd文档
            //excelDoc.Save();
            //excelDoc.SaveAs(path, format, Nothing, Nothing, Nothing, Nothing, MSExcel.ddaveAsAccessMode.xlExclusive, Nothing, Nothing, Nothing, Nothing, Nothing);

            excelDoc.PrintOut(Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing);

            if (File.Exists(Application.StartupPath + @"\Pram\dump.dd"))
            {
                try
                {
                    File.Delete(Application.StartupPath + @"\Pram\dump.dd");
                }
                catch (FieldAccessException e)
                {
                    MessageBox.Show("记录文件正在被使用,请退出Excel\n" + e.ToString());
                }
            }
            excelDoc.SaveAs(Application.StartupPath + @"\Pram\dump.dd", format, Nothing, Nothing, Nothing, Nothing, MSExcel.XlSaveAsAccessMode.xlExclusive, Nothing, Nothing, Nothing, Nothing, Nothing);


            //关闭excelDoc文档对象
            excelDoc.Close(Nothing, Nothing, Nothing);

            //关闭excelApp组件对象
            excelApp.Quit();
            //MessageBox.Show("生成成功");
            //PrintReceipt();
        }
コード例 #12
0
        private void OperationAmount()
        {
            DateTime startDate = Convert.ToDateTime(this.tbxStartDate.Text.Trim());
            DateTime endDate   = Convert.ToDateTime(this.tbxEndDate.Text.Trim());

            double newPawnAmount         = 0;
            double closeOfNewAmount      = 0;
            double redeemPawnAmount      = 0;
            double renewPawnAmount       = 0;
            double closePawnAmount       = 0;
            double goldOfClosePawnAmount = 0;
            double clearPawnAmount       = 0;
            double clearPawnReckonAmount = 0;
            double reckoningPL           = 0; //清算盈亏
            double unclearPawnAmount     = 0;
            double newPawnServiceFee     = 0; //建当服务费
            double renewPawnServiceFee   = 0; //续当服务费
            double interestFee           = 0; //典当利息
            double overDueFee            = 0; //逾期服务费
            double returnFee             = 0; //返回服务费
            double totalFee = 0;              //总计营收

            int    operationType = 0;
            double amount        = 0;

            Query queryOperations = new Query(DDOperation.Schema);

            queryOperations.AddBetweenAnd("OperationDate", startDate, endDate);
            DataTable dtOperations = queryOperations.ExecuteDataSet().Tables[0];

            if (dtOperations.Rows.Count > 0)
            {
                for (int i = 0; i < dtOperations.Rows.Count; i++)
                {
                    operationType = Convert.ToInt32(dtOperations.Rows[i]["OperationType"]);
                    amount        = Convert.ToDouble(dtOperations.Rows[i]["Amount"]);

                    switch (operationType)
                    {
                    case 1:
                        newPawnAmount += amount;
                        DDPawnTicket newTicket = new DDPawnTicket("TicketID", Convert.ToInt32(dtOperations.Rows[i]["TicketID"]));
                        if (newTicket.StatusID == 4 || newTicket.StatusID == 7)
                        {
                            closeOfNewAmount += amount;
                        }
                        newPawnServiceFee += Convert.ToDouble(dtOperations.Rows[i]["ServiceFee"]);
                        interestFee       += Convert.ToDouble(dtOperations.Rows[i]["InterestFee"]);
                        break;

                    case 2:
                        redeemPawnAmount += amount;
                        overDueFee       += Convert.ToDouble(dtOperations.Rows[i]["OverdueFee"]);
                        returnFee        += Convert.ToDouble(dtOperations.Rows[i]["ReturnFee"]);
                        interestFee      += Convert.ToDouble(dtOperations.Rows[i]["InterestFee"]);
                        break;

                    case 3:
                        renewPawnAmount     += amount;
                        renewPawnServiceFee += Convert.ToDouble(dtOperations.Rows[i]["ServiceFee"]);
                        interestFee         += Convert.ToDouble(dtOperations.Rows[i]["InterestFee"]);
                        break;

                    case 4:
                        closePawnAmount += amount;
                        DDPawnageInfo newPawnage = new DDPawnageInfo("PawnageID", Convert.ToInt32(dtOperations.Rows[i]["PawnageID"]));
                        if (newPawnage.ParentID == 2)      //2:黄金类ClassID
                        {
                            goldOfClosePawnAmount += amount;
                        }
                        break;

                    case 7:
                        clearPawnAmount       += amount;
                        clearPawnReckonAmount += Convert.ToDouble(dtOperations.Rows[i]["ReckonAmount"]);
                        break;

                    default:
                        break;
                    }
                }
                reckoningPL       = clearPawnReckonAmount - clearPawnAmount; //清算盈亏
                unclearPawnAmount = closePawnAmount - clearPawnAmount;       //未清算金额
                totalFee          = newPawnServiceFee + renewPawnServiceFee + interestFee + overDueFee - returnFee;
            }

            double allNewPawnAmount = 0;
            //double closeOfAllNewPawnAmount = 0;
            double allRedeemPawnAmount = 0;
            double allClosePawnAmount  = 0;

            DDCompanyInfo company            = new DDCompanyInfo("CompanyID", 1);
            DateTime      setupDate          = Convert.ToDateTime(company.SetupDate);
            Query         queryAllOperations = new Query(DDOperation.Schema);

            queryAllOperations.AddBetweenAnd("OperationDate", setupDate, endDate);  //所有的操作记录
            DataTable dtAllOperations = queryAllOperations.ExecuteDataSet().Tables[0];

            if (dtAllOperations.Rows.Count > 0)
            {
                for (int j = 0; j < dtAllOperations.Rows.Count; j++)
                {
                    operationType = Convert.ToInt32(dtAllOperations.Rows[j]["OperationType"]);
                    amount        = Convert.ToDouble(dtAllOperations.Rows[j]["Amount"]);
                    if (operationType == 1)
                    {
                        allNewPawnAmount += amount;
                        //DDPawnTicket newTicket = new DDPawnTicket("TicketID", Convert.ToInt32(dtAllOperations.Rows[j]["TicketID"]));
                        //if (newTicket.StatusID == 4 || newTicket.StatusID == 7)
                        //{
                        //    closeOfAllNewPawnAmount += amount;
                        //}
                    }
                    if (operationType == 2)
                    {
                        allRedeemPawnAmount += amount;
                    }
                    if (operationType == 4)
                    {
                        allClosePawnAmount += amount;
                    }
                }
            }
            double startTotalAmount = 0;
            double endTotalAmount   = 0;
            double increAmount      = 0;
            double totalAmount      = 0;

            endTotalAmount   = allNewPawnAmount - allClosePawnAmount - allRedeemPawnAmount;
            increAmount      = newPawnAmount - closePawnAmount - redeemPawnAmount;
            startTotalAmount = endTotalAmount - increAmount;
            totalAmount      = endTotalAmount + unclearPawnAmount;

            double percentCloseOfNewPawn             = 0;
            double percentIncreOfStart               = 0;
            double percentIncreOfEnd                 = 0;
            double percentNewPawnServiceFeeOfTotal   = 0;
            double percentRenewPawnServiceFeeOfTotal = 0;
            double percentInterestFeeOfTotal         = 0;
            double percentRetureFeeOfTotal           = 0;
            double percentOverdueFeeOfTotal          = 0;

            if (newPawnAmount != 0)
            {
                percentCloseOfNewPawn = closeOfNewAmount * 100 / newPawnAmount;
                percentCloseOfNewPawn = DianDangFunction.myRound(percentCloseOfNewPawn, MainForm.AmountAccuracy);
            }

            if (startTotalAmount != 0)
            {
                percentIncreOfStart = increAmount * 100 / startTotalAmount;
                percentIncreOfStart = DianDangFunction.myRound(percentIncreOfStart, MainForm.AmountAccuracy);
            }

            if (endTotalAmount != 0)
            {
                percentIncreOfEnd = increAmount * 100 / endTotalAmount;
                percentIncreOfEnd = DianDangFunction.myRound(percentIncreOfEnd, MainForm.AmountAccuracy);
            }

            if (totalFee != 0)
            {
                percentNewPawnServiceFeeOfTotal   = newPawnServiceFee * 100 / totalFee;
                percentNewPawnServiceFeeOfTotal   = DianDangFunction.myRound(percentNewPawnServiceFeeOfTotal, MainForm.AmountAccuracy);
                percentRenewPawnServiceFeeOfTotal = renewPawnServiceFee * 100 / totalFee;
                percentRenewPawnServiceFeeOfTotal = DianDangFunction.myRound(percentRenewPawnServiceFeeOfTotal, MainForm.AmountAccuracy);
                percentInterestFeeOfTotal         = interestFee * 100 / totalFee;
                percentInterestFeeOfTotal         = DianDangFunction.myRound(percentInterestFeeOfTotal, MainForm.AmountAccuracy);
                percentRetureFeeOfTotal           = returnFee * 100 / totalFee;
                percentRetureFeeOfTotal           = DianDangFunction.myRound(percentRetureFeeOfTotal, MainForm.AmountAccuracy);
                percentOverdueFeeOfTotal          = overDueFee * 100 / totalFee;
                percentOverdueFeeOfTotal          = DianDangFunction.myRound(percentOverdueFeeOfTotal, MainForm.AmountAccuracy);
            }

            this.lblNewPawnAmount.Text     = newPawnAmount.ToString();
            this.lblCloseOfNewAmount.Text  = closeOfNewAmount.ToString();
            this.lblRenewPawnAmount.Text   = renewPawnAmount.ToString();
            this.lblSalesSize.Text         = (newPawnAmount + renewPawnAmount).ToString();
            this.lblRedeemPawnAmount.Text  = redeemPawnAmount.ToString();
            this.lblClosePawnAmount.Text   = closePawnAmount.ToString();
            this.lblGoldOfCloseAmount.Text = goldOfClosePawnAmount.ToString();
            this.lblStartTotalAmount.Text  = startTotalAmount.ToString();
            this.lblEndTotalAmount.Text    = endTotalAmount.ToString();
            this.lblIncreAmount.Text       = increAmount.ToString();
            this.lblTotalFee.Text          = totalFee.ToString();
            newPawnServiceFee = DianDangFunction.myRound(newPawnServiceFee, MainForm.AmountAccuracy);
            this.lblNewPawnServiceFee.Text   = newPawnServiceFee.ToString();
            this.lblRenewPawnServiceFee.Text = renewPawnServiceFee.ToString();
            this.lblInterestFee.Text         = interestFee.ToString();
            this.lblOverDueFee.Text          = overDueFee.ToString();
            this.lblReturnFee.Text           = returnFee.ToString();
            this.lblCloseClearAmount.Text    = clearPawnAmount.ToString();       //绝当处理金额
            this.lblClearAmount.Text         = clearPawnReckonAmount.ToString(); //清算金额
            this.lblReckoningPL.Text         = reckoningPL.ToString();
            this.lblUnclearAmount.Text       = unclearPawnAmount.ToString();
            this.lblTotalAmount.Text         = totalAmount.ToString();
            //总收入
            this.lblTotalIncommingAmount.Text = (totalFee + redeemPawnAmount).ToString();
            //总支出
            this.lblTotalOutAmount.Text = newPawnAmount.ToString();
            //收支余额
            this.lblTotalBalance.Text = (totalFee + redeemPawnAmount - newPawnAmount).ToString("0.00");

            this.lblCloseOfNewPercent.Text      = percentCloseOfNewPawn.ToString();
            this.lblIncreOfStartPercent.Text    = percentIncreOfStart.ToString();
            this.lblIncreOfEndPercent.Text      = percentIncreOfEnd.ToString();
            this.lblNewServiceFeeOfTotal.Text   = percentNewPawnServiceFeeOfTotal.ToString();
            this.lblRenewServiceFeeOfTotal.Text = percentRenewPawnServiceFeeOfTotal.ToString();
            this.lblInterestFeeOfTotal.Text     = percentInterestFeeOfTotal.ToString();
            this.lblReturnfeeOfTotal.Text       = percentRetureFeeOfTotal.ToString();
            this.lblOverdueFeeOfTotal.Text      = percentOverdueFeeOfTotal.ToString();
        }
コード例 #13
0
        private void OperationCount()
        {
            try
            {
                DateTime startDate = Convert.ToDateTime(this.tbxStartDate.Text.Trim());
                DateTime endDate   = Convert.ToDateTime(this.tbxEndDate.Text.Trim());

                int newPawnCount         = 0;
                int closeOfNewCount      = 0;
                int redeemPawnCount      = 0;
                int renewPawnCount       = 0;
                int closePawnCount       = 0;
                int goldOfClosePawnCount = 0;

                int operationType = 0;

                string    selectList      = string.Format("{0},{1},{2},{3},{4}", DDOperation.OperationNumberColumn.ColumnName, DDOperation.OperationTypeColumn.ColumnName, DDOperation.PawnageIDColumn.ColumnName, DDOperation.TicketIDColumn.ColumnName, DDOperation.OperationDateColumn.ColumnName);
                Query     queryOperations = new Query(DDOperation.Schema).SetSelectList(selectList).AddBetweenAnd("OperationDate", startDate, endDate).ORDER_BY(DDOperation.OperationNumberColumn.ColumnName);
                DataTable dtOperations    = queryOperations.ExecuteDataSet().Tables[0];
                if (dtOperations.Rows.Count > 0)
                {
                    string operationNumber    = "0";
                    string preOperationNumber = "0";
                    for (int i = 0; i < dtOperations.Rows.Count; i++)
                    {
                        operationNumber = dtOperations.Rows[i]["OperationNumber"].ToString();

                        if (operationNumber != preOperationNumber)
                        {
                            operationType = Convert.ToInt32(dtOperations.Rows[i]["OperationType"]);
                            switch (operationType)
                            {
                            case 1:
                                newPawnCount++;
                                DDPawnTicket newTicket = new DDPawnTicket("TicketID", Convert.ToInt32(dtOperations.Rows[i]["TicketID"]));
                                if (newTicket.StatusID == 4 || newTicket.StatusID == 7)
                                {
                                    closeOfNewCount++;
                                }
                                break;

                            case 2:
                                redeemPawnCount++;
                                break;

                            case 3:
                                renewPawnCount++;
                                break;

                            case 4:
                                closePawnCount++;
                                DDPawnageInfo newPawnage = new DDPawnageInfo("PawnageID", Convert.ToInt32(dtOperations.Rows[i]["PawnageID"]));
                                if (newPawnage.ParentID == 2)      //109:黄金类ClassID
                                {
                                    goldOfClosePawnCount++;
                                }
                                break;

                            default:
                                break;
                            }
                            preOperationNumber = operationNumber;
                        }
                    }
                }

                double allNewPawnCount = 0;
                //double closeOfAllNewPawnCount = 0;
                double allRedeemPawnCount = 0;
                double allClosePawnCount  = 0;

                DDCompanyInfo company            = new DDCompanyInfo("CompanyID", 1);
                DateTime      setupDate          = Convert.ToDateTime(company.SetupDate);
                Query         queryAllOperations = new Query(DDOperation.Schema).SetSelectList(selectList).DISTINCT().ORDER_BY(DDOperation.OperationNumberColumn.ColumnName);
                queryAllOperations.AddBetweenAnd("OperationDate", setupDate, endDate);  //所有的操作记录
                DataTable dtAllOperations = queryAllOperations.ExecuteDataSet().Tables[0];
                if (dtAllOperations.Rows.Count > 0)
                {
                    string operationNumber    = "0";
                    string preOperationNumber = "0";

                    for (int j = 0; j < dtAllOperations.Rows.Count; j++)
                    {
                        operationNumber = dtAllOperations.Rows[j]["OperationNumber"].ToString();
                        if (operationNumber != preOperationNumber)
                        {
                            operationType = Convert.ToInt32(dtAllOperations.Rows[j]["OperationType"]);
                            if (operationType == 1)
                            {
                                allNewPawnCount++;
                                //    DDPawnTicket newTicket = new DDPawnTicket("TicketID", Convert.ToInt32(dtAllOperations.Rows[j]["TicketID"]));
                                //    if (newTicket.StatusID == 4 || newTicket.StatusID == 7)
                                //    {
                                //        closeOfAllNewPawnCount++;
                                //    }
                            }
                            if (operationType == 2)
                            {
                                allRedeemPawnCount++;
                            }
                            if (operationType == 4)
                            {
                                allClosePawnCount++;
                            }
                            preOperationNumber = operationNumber;
                        }
                    }
                }

                double startTotalCount = 0;
                double endTotalCount   = 0;
                double increCount      = 0;
                endTotalCount   = allNewPawnCount - allRedeemPawnCount - allClosePawnCount;
                increCount      = newPawnCount - redeemPawnCount - closePawnCount;
                startTotalCount = endTotalCount - increCount;

                this.lblNewPawnCount.Text     = newPawnCount.ToString();
                this.lblCloseOfNewCount.Text  = closeOfNewCount.ToString();
                this.lblRenewPawnCount.Text   = renewPawnCount.ToString();
                this.lblSalesCount.Text       = (newPawnCount + renewPawnCount).ToString();
                this.lblRedeemPawnCount.Text  = redeemPawnCount.ToString();
                this.lblClosePawnCount.Text   = closePawnCount.ToString();
                this.lblGoldOfCloseCount.Text = goldOfClosePawnCount.ToString();

                this.lblStartTotalCount.Text = startTotalCount.ToString();
                this.lblEndTotalCount.Text   = endTotalCount.ToString();
                this.lblIncreCount.Text      = increCount.ToString();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }