private void RefreshCustom(string DataString)
{
isBusy.Visible = true;
DelegateReadSoldEquip dn = MysqlControl.ReadSoldEquip;
IAsyncResult iar = dn.BeginInvoke(DataString, null, null);
while (iar.IsCompleted == false)
{
Application.DoEvents();
}
MysqlController.LXEquip[] tempPayout = dn.EndInvoke(iar);
lsvEquips.Items.Clear();
if (tempPayout == null)
{
return;
}
if (tempPayout.Length <= 0)
{
return;
}
for (int i = 0; i < tempPayout.Length; i++)
{
if (string.IsNullOrEmpty(tempPayout[i].EquipDate))
{
continue;
}
lsvEquips.Items.Add(tempPayout[i].EquipID.ToString());
lsvEquips.Items[i].SubItems.Add(tempPayout[i].EquipDate);
lsvEquips.Items[i].SubItems.Add(tempPayout[i].EquipName);
lsvEquips.Items[i].SubItems.Add(tempPayout[i].EquipPrice.ToString());
lsvEquips.Items[i].SubItems.Add(tempPayout[i].EquipRealPrice.ToString());
lsvEquips.Items[i].SubItems.Add(tempPayout[i].EquipSupplier);
lsvEquips.Items[i].SubItems.Add(tempPayout[i].EquipBackup);
lsvEquips.Items[i].SubItems.Add(tempPayout[i].EquipSellers);
lsvEquips.Items[i].SubItems.Add(tempPayout[i].EquipProfit.ToString());
lsvEquips.Items[i].SubItems.Add(tempPayout[i].EquipCommision.ToString());
Application.DoEvents();
}
isBusy.Visible = false;
}
private void RefreshPayout()
{
isBusy.Visible = true;
DelegateReadSoldEquip dn = MysqlControl.ReadSoldEquip;
IAsyncResult iar = dn.BeginInvoke(dtpTime.Value.Year + dtpTime.Value.Month.ToString().PadLeft(2, '0') +
dtpTime.Value.Day.ToString().PadLeft(2, '0'), null, null);
while (iar.IsCompleted == false)
{
Application.DoEvents();
}
MysqlController.LXEquip[] tempPayout = dn.EndInvoke(iar);
lsvEquips.Items.Clear();
if (tempPayout == null)
{
return;
}
if (tempPayout.Length <= 0)
{
return;
}
for (int i = 0; i < tempPayout.Length; i++)
{
if (string.IsNullOrEmpty(tempPayout[i].EquipDate))
{
continue;
}
lsvEquips.Items.Add(tempPayout[i].EquipID.ToString());
lsvEquips.Items[i].SubItems.Add(tempPayout[i].EquipDate);
lsvEquips.Items[i].SubItems.Add(tempPayout[i].EquipName);
lsvEquips.Items[i].SubItems.Add(tempPayout[i].EquipPrice.ToString());
lsvEquips.Items[i].SubItems.Add(tempPayout[i].EquipRealPrice.ToString());
lsvEquips.Items[i].SubItems.Add(tempPayout[i].EquipSupplier);
lsvEquips.Items[i].SubItems.Add(tempPayout[i].EquipBackup);
lsvEquips.Items[i].SubItems.Add(tempPayout[i].EquipSellers);
lsvEquips.Items[i].SubItems.Add(tempPayout[i].EquipProfit.ToString());
lsvEquips.Items[i].SubItems.Add(tempPayout[i].EquipCommision.ToString());
switch (tempPayout[i].EquipPayment)
{
case 0:
lsvEquips.Items[i].SubItems.Add("现金支付");
break;
case 1:
lsvEquips.Items[i].SubItems.Add("刷卡支付");
break;
case 2:
lsvEquips.Items[i].SubItems.Add("欠款支付");
break;
case 3:
lsvEquips.Items[i].SubItems.Add("支付宝");
break;
}
lsvEquips.Items[i].SubItems.Add(tempPayout[i].EquipBuyer);
Application.DoEvents();
}
isBusy.Visible = false;
}
private void cmdView_Click(object sender, EventArgs e)
{
if (cmbSellers.SelectedIndex == -1)
{
MessageBox.Show(Resources.frmCommision_cmdView_Click_必须选择一个销售人员再进行查看_, Application.ProductName,
MessageBoxButtons.OK);
return;
}
if (MysqlControl.ReadSellerPosition(cmbSellers.Text) != "销售" &&
MysqlControl.ReadSellerPosition(cmbSellers.Text) != "店长")
{
MessageBox.Show(Resources.frmCommision_cmdView_Click_非销售人员或店员没有提成_, Application.ProductName,
MessageBoxButtons.OK);
return;
}
isBusy.Visible = true;
cmdView.Enabled = false;
cmbSellers.Enabled = false;
lsvCommision.Items.Clear();
txtPhoneCommision.Text = Resources.frmCommision_cmdView_Click__0;
txtPhoneProfit.Text = Resources.frmCommision_cmdView_Click__0;
sHasBX = 0;
//sHasEquip = 0;
for (int i = 0; i < mCommision.Length; i++)
{
mCommision[i] = 0;
}
for (int i = 0; i < mProfit.Length; i++)
{
mProfit[i] = 0;
}
if (cmbSellers.SelectedIndex != -1)
{
DelegateReadCommision dn = MysqlControl.ReadPhoneSell;
IAsyncResult iar = dn.BeginInvoke(cmbSellers.Text,
dtpMonth.Value.Year +
dtpMonth.Value.Month.ToString().PadLeft
(2, '0'), null, null);
while (iar.IsCompleted == false)
{
Application.DoEvents();
}
MysqlController.LXSellPhone[] tempPhones = dn.EndInvoke(iar);
int j = 0;
if (tempPhones != null)
{
for (int i = 0; i < tempPhones.Length; i++)
{
if (tempPhones[i].PhoneIMEI == null)
{
continue;
}
lsvCommision.Items.Add(tempPhones[i].PhoneDate);
lsvCommision.Items[j].SubItems.Add(Brands[tempPhones[i].PhoneBrandid]);
lsvCommision.Items[j].SubItems.Add(tempPhones[i].PhoneName);
lsvCommision.Items[j].SubItems.Add(tempPhones[i].PhoneIMEI);
/*
* lsvCommision.Items[j].SubItems.Add(tempPhones[i].PhoneHasEquip ? "有" : "无");
* if (tempPhones[i].PhoneHasEquip)
* {
* sHasEquip = sHasEquip + 1;
* }
*/
lsvCommision.Items[j].SubItems.Add(tempPhones[i].PhonePrice.ToString());
lsvCommision.Items[j].SubItems.Add(tempPhones[i].PhoneRealprice.ToString());
lsvCommision.Items[j].SubItems.Add(tempPhones[i].PhoneProfit.ToString());
lsvCommision.Items[j].SubItems.Add(tempPhones[i].PhoneCommision.ToString());
lsvCommision.Items[j].SubItems.Add(tempPhones[i].PhoneWarranty ? "有" : "无");
if (tempPhones[i].PhoneWarranty)
{
sHasBX = sHasBX + 1;
}
switch (tempPhones[i].PhoneWarrantyType)
{
case 0:
lsvCommision.Items[j].SubItems.Add("软件保修");
break;
case 1:
lsvCommision.Items[j].SubItems.Add("软硬全保");
break;
case 2:
lsvCommision.Items[j].SubItems.Add("延长保修");
break;
case 3:
lsvCommision.Items[j].SubItems.Add("无敌保修");
break;
}
switch (tempPhones[i].PhoneWarrantyDuration)
{
case 0:
lsvCommision.Items[j].SubItems.Add("一年");
break;
case 1:
lsvCommision.Items[j].SubItems.Add("两年");
break;
case 2:
lsvCommision.Items[j].SubItems.Add("三年");
break;
case 3:
lsvCommision.Items[j].SubItems.Add("终身");
break;
}
j++;
txtPhoneProfit.Text =
Math.Round(double.Parse(txtPhoneProfit.Text) + tempPhones[i].PhoneProfit, 2).ToString();
txtPhoneCommision.Text =
Math.Round(double.Parse(txtPhoneCommision.Text) + tempPhones[i].PhoneCommision, 2).ToString();
mCommision[int.Parse(tempPhones[i].PhoneDate.Substring(6, 2))] =
Math.Round(mCommision[int.Parse(tempPhones[i].PhoneDate.Substring(6, 2))] +
tempPhones[i].PhoneCommision, 2);
mProfit[int.Parse(tempPhones[i].PhoneDate.Substring(6, 2))] =
Math.Round(mProfit[int.Parse(tempPhones[i].PhoneDate.Substring(6, 2))] +
tempPhones[i].PhoneProfit, 2);
Application.DoEvents();
}
//txtEquip.Text = (sHasEquip/(double) j).ToString("p");
txtBX.Text = (sHasBX / (double)j).ToString("p");
//这里填充配件销售
DelegateReadSoldEquip dn1 = MysqlControl.ReadSoldEquip;
IAsyncResult iar1 = dn1.BeginInvoke(dtpMonth.Value.Year +
dtpMonth.Value.Month.ToString().
PadLeft
(2, '0'), null, null);
while (iar1.IsCompleted == false)
{
Application.DoEvents();
}
MysqlController.LXEquip[] tempPayout = dn1.EndInvoke(iar1);
lsvEquips.Items.Clear();
if (tempPayout == null)
{
return;
}
if (tempPayout.Length <= 0)
{
return;
}
j = 0;
for (int i = 0; i < tempPayout.Length; i++)
{
if (string.IsNullOrEmpty(tempPayout[i].EquipDate))
{
continue;
}
if (tempPayout[i].EquipSellers != cmbSellers.Text)
{
continue;
}
lsvEquips.Items.Add(tempPayout[i].EquipID.ToString());
lsvEquips.Items[j].SubItems.Add(tempPayout[i].EquipDate);
lsvEquips.Items[j].SubItems.Add(tempPayout[i].EquipName);
lsvEquips.Items[j].SubItems.Add(tempPayout[i].EquipPrice.ToString());
lsvEquips.Items[j].SubItems.Add(tempPayout[i].EquipRealPrice.ToString());
lsvEquips.Items[j].SubItems.Add(tempPayout[i].EquipSupplier);
lsvEquips.Items[j].SubItems.Add(tempPayout[i].EquipBackup);
lsvEquips.Items[j].SubItems.Add(cmbSellers.Text);
lsvEquips.Items[j].SubItems.Add(tempPayout[i].EquipProfit.ToString());
lsvEquips.Items[j].SubItems.Add(tempPayout[i].EquipCommision.ToString());
txtEquipProfit.Text =
(int.Parse(txtEquipProfit.Text) + tempPayout[i].EquipProfit).ToString();
txtEquipCommision.Text =
(int.Parse(txtEquipCommision.Text) + tempPayout[i].EquipCommision).ToString();
j++;
Application.DoEvents();
}
//这里填充返收销售
DelegateReadRefundPhone dn2 = MysqlControl.ReadRefundPhone;
IAsyncResult iar2 = dn2.BeginInvoke(dtpMonth.Value.Year +
dtpMonth.Value.Month.ToString().PadLeft
(2, '0'), null, null);
while (iar2.IsCompleted == false)
{
Application.DoEvents();
}
MysqlController.RefundPhone[] tempRefundPhone = dn2.EndInvoke(iar2);
lsvPhones.Items.Clear();
j = 0;
if (tempRefundPhone != null)
{
if (tempRefundPhone.Length > 0)
{
for (int i = 0; i < tempRefundPhone.Length; i++)
{
if (string.IsNullOrEmpty(tempRefundPhone[i].RefundDate))
{
continue;
}
if (!tempRefundPhone[i].RefundIsFix)
{
continue;
}
if (tempRefundPhone[i].RefundFixSeller != cmbSellers.Text)
{
continue;
}
lsvPhones.Items.Add(tempRefundPhone[i].RefundID.ToString());
lsvPhones.Items[j].SubItems.Add(tempRefundPhone[i].RefundDate);
lsvPhones.Items[j].SubItems.Add(tempRefundPhone[i].RefundName);
lsvPhones.Items[j].SubItems.Add(tempRefundPhone[i].RefundPrice.ToString());
lsvPhones.Items[j].SubItems.Add(cmbSellers.Text);
lsvPhones.Items[j].SubItems.Add(tempRefundPhone[i].RefundIMEI);
lsvPhones.Items[j].SubItems.Add(tempRefundPhone[i].RefundBackup);
lsvPhones.Items[j].SubItems.Add(
tempRefundPhone[i].RefundRepairPrice.ToString());
lsvPhones.Items[j].SubItems.Add("已出售");
lsvPhones.Items[j].SubItems.Add(tempRefundPhone[i].RefundFixPrice.ToString());
txtBinPhoneProfit.Text =
(int.Parse(txtBinPhoneProfit.Text) + tempRefundPhone[i].RefundFixProfit)
.ToString();
txtBinPhoneCommision.Text =
(int.Parse(txtBinPhoneCommision.Text) +
tempRefundPhone[i].RefundFixCommision).ToString();
j++;
Application.DoEvents();
}
}
}
txtProfit.Text =
(int.Parse(txtPhoneProfit.Text) + int.Parse(txtEquipProfit.Text) +
int.Parse(txtBinPhoneProfit.Text)).ToString();
txtCommision.Text =
(int.Parse(txtPhoneCommision.Text) + int.Parse(txtEquipCommision.Text) +
int.Parse(txtBinPhoneCommision.Text)).ToString();
//这里填充图表
RefreshChart();
}
else
{
MessageBox.Show(Resources.frmCommision_cmdView_Click_查询提成失败_, Application.ProductName,
MessageBoxButtons.OK);
}
}
else
{
isBusy.Visible = false;
cmbSellers.Enabled = true;
cmdView.Enabled = true;
return;
}
isBusy.Visible = false;
cmbSellers.Enabled = true;
cmdView.Enabled = true;
}
private void frmProfit_Shown(object sender, EventArgs e)
{
isBusy.Visible = true;
#region 数据准备
double TPrice = 0;
double YPrice = 0;
double AllPrice = 0;
for (int i = 0; i < tempPrice.Length; i++)
{
tempPrice[i] = 0;
}
cmdBrand.Items.Clear();
DelegateManufacturer dn = MysqlControl.Manufacturer;
IAsyncResult iar = dn.BeginInvoke(null, null);
while (iar.IsCompleted == false)
{
Application.DoEvents();
}
string[] Tempstr = dn.EndInvoke(iar);
if (Tempstr != null)
{
for (int i = 0; i < Tempstr.Length; i++)
{
if (Tempstr[i] != null && Tempstr[i] != "")
{
cmdBrand.Items.Add(Tempstr[i]);
}
}
}
else
{
MessageBox.Show(Resources.frmProfit_frmProfit_Load_下载厂商列表失败_, Application.ProductName,
MessageBoxButtons.OK);
}
#endregion
#region 请求手机销售
DelegateReadPhoneSell dnrp = MysqlControl.ReadPhoneSell;
IAsyncResult iarrp = dnrp.BeginInvoke(DateTime.Now.Year + DateTime.Now.Month.ToString().PadLeft(2, '0'),
null, null);
while (iarrp.IsCompleted == false)
{
Application.DoEvents();
}
MysqlController.LXSellPhone[] tempPhones = dnrp.EndInvoke(iarrp);
if (tempPhones != null)
{
for (int i = 0; i < tempPhones.Length; i++)
{
if (tempPhones[i].PhoneIMEI == null)
{
continue;
}
//先算今天,再算昨天,最后算总价格
if (tempPhones[i].PhoneDate.Substring(6, 2) ==
DateTime.Now.Day.ToString().PadLeft(2, '0'))
{
//if (tempPhones[i].PhonePayment == 0)
//{
TPrice = Math.Round(TPrice + tempPhones[i].PhonePrice, 2);
//}
txtTProfit.Text =
Math.Round(double.Parse(txtTProfit.Text) + tempPhones[i].PhoneProfit, 2).ToString();
txtTCommision.Text =
Math.Round(double.Parse(txtTCommision.Text) + tempPhones[i].PhoneCommision, 2).ToString();
}
if (tempPhones[i].PhoneDate.Substring(6, 2) ==
DateTime.Now.AddDays(-1).Day.ToString().PadLeft(2, '0'))
{
//if (tempPhones[i].PhonePayment == 0)
//{
YPrice = Math.Round(YPrice + tempPhones[i].PhonePrice, 2);
//}
txtYProfit.Text =
Math.Round(double.Parse(txtYProfit.Text) + tempPhones[i].PhoneProfit, 2).ToString();
txtYCommision.Text =
Math.Round(double.Parse(txtYCommision.Text) + tempPhones[i].PhoneCommision, 2).ToString();
}
//if (tempPhones[i].PhonePayment == 0)
//{
AllPrice = Math.Round(AllPrice + tempPhones[i].PhonePrice, 2);
//}
tempPrice[tempPhones[i].PhoneBrandid] =
Math.Round(tempPrice[tempPhones[i].PhoneBrandid] + tempPhones[i].PhoneProfit, 2);
tempCommision[tempPhones[i].PhoneBrandid] =
Math.Round(tempCommision[tempPhones[i].PhoneBrandid] + tempPhones[i].PhoneCommision, 2);
txtProfit.Text = Math.Round(double.Parse(txtProfit.Text) + tempPhones[i].PhoneProfit, 2).ToString();
txtCommision.Text =
Math.Round(double.Parse(txtCommision.Text) + tempPhones[i].PhoneCommision, 2).ToString();
Application.DoEvents();
}
}
else
{
MessageBox.Show(Resources.frmProfit_frmProfit_Load_读取利润及提成错误_, Application.ProductName,
MessageBoxButtons.OK);
}
#endregion
#region 请求配件销售
DelegateReadSoldEquip dnse = MysqlControl.ReadSoldEquip;
IAsyncResult iarse = dnse.BeginInvoke(DateTime.Now.Year + DateTime.Now.Month.ToString().PadLeft(2, '0'),
null, null);
while (iarse.IsCompleted == false)
{
Application.DoEvents();
}
MysqlController.LXEquip[] tempEquipSell = dnse.EndInvoke(iarse);
if (tempEquipSell != null)
{
if (tempEquipSell.Length <= 0)
{
return;
}
for (int i = 0; i < tempEquipSell.Length; i++)
{
if (string.IsNullOrEmpty(tempEquipSell[i].EquipDate))
{
continue;
}
if (tempEquipSell[i].EquipDate.Substring(6, 2) ==
DateTime.Now.Day.ToString().PadLeft(2, '0'))
{
//if (tempEquipSell[i].EquipPayment == 0)
//{
TPrice = Math.Round(TPrice + tempEquipSell[i].EquipPrice, 2);
//}
txtTEProfit.Text =
Math.Round(double.Parse(txtTEProfit.Text) + tempEquipSell[i].EquipProfit, 2).ToString();
txtTCommision.Text = Math.Round(double.Parse(txtTCommision.Text) +
tempEquipSell[i].EquipCommision, 2).ToString();
}
if (tempEquipSell[i].EquipDate.Substring(6, 2) ==
DateTime.Now.AddDays(-1).Day.ToString().PadLeft(2, '0'))
{
//if (tempEquipSell[i].EquipPayment == 0)
//{
YPrice = Math.Round(YPrice + tempEquipSell[i].EquipPrice, 2);
//}
txtYEProfit.Text =
Math.Round(double.Parse(txtYEProfit.Text) + tempEquipSell[i].EquipProfit, 2).ToString();
txtYCommision.Text =
Math.Round(double.Parse(txtYCommision.Text) + tempEquipSell[i].EquipCommision, 2).ToString();
}
//if (tempEquipSell[i].EquipPayment == 0)
//{
AllPrice = Math.Round(AllPrice + tempEquipSell[i].EquipPrice, 2);
//}
txtEProfit.Text =
Math.Round(double.Parse(txtEProfit.Text) + tempEquipSell[i].EquipProfit, 2).ToString();
txtCommision.Text =
Math.Round(double.Parse(txtCommision.Text) + tempEquipSell[i].EquipCommision, 2).ToString();
Application.DoEvents();
}
}
else
{
MessageBox.Show(Resources.frmProfit_frmProfit_Load_读取利润及提成错误_, Application.ProductName,
MessageBoxButtons.OK);
}
#endregion
#region 请求返收销售
DelegateReadRefundPhone dnrrp = MysqlControl.ReadRefundPhone;
IAsyncResult iarrrp = dnrrp.BeginInvoke(DateTime.Now.Year + DateTime.Now.Month.ToString().PadLeft(2, '0'),
null, null);
while (iarrrp.IsCompleted == false)
{
Application.DoEvents();
}
MysqlController.RefundPhone[] tempBinPhone = dnrrp.EndInvoke(iarrrp);
if (tempBinPhone != null)
{
if (tempBinPhone.Length > 0)
{
for (int i = 0; i < tempBinPhone.Length; i++)
{
if (string.IsNullOrEmpty(tempBinPhone[i].RefundDate))
{
continue;
}
//这里求卖出的机器,注意 现金流的操作只限制于卖价 收取费用在下面结算
if (tempBinPhone[i].RefundIsFix)
{
if (tempBinPhone[i].RefundFixDate.Substring(6, 2) ==
DateTime.Now.Day.ToString().PadLeft(2, '0'))
{
//if (tempBinPhone[i].RefundFixType == 0)
//{
TPrice = Math.Round(TPrice + tempBinPhone[i].RefundFixPrice, 2);
//}
txtTBPProfit.Text =
Math.Round(double.Parse(txtTBPProfit.Text) + tempBinPhone[i].RefundFixProfit, 2).
ToString();
txtTCommision.Text = Math.Round(double.Parse(txtTCommision.Text) +
tempBinPhone[i].RefundFixCommision, 2).ToString();
}
if (tempBinPhone[i].RefundFixDate.Substring(6, 2) ==
DateTime.Now.AddDays(-1).Day.ToString().PadLeft(2, '0'))
{
//if (tempBinPhone[i].RefundFixType == 0)
//{
YPrice = Math.Round(YPrice + tempBinPhone[i].RefundFixPrice, 2);
//}
txtYBPProfit.Text =
Math.Round(double.Parse(txtYEProfit.Text) + tempBinPhone[i].RefundFixProfit, 2).
ToString();
txtYCommision.Text =
Math.Round(double.Parse(txtYCommision.Text) + tempBinPhone[i].RefundFixCommision, 2)
.ToString();
}
//if (tempBinPhone[i].RefundFixType == 0)
//{
AllPrice = Math.Round(AllPrice + tempBinPhone[i].RefundFixPrice, 2);
//}
txtBPProfit.Text =
Math.Round(double.Parse(txtBPProfit.Text) + tempBinPhone[i].RefundFixProfit, 2).ToString
();
txtCommision.Text =
Math.Round(double.Parse(txtCommision.Text) + tempBinPhone[i].RefundFixCommision, 2).
ToString();
}
//没有卖出和卖出的共同进行成本核算
if (tempBinPhone[i].RefundDate.Substring(6, 2) ==
DateTime.Now.Day.ToString().PadLeft(2, '0'))
{
if (tempBinPhone[i].RefundRefundType == 0)
{
TPrice = Math.Round(TPrice - tempBinPhone[i].RefundPrice, 2);
TPrice = Math.Round(TPrice - tempBinPhone[i].RefundRepairPrice, 2);
}
}
if (tempBinPhone[i].RefundDate.Substring(6, 2) ==
DateTime.Now.AddDays(-1).Day.ToString().PadLeft(2, '0'))
{
if (tempBinPhone[i].RefundRefundType == 0)
{
YPrice = Math.Round(YPrice - tempBinPhone[i].RefundPrice, 2);
YPrice = Math.Round(YPrice - tempBinPhone[i].RefundRepairPrice, 2);
}
}
AllPrice = Math.Round(AllPrice - tempBinPhone[i].RefundPrice, 2);
AllPrice = Math.Round(AllPrice - tempBinPhone[i].RefundRepairPrice, 2);
Application.DoEvents();
}
}
}
else
{
MessageBox.Show(Resources.frmProfit_frmProfit_Load_读取利润及提成错误_, Application.ProductName,
MessageBoxButtons.OK);
}
/////////////////////////////////////////////////////////////////////////////////////////
GetBinPhonesByFixDateDelegate dngbpf = MysqlControl.ReadRefundPhoneByFixDate;
IAsyncResult iargbpf = dngbpf.BeginInvoke(DateTime.Now.Year + DateTime.Now.Month.ToString().PadLeft(2, '0'),
null, null);
while (iargbpf.IsCompleted == false)
{
Application.DoEvents();
}
MysqlController.RefundPhone[] tempBinPhoneByFix = dngbpf.EndInvoke(iargbpf);
if (tempBinPhoneByFix != null)
{
if (tempBinPhoneByFix.Length > 0)
{
for (int i = 0; i < tempBinPhoneByFix.Length; i++)
{
if (string.IsNullOrEmpty(tempBinPhoneByFix[i].RefundDate))
{
continue;
}
//这里求卖出的机器,注意 现金流的操作只限制于卖价 收取费用在下面结算
if (tempBinPhoneByFix[i].RefundIsFix)
{
if (tempBinPhoneByFix[i].RefundFixDate.Substring(6, 2) ==
DateTime.Now.Day.ToString().PadLeft(2, '0'))
{
//if (tempBinPhone[i].RefundFixType == 0)
//{
TPrice = Math.Round(TPrice + tempBinPhoneByFix[i].RefundFixPrice, 2);
//}
txtTBPProfit.Text =
Math.Round(double.Parse(txtTBPProfit.Text) + tempBinPhoneByFix[i].RefundFixProfit, 2)
.
ToString();
txtTCommision.Text = Math.Round(double.Parse(txtTCommision.Text) +
tempBinPhoneByFix[i].RefundFixCommision, 2).ToString();
}
if (tempBinPhoneByFix[i].RefundFixDate.Substring(6, 2) ==
DateTime.Now.AddDays(-1).Day.ToString().PadLeft(2, '0'))
{
//if (tempBinPhone[i].RefundFixType == 0)
//{
YPrice = Math.Round(YPrice + tempBinPhoneByFix[i].RefundFixPrice, 2);
//}
txtYBPProfit.Text =
Math.Round(double.Parse(txtYEProfit.Text) + tempBinPhoneByFix[i].RefundFixProfit, 2)
.
ToString();
txtYCommision.Text =
Math.Round(
double.Parse(txtYCommision.Text) + tempBinPhoneByFix[i].RefundFixCommision, 2)
.ToString();
}
//if (tempBinPhone[i].RefundFixType == 0)
//{
AllPrice = Math.Round(AllPrice + tempBinPhoneByFix[i].RefundFixPrice, 2);
//}
txtBPProfit.Text =
Math.Round(double.Parse(txtBPProfit.Text) + tempBinPhoneByFix[i].RefundFixProfit, 2).
ToString
();
txtCommision.Text =
Math.Round(double.Parse(txtCommision.Text) + tempBinPhoneByFix[i].RefundFixCommision, 2)
.
ToString();
}
//没有卖出和卖出的共同进行成本核算
if (tempBinPhoneByFix[i].RefundDate.Substring(6, 2) ==
DateTime.Now.Day.ToString().PadLeft(2, '0'))
{
if (tempBinPhoneByFix[i].RefundRefundType == 0)
{
TPrice = Math.Round(TPrice - tempBinPhoneByFix[i].RefundPrice, 2);
TPrice = Math.Round(TPrice - tempBinPhoneByFix[i].RefundRepairPrice, 2);
}
}
if (tempBinPhoneByFix[i].RefundDate.Substring(6, 2) ==
DateTime.Now.AddDays(-1).Day.ToString().PadLeft(2, '0'))
{
if (tempBinPhoneByFix[i].RefundRefundType == 0)
{
YPrice = Math.Round(YPrice - tempBinPhoneByFix[i].RefundPrice, 2);
YPrice = Math.Round(YPrice - tempBinPhoneByFix[i].RefundRepairPrice, 2);
}
}
AllPrice = Math.Round(AllPrice - tempBinPhoneByFix[i].RefundPrice, 2);
AllPrice = Math.Round(AllPrice - tempBinPhoneByFix[i].RefundRepairPrice, 2);
Application.DoEvents();
}
}
}
else
{
MessageBox.Show(Resources.frmProfit_frmProfit_Load_读取利润及提成错误_, Application.ProductName,
MessageBoxButtons.OK);
}
#endregion
#region 请求客户欠款
DelegateReadCustomDebt dncd = MysqlControl.ReadCustomDebt;
IAsyncResult iarcd = dncd.BeginInvoke(DateTime.Now.Year + DateTime.Now.Month.ToString().PadLeft(2, '0'),
null, null);
while (iarcd.IsCompleted == false)
{
Application.DoEvents();
}
MysqlController.LXCustomDebt[] tempCustomDebt = dncd.EndInvoke(iarcd);
if (tempCustomDebt != null)
{
if (tempCustomDebt.Length <= 0)
{
return;
}
for (int i = 0; i < tempCustomDebt.Length; i++)
{
if (string.IsNullOrEmpty(tempCustomDebt[i].DebtDate))
{
continue;
}
if (tempCustomDebt[i].DebtisFix) //已经结款
{
//根据结款时间 得出费用
if (tempCustomDebt[i].DebtFixDate.Substring(6, 2) ==
DateTime.Now.Day.ToString().PadLeft(2, '0'))
{
if (tempCustomDebt[i].DebtFixType == 1) //类型1为现金
{
if (tempCustomDebt[i].DebtisInCircle)
{
TPrice = Math.Round(TPrice + tempCustomDebt[i].DebtPrice, 2);
}
}
txtTCustomDebt.Text =
Math.Round(double.Parse(txtTCustomDebt.Text) + tempCustomDebt[i].DebtPrice, 2).ToString();
}
if (tempCustomDebt[i].DebtFixDate.Substring(6, 2) ==
DateTime.Now.AddDays(-1).Day.ToString().PadLeft(2, '0'))
{
if (tempCustomDebt[i].DebtFixType == 1)
{
if (tempCustomDebt[i].DebtisInCircle)
{
YPrice = Math.Round(YPrice + tempCustomDebt[i].DebtPrice, 2);
}
}
txtYCustomDebt.Text =
Math.Round(double.Parse(txtYCustomDebt.Text) + tempCustomDebt[i].DebtPrice, 2).ToString();
}
if (tempCustomDebt[i].DebtFixType == 1)
{
if (tempCustomDebt[i].DebtisInCircle)
{
AllPrice = Math.Round(AllPrice + tempCustomDebt[i].DebtPrice, 2);
}
}
txtBPProfit.Text =
Math.Round(double.Parse(txtCustomDebt.Text) + tempCustomDebt[i].DebtPrice, 2).ToString();
}
else //未结帐
{
//根据欠款时间决定
if (tempCustomDebt[i].DebtDate.Substring(6, 2) ==
DateTime.Now.Day.ToString().PadLeft(2, '0'))
{
if (tempCustomDebt[i].DebtisInCircle)
{
TPrice = Math.Round(TPrice - tempCustomDebt[i].DebtUnFixPrice, 2);
}
}
if (tempCustomDebt[i].DebtDate.Substring(6, 2) ==
DateTime.Now.AddDays(-1).Day.ToString().PadLeft(2, '0'))
{
if (tempCustomDebt[i].DebtisInCircle)
{
YPrice = Math.Round(YPrice - tempCustomDebt[i].DebtUnFixPrice, 2);
}
}
if (tempCustomDebt[i].DebtisInCircle)
{
AllPrice = Math.Round(AllPrice - tempCustomDebt[i].DebtUnFixPrice, 2);
}
}
Application.DoEvents();
}
}
else
{
MessageBox.Show(Resources.frmProfit_frmProfit_Load_读取利润及提成错误_, Application.ProductName,
MessageBoxButtons.OK);
}
#endregion
#region 请求市场欠款
DelegateReadMarketDebt dnmd = MysqlControl.ReadMarketDebt;
IAsyncResult iarmd = dnmd.BeginInvoke(DateTime.Now.Year + DateTime.Now.Month.ToString().PadLeft(2, '0'),
null, null);
while (iarmd.IsCompleted == false)
{
Application.DoEvents();
}
MysqlController.LXMarketDebt[] tempMarketDebt = dnmd.EndInvoke(iarmd);
if (tempMarketDebt != null)
{
if (tempMarketDebt.Length <= 0)
{
return;
}
for (int i = 0; i < tempMarketDebt.Length; i++)
{
if (string.IsNullOrEmpty(tempMarketDebt[i].DebtDate))
{
continue;
}
if (tempMarketDebt[i].DebtisFix)
{
if (tempMarketDebt[i].DebtFixDate.Substring(6, 2) ==
DateTime.Now.Day.ToString().PadLeft(2, '0'))
{
if (tempMarketDebt[i].DebtisCashCircle)
{
TPrice = Math.Round(TPrice - tempMarketDebt[i].DebtPrice, 2);
}
txtTMarketDebt.Text =
Math.Round(double.Parse(txtTMarketDebt.Text) + tempMarketDebt[i].DebtPrice, 2).ToString();
}
if (tempMarketDebt[i].DebtFixDate.Substring(6, 2) ==
DateTime.Now.AddDays(-1).Day.ToString().PadLeft(2, '0'))
{
if (tempMarketDebt[i].DebtisCashCircle)
{
YPrice = Math.Round(YPrice - tempMarketDebt[i].DebtPrice, 2);
}
txtYMarketDebt.Text =
Math.Round(double.Parse(txtYMarketDebt.Text) + tempMarketDebt[i].DebtPrice, 2).ToString();
}
if (tempMarketDebt[i].DebtisCashCircle)
{
AllPrice = Math.Round(AllPrice - tempMarketDebt[i].DebtPrice, 2);
}
txtMarketDebt.Text =
Math.Round(double.Parse(txtMarketDebt.Text) + tempMarketDebt[i].DebtPrice, 2).ToString();
}
else //清算未结帐的 那么这意味着钱是多出来的
{
if (tempMarketDebt[i].DebtDate.Substring(6, 2) ==
DateTime.Now.Day.ToString().PadLeft(2, '0'))
{
if (tempMarketDebt[i].DebtisCashCircle)
{
TPrice = Math.Round(TPrice + tempMarketDebt[i].DebtPrice, 2);
}
}
if (tempMarketDebt[i].DebtDate.Substring(6, 2) ==
DateTime.Now.AddDays(-1).Day.ToString().PadLeft(2, '0'))
{
if (tempMarketDebt[i].DebtisCashCircle)
{
YPrice = Math.Round(YPrice + tempMarketDebt[i].DebtPrice, 2);
}
}
if (tempMarketDebt[i].DebtisCashCircle)
{
AllPrice = Math.Round(AllPrice + tempMarketDebt[i].DebtPrice, 2);
}
}
Application.DoEvents();
}
}
else
{
MessageBox.Show(Resources.frmProfit_frmProfit_Load_读取利润及提成错误_, Application.ProductName,
MessageBoxButtons.OK);
}
#endregion
#region 请求固定支出
DelegateReadPayout dnpayout1 = MysqlControl.ReadPayout;
IAsyncResult iarpayout1 =
dnpayout1.BeginInvoke(DateTime.Today.Year + DateTime.Today.Month.ToString().PadLeft(2, '0') +
DateTime.Today.Day.ToString().PadLeft(2, '0'), null, null);
while (iarpayout1.IsCompleted == false)
{
Application.DoEvents();
}
MysqlController.Payout[] tempTPayout = dnpayout1.EndInvoke(iarpayout1);
DelegateReadPayout dnpayout2 = MysqlControl.ReadPayout;
IAsyncResult iarpayout2 =
dnpayout2.BeginInvoke(DateTime.Today.Year + DateTime.Today.Month.ToString().PadLeft(2, '0') +
DateTime.Today.AddDays(-1).Day.ToString().PadLeft(2, '0'), null, null);
while (iarpayout2.IsCompleted == false)
{
Application.DoEvents();
}
MysqlController.Payout[] tempYPayout = dnpayout2.EndInvoke(iarpayout2);
DelegateReadPayout dnpayout3 = MysqlControl.ReadPayout;
IAsyncResult iarpayout3 =
dnpayout3.BeginInvoke(DateTime.Today.Year + DateTime.Today.Month.ToString().PadLeft(2, '0'), null, null);
while (iarpayout3.IsCompleted == false)
{
Application.DoEvents();
}
MysqlController.Payout[] tempPayout = dnpayout3.EndInvoke(iarpayout3);
if (tempTPayout != null && tempYPayout != null && tempPayout != null)
{
for (int i = 0; i < tempTPayout.Length; i++)
{
if (tempTPayout[i].PayoutPrice != null)
{
if (tempTPayout[i].PayoutInCase)
{
txtTPayout.Text =
Math.Round(double.Parse(txtTPayout.Text) + double.Parse(tempTPayout[i].PayoutPrice), 2).
ToString();
}
}
Application.DoEvents();
}
for (int i = 0; i < tempYPayout.Length; i++)
{
if (tempYPayout[i].PayoutPrice != null)
{
if (tempYPayout[i].PayoutInCase)
{
txtYPayout.Text =
Math.Round(double.Parse(txtYPayout.Text) + double.Parse(tempYPayout[i].PayoutPrice), 2).
ToString();
}
}
Application.DoEvents();
}
for (int i = 0; i < tempPayout.Length; i++)
{
if (tempPayout[i].PayoutPrice != null)
{
if (tempPayout[i].PayoutInCase)
{
txtPayout.Text =
Math.Round(double.Parse(txtPayout.Text) + double.Parse(tempPayout[i].PayoutPrice), 2).
ToString();
}
}
Application.DoEvents();
}
}
else
{
MessageBox.Show(Resources.frmProfit_frmProfit_Load_读取固定支出错误_, Application.ProductName,
MessageBoxButtons.OK);
}
#endregion
#region 计算真实利润
txtTTrueProfit.Text =
Math.Round(double.Parse(txtTProfit.Text) + double.Parse(txtTEProfit.Text), 2).ToString();
txtTTrueProfit.Text =
Math.Round(double.Parse(txtTTrueProfit.Text) + double.Parse(txtTBPProfit.Text), 2).ToString();
txtTTrueProfit.Text =
Math.Round(double.Parse(txtTTrueProfit.Text) - double.Parse(txtTCommision.Text), 2).ToString();
txtTTrueProfit.Text =
Math.Round(double.Parse(txtTTrueProfit.Text) - double.Parse(txtTPayout.Text), 2).ToString();
//
txtYTrueProfit.Text =
Math.Round(double.Parse(txtYProfit.Text) + double.Parse(txtYEProfit.Text), 2).ToString();
txtYTrueProfit.Text =
Math.Round(double.Parse(txtYTrueProfit.Text) + double.Parse(txtYBPProfit.Text), 2).ToString();
txtYTrueProfit.Text =
Math.Round(double.Parse(txtYTrueProfit.Text) - double.Parse(txtYCommision.Text), 2).ToString();
txtYTrueProfit.Text =
Math.Round(double.Parse(txtYTrueProfit.Text) - double.Parse(txtYPayout.Text), 2).ToString();
/////////////////
txtTrueProfit.Text =
Math.Round(double.Parse(txtProfit.Text) + double.Parse(txtEProfit.Text), 2).ToString();
txtTrueProfit.Text =
Math.Round(double.Parse(txtTrueProfit.Text) + double.Parse(txtBPProfit.Text), 2).ToString();
txtTrueProfit.Text =
Math.Round(double.Parse(txtTrueProfit.Text) - double.Parse(txtCommision.Text), 2).ToString();
txtTrueProfit.Text =
Math.Round(double.Parse(txtTrueProfit.Text) - double.Parse(txtPayout.Text), 2).ToString();
#endregion
#region 计算店铺剩余金额
txtTShopValue.Text =
Math.Round(TPrice - double.Parse(txtTPayout.Text), 2).
ToString();
////
txtYShopValue.Text =
Math.Round(YPrice - double.Parse(txtYPayout.Text), 2).
ToString();
////
txtShopValue.Text =
Math.Round(AllPrice - double.Parse(txtPayout.Text), 2)
.ToString
();
#endregion
#region 填充数据到图表
chartBrand.Series.Clear();
chartBrand.ChartAreas.Clear();
var chartArea1 = new ChartArea {
Area3DStyle = { Enable3D = true, Light = LightStyle.Realistic }
};
chartArea1.AxisX.LabelStyle.FontColor = Color.FromArgb(((((220)))), ((((0)))), ((((0)))), ((((0)))));
chartArea1.AxisX.LineColor = Color.FromArgb(((((220)))), ((((0)))), ((((0)))), ((((0)))));
chartArea1.AxisX.MajorGrid.LineColor = Color.FromArgb(((((40)))), ((((0)))), ((((0)))), ((((0)))));
chartArea1.AxisX.MajorGrid.LineWidth = 2;
chartArea1.AxisX.MajorTickMark.LineColor = Color.FromArgb(((((100)))), ((((0)))), ((((0)))), ((((0)))));
chartArea1.AxisX.MinorGrid.LineColor = Color.FromArgb(((((70)))), ((((0)))), ((((0)))), ((((0)))));
chartArea1.AxisX.MinorTickMark.LineColor = Color.FromArgb(((((100)))), ((((0)))), ((((0)))), ((((0)))));
chartArea1.AxisX.MinorTickMark.Size = 2F;
chartArea1.AxisX2.LabelStyle.FontColor = Color.White;
chartArea1.AxisX2.LineColor = Color.White;
chartArea1.AxisX2.MajorGrid.LineColor = Color.FromArgb(((((150)))), ((((255)))), ((((255)))),
((((255)))));
chartArea1.AxisX2.MajorTickMark.LineColor = Color.White;
chartArea1.AxisX2.MinorGrid.LineColor = Color.FromArgb(((((100)))), ((((255)))), ((((255)))),
((((255)))));
chartArea1.AxisX2.MinorTickMark.LineColor = Color.White;
chartArea1.AxisY.LabelStyle.FontColor = Color.FromArgb(((((220)))), ((((0)))), ((((0)))), ((((0)))));
chartArea1.AxisY.LineColor = Color.FromArgb(((((220)))), ((((0)))), ((((0)))), ((((0)))));
chartArea1.AxisY.MajorGrid.LineColor = Color.FromArgb(((((40)))), ((((0)))), ((((0)))), ((((0)))));
chartArea1.AxisY.MajorGrid.LineWidth = 2;
chartArea1.AxisY.MajorTickMark.LineColor = Color.FromArgb(((((100)))), ((((0)))), ((((0)))), ((((0)))));
chartArea1.AxisY.MinorGrid.LineColor = Color.FromArgb(((((70)))), ((((0)))), ((((0)))), ((((0)))));
chartArea1.AxisY.MinorTickMark.LineColor = Color.FromArgb(((((100)))), ((((0)))), ((((0)))), ((((0)))));
chartArea1.AxisY.MinorTickMark.Size = 2F;
chartArea1.AxisY2.LabelStyle.FontColor = Color.White;
chartArea1.AxisY2.LineColor = Color.White;
chartArea1.AxisY2.MajorGrid.LineColor = Color.FromArgb(((((150)))), ((((255)))), ((((255)))),
((((255)))));
chartArea1.AxisY2.MajorTickMark.LineColor = Color.White;
chartArea1.AxisY2.MinorGrid.LineColor = Color.FromArgb(((((100)))), ((((255)))), ((((255)))),
((((255)))));
chartArea1.AxisY2.MinorTickMark.LineColor = Color.White;
chartArea1.BackColor = Color.White;
chartArea1.BackGradientEndColor = Color.AntiqueWhite;
chartArea1.BackGradientType = GradientType.TopBottom;
chartArea1.BorderColor = Color.FromArgb(((((50)))), ((((255)))), ((((255)))), ((((255)))));
chartArea1.BorderStyle = ChartDashStyle.Solid;
chartArea1.BorderWidth = 0;
chartArea1.Name = "Default";
chartBrand.ChartAreas.Add(chartArea1);
var SeriesBrand = new Series {
ChartType = "Pie", ShowLabelAsValue = true, SmartLabels = { Enabled = true }
};
for (int i = 0; i < cmdBrand.Items.Count; i++)
{
SeriesBrand.Points.AddXY(cmdBrand.Items[i].ToString(), tempPrice[i]);
Application.DoEvents();
}
chartBrand.Series.Add(SeriesBrand);
chartMoney.Series[0].Points.Add(int.Parse(txtProfit.Text));
chartMoney.Series[0].Points.Add(int.Parse(txtProfit.Text));
chartMoney.Series[0].Points.Add(int.Parse(txtProfit.Text));
chartMoney.Series[1].Points.Add(double.Parse(txtTProfit.Text));
chartMoney.Series[1].Points.Add(double.Parse(txtTProfit.Text));
chartMoney.Series[1].Points.Add(double.Parse(txtTProfit.Text));
chartMoney.Series[2].Points.Add(double.Parse(txtPayout.Text));
chartMoney.Series[2].Points.Add(double.Parse(txtPayout.Text));
chartMoney.Series[2].Points.Add(double.Parse(txtPayout.Text));
chartMoney.Series[3].Points.Add(int.Parse(txtCommision.Text));
chartMoney.Series[3].Points.Add(int.Parse(txtCommision.Text));
chartMoney.Series[3].Points.Add(int.Parse(txtCommision.Text));
chartMoney.Series[4].Points.Add(double.Parse(txtTrueProfit.Text));
chartMoney.Series[4].Points.Add(double.Parse(txtTrueProfit.Text));
chartMoney.Series[4].Points.Add(double.Parse(txtTrueProfit.Text));
#endregion
isBusy.Visible = false;
}