private void btnAddCustomer_Click(object sender, EventArgs e) { DialogResult res = CheckAllMessage(); if (res == DialogResult.OK) { try { DDCustomerInfo newCustomer = new DDCustomerInfo(); newCustomer.CustomerName = this.tbxName.Text; newCustomer.PhoneNumber = this.tbxPhone.Text; newCustomer.Address = this.tbxAddress.Text; newCustomer.ContactPerson = this.tbxContactPerson.Text; newCustomer.CertTypeID = Convert.ToInt32(this.cbxCertType.SelectedValue); newCustomer.CertNumber = this.tbxCertNum.Text; newCustomer.CreatDate = DianDangFunction.ChangeDateFormat(DateTime.Now.ToShortDateString()); newCustomer.Save(); MessageBox.Show("添加成功!", "添加客户"); } catch { MessageBox.Show("添加失败,请检查数据库是否连接正确!", "添加客户"); } } }
private void monthCalendar1_DateSelected(object sender, DateRangeEventArgs e) { string iDate = ""; iDate = DianDangFunction.ChangeDateFormat(e.Start.ToShortDateString()); switch (DateSelector) { case 1: this.tbxStartDate.Text = iDate; break; case 2: this.tbxEndDate.Text = iDate; break; default: break; } this.monthCalendar1.Visible = false; }
private void Summery() { double[] Result = new double[2]; double InHouseAmount = 0; int InHouseCount = 0; double RedeenAmout = 0; int RedeenCount = 0; double CloseAmount = 0; int CloseCount = 0; double TotalAmount = 0; double TotalCount = 0; //在库金额 Result = GetAmountByStatus(new int[] { 1, 3, 4, 5 }); InHouseAmount = Result[0]; InHouseCount = Convert.ToInt32(Result[1]); //赎回金额 Result = GetAmountByStatus(new int[] { 2 }); RedeenAmout = Result[0]; RedeenCount = Convert.ToInt32(Result[1]); //绝当金额 Result = GetAmountByStatus(new int[] { 4, 7 }); CloseAmount = Result[0]; CloseCount = Convert.ToInt32(Result[1]); //全部金额 Result = GetAmountByStatus(new int[] { 1, 2, 3, 4, 5, 7 }); TotalAmount = Result[0]; TotalCount = Convert.ToInt32(Result[1]); //输出 lblTotalAmount.Text = TotalAmount.ToString(); lblTotalCount.Text = TotalCount.ToString(); lblInHouseAmount.Text = InHouseAmount.ToString(); lblInHouseAmountPercent.Text = DianDangFunction.myRound((InHouseAmount / TotalAmount * 100), MainForm.AmountAccuracy).ToString() + "%"; lblInHouseCount.Text = InHouseCount.ToString(); lblInHouseCountPercent.Text = DianDangFunction.myRound((InHouseCount / TotalCount * 100), MainForm.AmountAccuracy).ToString() + "%"; lblRedeenAmount.Text = RedeenAmout.ToString(); lblRedeenAmountPercent.Text = DianDangFunction.myRound((RedeenAmout / TotalAmount * 100), MainForm.AmountAccuracy).ToString() + "%"; lblRedeenCount.Text = RedeenCount.ToString(); lblRedeenCountPercent.Text = DianDangFunction.myRound((RedeenCount / TotalCount * 100), MainForm.AmountAccuracy).ToString() + "%"; lblCloseAmount.Text = CloseAmount.ToString(); lblCloseAmountPercent.Text = DianDangFunction.myRound((CloseAmount / TotalAmount * 100), MainForm.AmountAccuracy).ToString() + "%"; lblCloseCount.Text = CloseCount.ToString(); lblCloseCountPercent.Text = DianDangFunction.myRound((CloseCount / TotalCount * 100), MainForm.AmountAccuracy).ToString() + "%"; Result = GetTotalFee(); lblTotalServiceFee.Text = Result[0].ToString(); lblTotalInterestFee.Text = Result[1].ToString(); DDCustomerInfo newInfo = new DDCustomerInfo("CustomerID", m_CustomerID); this.lblStartDate.Text = DianDangFunction.ChangeDateFormat(newInfo.CreatDate); Query queryTicket = new Query(DDPawnTicket.Schema); queryTicket.AddWhere("CustomerID", m_CustomerID); queryTicket.AddWhere("StatusID", Comparison.In, new int[] { 1, 2, 3 }); DataTable dtTicket = queryTicket.ExecuteDataSet().Tables[0]; int[] TicketIDList = new int[dtTicket.Rows.Count]; for (int j = 0; j < dtTicket.Rows.Count; j++) { TicketIDList[j] = Convert.ToInt32(dtTicket.Rows[j]["TicketID"].ToString()); } Query queryOperation = new Query(DDOperation.Schema); queryOperation.AddWhere("TicketID", Comparison.In, TicketIDList); queryOperation.AddWhere("NextOperationID", 0); queryOperation.ORDER_BY("OperationDate", "desc"); DataTable dtOperation = queryOperation.ExecuteDataSet().Tables[0]; lblLastDate.Text = DianDangFunction.ChangeDateFormat(dtOperation.Rows[0]["OperationDate"].ToString()); }