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());
}
