private void m_GetAndFillData()
{
Domain.m_lngGetOneDayData(this.LoginInfo.m_strEmpID, checkDate, out dtCheckOut);
#region 生成一个统计表
dtStatistics = new DataTable();
dtStatistics.Columns.Add("实收金额合计");
dtStatistics.Columns.Add("实收现金合计");
dtStatistics.Columns.Add("刷卡金额合计");
dtStatistics.Columns.Add("支票金额合计");
dtStatistics.Columns.Add("医保记账金额");
dtStatistics.Columns.Add("公费记账金额");
dtStatistics.Columns.Add("自费上缴金额");
dtStatistics.Columns.Add("开票金额");
dtStatistics.Columns.Add("退票金额合计");
dtStatistics.Columns.Add("恢复金额合计");
dtStatistics.Columns.Add("其它金额合计");
#endregion
#region 统计数据
DataRow StatisticsRow = dtStatistics.NewRow();
StatisticsRow["实收金额合计"] = 0.00;
StatisticsRow["实收现金合计"] = 0.00;
StatisticsRow["刷卡金额合计"] = 0.00;
StatisticsRow["支票金额合计"] = 0.00;
StatisticsRow["医保记账金额"] = 0.00;
StatisticsRow["公费记账金额"] = 0.00;
StatisticsRow["自费上缴金额"] = 0.00;
StatisticsRow["开票金额"] = 0.00;
StatisticsRow["退票金额合计"] = 0.00;
StatisticsRow["恢复金额合计"] = 0.00;
StatisticsRow["其它金额合计"] = 0.00;
if (dtCheckOut.Rows.Count > 0)
{
for (int i1 = 0; i1 < dtCheckOut.Rows.Count; i1++)
{
if (dtCheckOut.Rows[i1]["STATUS_INT"].ToString().Trim() == "1") //统计开票数,开票金额
{
StatisticsRow["开票金额"] = Convert.ToDouble(StatisticsRow["开票金额"].ToString()) + Convert.ToDouble(dtCheckOut.Rows[i1]["TOTALSUM_MNY"].ToString());
}
if (dtCheckOut.Rows[i1]["STATUS_INT"].ToString().Trim() == "2") //退票数,退票金额合计,所有的退票号
{
StatisticsRow["退票金额合计"] = Convert.ToDouble(StatisticsRow["退票金额合计"].ToString()) - Convert.ToDouble(dtCheckOut.Rows[i1]["TOTALSUM_MNY"].ToString());
}
if (dtCheckOut.Rows[i1]["STATUS_INT"].ToString().Trim() == "3") //恢复票数,恢复金额合计
{
StatisticsRow["恢复金额合计"] = Convert.ToDouble(StatisticsRow["恢复金额合计"].ToString()) + Convert.ToDouble(dtCheckOut.Rows[i1]["TOTALSUM_MNY"].ToString());
}
if (dtCheckOut.Rows[i1]["PAYTYPE_INT"].ToString().Trim() == "0") //统计现金合计
{
StatisticsRow["实收现金合计"] = Convert.ToDouble(StatisticsRow["实收现金合计"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["SBSUM_MNY"].ToString());
}
if (dtCheckOut.Rows[i1]["PAYTYPE_INT"].ToString().Trim() == "1") //刷卡合计
{
StatisticsRow["刷卡金额合计"] = Convert.ToDouble(StatisticsRow["刷卡金额合计"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["SBSUM_MNY"].ToString());
}
if (dtCheckOut.Rows[i1]["PAYTYPE_INT"].ToString().Trim() == "2") //支票
{
StatisticsRow["支票金额合计"] = Convert.ToDouble(StatisticsRow["支票金额合计"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["SBSUM_MNY"].ToString());
}
if (dtCheckOut.Rows[i1]["PAYTYPE_INT"].ToString().Trim() != "1" && dtCheckOut.Rows[i1]["PAYTYPE_INT"].ToString().Trim() != "2" && dtCheckOut.Rows[i1]["PAYTYPE_INT"].ToString().Trim() != "3" && dtCheckOut.Rows[i1]["PAYTYPE_INT"].ToString().Trim() != "0") //统计其它金额
{
StatisticsRow["其它金额合计"] = Convert.ToDouble(StatisticsRow["其它金额合计"].ToString()) + Convert.ToDouble(dtCheckOut.Rows[i1]["TOTALSUM_MNY"].ToString());
}
if (dtCheckOut.Rows[i1]["INTERNALFLAG_INT"].ToString().Trim() == "2") //医保记账金额及人次
{
StatisticsRow["医保记账金额"] = Convert.ToDouble(StatisticsRow["医保记账金额"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["ACCTSUM_MNY"].ToString());
}
if (dtCheckOut.Rows[i1]["INTERNALFLAG_INT"].ToString().Trim() == "1") //公费记账金额及人次
{
StatisticsRow["公费记账金额"] = Convert.ToDouble(StatisticsRow["公费记账金额"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["ACCTSUM_MNY"].ToString());
}
if (dtCheckOut.Rows[i1]["INTERNALFLAG_INT"].ToString().Trim() == "0") //自费上缴金额及人次
{
StatisticsRow["自费上缴金额"] = Convert.ToDouble(StatisticsRow["自费上缴金额"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["TOTALSUM_MNY"].ToString());
}
}
}
Double AvailabilityMoney = Convert.ToDouble(StatisticsRow["开票金额"].ToString().Trim()) - Convert.ToDouble(StatisticsRow["退票金额合计"].ToString().Trim()) + Convert.ToDouble(StatisticsRow["恢复金额合计"].ToString().Trim());
StatisticsRow["实收金额合计"] = AvailabilityMoney.ToString();
#endregion
listView1.Items.Clear();
string strMoney = clsMain.CurrencyToString(Math.Abs(float.Parse(StatisticsRow["实收金额合计"].ToString())));
label2.Text = strMoney + "(￥" + StatisticsRow["实收金额合计"].ToString() + ")";
ListViewItem addItem = new ListViewItem("￥" + StatisticsRow["实收现金合计"].ToString());
addItem.SubItems.Add("￥" + StatisticsRow["刷卡金额合计"].ToString());
addItem.SubItems.Add("￥" + StatisticsRow["支票金额合计"].ToString());
addItem.SubItems.Add("￥" + StatisticsRow["医保记账金额"].ToString());
addItem.SubItems.Add("￥" + StatisticsRow["公费记账金额"].ToString());
addItem.SubItems.Add("￥" + StatisticsRow["其它金额合计"].ToString());
listView1.Items.Add(addItem);
ArrayList arrList = new ArrayList();
clsMain.m_Detach(dtCheckOut, "INVOICENO_VCHR", out arrList);
ListViewItem newItem = null;
string temsun = "";
listView2.Items.Clear();
if (arrList.Count > 0)
{
temsun = arrList[0].ToString();
for (int i1 = 0; i1 < arrList.Count; i1++)
{
if (arrList[i1].ToString() == ",")
{
newItem = new ListViewItem(temsun);
newItem.SubItems.Add(arrList[i1 - 1].ToString());
listView2.Items.Add(newItem);
temsun = arrList[i1 + 1].ToString();
}
}
newItem = new ListViewItem(temsun);
newItem.SubItems.Add(arrList[arrList.Count - 1].ToString());
listView2.Items.Add(newItem);
}
}