private DataTable dtStatistics; //生成统计表
#endregion
private void frmLocatingDay_Load(object sender, System.EventArgs e)
{
com.digitalwave.iCare.middletier.HIS.clsHisBase HisBase = new com.digitalwave.iCare.middletier.HIS.clsHisBase();
checkDate = HisBase.s_GetServerDate().ToShortDateString();
label1.Text = this.LoginInfo.m_strEmpName + "合计金额:";
m_GetAndFillData();
}
/// <summary>
/// 结帐
/// </summary>
/// <param name="p_dtPrepayData"></param>
/// <param name="p_strOperatorId"></param>
/// <returns></returns>
public long CheckoutPrepayData(DataTable p_dtPrepayData, string p_strOperatorId, string p_strRemark)
{
com.digitalwave.iCare.middletier.HIS.clsHisBase hisBase =
(com.digitalwave.iCare.middletier.HIS.clsHisBase)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.HIS.clsHisBase));
string checkDate = hisBase.s_GetServerDate().ToString();
long lngRes;
System.Security.Principal.IPrincipal p_objPrincipal = null;
com.digitalwave.iCare.middletier.HIS.clsPrepayCheckoutSvc objSvc =
(com.digitalwave.iCare.middletier.HIS.clsPrepayCheckoutSvc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.HIS.clsPrepayCheckoutSvc));
lngRes = objSvc.CheckOutPrepayData(p_objPrincipal, p_dtPrepayData, p_strOperatorId, checkDate, p_strRemark);
hisBase.Dispose();
objSvc.Dispose();
return(lngRes);
}
private void getData()
{
strCheckManID = this.m_objViewer.LoginInfo.m_strEmpID;
string[] strDateArr = new string[2];
ArrayList arrPaytype = this.m_objViewer.PayTypeArr;
Hashtable has = new Hashtable();
if (arrPaytype.Count > 0)
{
foreach (string str in arrPaytype)
{
if (!has.ContainsKey(str))
{
has.Add(str, str);
}
}
}
arrReList.Clear();
SaveINVOICENO.Clear();
if (intcomand == 0)
{
com.digitalwave.iCare.middletier.HIS.clsHisBase HisBase = (com.digitalwave.iCare.middletier.HIS.clsHisBase)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.HIS.clsHisBase));
string checkDate = HisBase.s_GetServerDate().ToString();
strDateArr[0] = checkDate;
Domain.m_lngGetCheckOutOfData("", 0, 0, strCheckManID, strDateArr, out dtRecipesumde, out dtCheckOut, out dtRecipeinv);
strCheckDate = DateTime.Now.ToShortDateString();
this.m_objViewer.btnPrint.Enabled = false;
this.m_objViewer.buttonXP3.Enabled = false;
this.m_objViewer.buttonXP2.Enabled = false;
this.m_objViewer.buttonXP4.Enabled = false;
}
else
{
strCheckDate = this.m_objViewer.ctlDgFind[this.m_objViewer.ctlDgFind.CurrentCell.RowNumber, 0].ToString();
strDateArr[0] = strCheckDate;
Domain.m_lngGetPayTypeAndCheckOutDatahistory("", 0, strDateArr, strCheckManID, out dtRecipesumde, out dtCheckOut, out dtRecipeinv);
this.m_objViewer.btnCheck.Enabled = false;
this.m_objViewer.btnPrint.Enabled = true;
this.m_objViewer.buttonXP3.Enabled = false;
this.m_objViewer.buttonXP2.Enabled = false;
this.m_objViewer.buttonXP4.Enabled = false;
}
#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("刷卡金额合计"); //银联POS
dtStatistics.Columns.Add("刷卡退款"); //银联POS退款
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("记帐收款"); //记帐收款
dtStatistics.Columns.Add("记帐退款"); //记帐退款
dtStatistics.Columns.Add("记帐单记帐"); //无记帐单记帐
dtStatistics.Columns.Add("无记帐单记帐"); //无记帐单记帐
dtStatistics.Columns.Add("其它金额合计"); //其它收款
dtStatistics.Columns.Add("其它退款"); //其它退款
#endregion
#region 统计各种收费类型的金额
if (dtRecipesumde.Rows.Count >= 0)
{
if (intcomand == 0)
{
this.m_objViewer.btnCheck.Enabled = true;
}
}
else
{
this.m_objViewer.btnCheck.Enabled = false;
this.m_objViewer.btnPrint.Enabled = false;
this.m_objViewer.buttonXP3.Enabled = false;
this.m_objViewer.buttonXP2.Enabled = false;
}
#endregion
#region 统计数据
StatisticsRow = dtStatistics.NewRow();
StatisticsRow["开票数"] = 0;
StatisticsRow["开票金额"] = 0.00;
StatisticsRow["退票数"] = 0;
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;
StatisticsRow["实收金额合计"] = 0.00;
StatisticsRow["现金退款"] = 0.00;
StatisticsRow["第一张发票时间"] = "";
StatisticsRow["最后一张发票时间"] = "";
StatisticsRow["记帐收款"] = 0.00;
StatisticsRow["记帐退款"] = 0.00;
StatisticsRow["记帐单记帐"] = 0.00;
StatisticsRow["无记帐单记帐"] = 0.00;
StatisticsRow["其它金额合计"] = 0;
StatisticsRow["其它退款"] = 0;
arrList = new ArrayList();
for (int k1 = 0; k1 < dtRecipeinv.Rows.Count; k1++)
{
#region 统计有关发票的信息
//计算发票的第一张和最后一张
if (k1 == 0)
{
StatisticsRow["第一张发票时间"] = Convert.ToDateTime(dtRecipeinv.Rows[0]["operdate_dat"].ToString());
StatisticsRow["最后一张发票时间"] = Convert.ToDateTime(dtRecipeinv.Rows[0]["operdate_dat"].ToString());
}
else
{
if (Convert.ToDateTime(dtRecipeinv.Rows[k1]["operdate_dat"].ToString()) < Convert.ToDateTime(StatisticsRow["第一张发票时间"].ToString()))
{
StatisticsRow["第一张发票时间"] = Convert.ToDateTime(dtRecipeinv.Rows[k1]["operdate_dat"].ToString());
}
if (Convert.ToDateTime(dtRecipeinv.Rows[k1]["operdate_dat"].ToString()) > Convert.ToDateTime(StatisticsRow["最后一张发票时间"].ToString()))
{
StatisticsRow["最后一张发票时间"] = Convert.ToDateTime(dtRecipeinv.Rows[k1]["operdate_dat"].ToString());
}
}
//统计开票数,开票金额
if (k1 == 0)
{
StatisticsRow["开票数"] = Convert.ToInt16(StatisticsRow["开票数"].ToString()) + 1;
if (dtRecipeinv.Rows[k1]["type_int"].ToString().Trim() == "1")
{
StatisticsRow["开票金额"] = Convert.ToDouble(StatisticsRow["开票金额"].ToString()) + Convert.ToDouble(dtRecipeinv.Rows[k1]["totalsum_mny"].ToString());
}
}
else
{
if (dtRecipeinv.Rows[k1]["chargeno_chr"].ToString().Trim() == dtRecipeinv.Rows[k1 - 1]["chargeno_chr"].ToString().Trim())
{
StatisticsRow["开票数"] = Convert.ToInt16(StatisticsRow["开票数"].ToString()) + 1;
}
else
{
StatisticsRow["开票数"] = Convert.ToInt16(StatisticsRow["开票数"].ToString()) + 1;
if (dtRecipeinv.Rows[k1]["type_int"].ToString().Trim() == "1")
{
StatisticsRow["开票金额"] = Convert.ToDouble(StatisticsRow["开票金额"].ToString()) + Convert.ToDouble(dtRecipeinv.Rows[k1]["totalsum_mny"].ToString());
}
}
}
//退票数,退票金额合计,所有的退票号
if (dtRecipeinv.Rows[k1]["type_int"].ToString().Trim() == "2")//退票数,退票金额合计,所有的退票号
{
if (k1 == 0)
{
StatisticsRow["退票数"] = Convert.ToInt16(StatisticsRow["退票数"].ToString()) + 1;
StatisticsRow["退票金额合计"] = Convert.ToDouble(StatisticsRow["退票金额合计"].ToString()) - Convert.ToDouble(dtRecipeinv.Rows[k1]["totalsum_mny"].ToString());
SaveINVOICENO.Add(dtRecipeinv.Rows[k1]["invoiceno_vchr"].ToString());
}
else
{
if (dtRecipeinv.Rows[k1]["chargeno_chr"].ToString().Trim() == dtRecipeinv.Rows[k1 - 1]["chargeno_chr"].ToString().Trim())
{
StatisticsRow["退票数"] = Convert.ToInt16(StatisticsRow["退票数"].ToString()) + 1;
SaveINVOICENO.Add(dtRecipeinv.Rows[k1]["invoiceno_vchr"].ToString());
}
else
{
StatisticsRow["退票数"] = Convert.ToInt16(StatisticsRow["退票数"].ToString()) + 1;
StatisticsRow["退票金额合计"] = Convert.ToDouble(StatisticsRow["退票金额合计"].ToString()) - Convert.ToDouble(dtRecipeinv.Rows[k1]["totalsum_mny"].ToString());
SaveINVOICENO.Add(dtRecipeinv.Rows[k1]["invoiceno_vchr"].ToString());
}
}
}
#endregion
}
if (dtRecipeinv.Rows.Count > 0)
{
StatisticsRow["开始发票号"] = dtRecipeinv.Rows[0]["invoiceno_vchr"].ToString();
StatisticsRow["结束发票号"] = dtRecipeinv.Rows[dtRecipeinv.Rows.Count - 1]["invoiceno_vchr"].ToString();
}
DataRow dr = null;
for (int i1 = 0; i1 < dtCheckOut.Rows.Count; i1++)
{
dr = dtCheckOut.Rows[i1];
if (dtCheckOut.Rows[i1]["type_int"].ToString().Trim() == "1")//收款
{
switch (dtCheckOut.Rows[i1]["paytype_int"].ToString().Trim())
{
case "0":
StatisticsRow["实收现金合计"] = Convert.ToDouble(StatisticsRow["实收现金合计"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["sbmoney"].ToString());
break;
case "1":
StatisticsRow["刷卡金额合计"] = Convert.ToDouble(StatisticsRow["刷卡金额合计"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["sbmoney"].ToString());
break;
case "2":
StatisticsRow["支票金额合计"] = Convert.ToDouble(StatisticsRow["支票金额合计"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["sbmoney"].ToString());
break;
case "3":
StatisticsRow["医保记账金额"] = Convert.ToDouble(StatisticsRow["医保记账金额"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["sbmoney"].ToString());
break;
case "4":
StatisticsRow["汇款存款"] = Convert.ToDouble(StatisticsRow["汇款存款"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["sbmoney"].ToString());
break;
default:
StatisticsRow["其它金额合计"] = Convert.ToDouble(StatisticsRow["其它金额合计"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["sbmoney"].ToString());
break;
}
if (i1 == 0)
{
StatisticsRow["记帐收款"] = Convert.ToDouble(StatisticsRow["记帐收款"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["acctsum_mny"].ToString());
StatisticsRow["记帐单记帐"] = Convert.ToDouble(StatisticsRow["记帐单记帐"].ToString().Trim()) + this.dblSbmny(1, has, ref dr);
StatisticsRow["无记帐单记帐"] = Convert.ToDouble(StatisticsRow["无记帐单记帐"].ToString().Trim()) + this.dblSbmny(0, has, ref dr);
}
else
{
if (dtCheckOut.Rows[i1]["chargeno_chr"].ToString().Trim() == dtCheckOut.Rows[i1 - 1]["chargeno_chr"].ToString().Trim())
{
}
else
{
StatisticsRow["记帐收款"] = Convert.ToDouble(StatisticsRow["记帐收款"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["acctsum_mny"].ToString());
StatisticsRow["记帐单记帐"] = Convert.ToDouble(StatisticsRow["记帐单记帐"].ToString().Trim()) + this.dblSbmny(1, has, ref dr);
StatisticsRow["无记帐单记帐"] = Convert.ToDouble(StatisticsRow["无记帐单记帐"].ToString().Trim()) + this.dblSbmny(0, has, ref dr);
}
}
}
else//退款
{
switch (dtCheckOut.Rows[i1]["paytype_int"].ToString().Trim())
{
case "0":
StatisticsRow["现金退款"] = Convert.ToDouble(StatisticsRow["现金退款"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["sbmoney"].ToString());
break;
case "1":
StatisticsRow["刷卡退款"] = Convert.ToDouble(StatisticsRow["刷卡退款"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["sbmoney"].ToString());
break;
case "2":
StatisticsRow["支票退款"] = Convert.ToDouble(StatisticsRow["支票退款"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["sbmoney"].ToString());
break;
case "3":
StatisticsRow["铁路垫支退款"] = Convert.ToDouble(StatisticsRow["铁路垫支退款"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["sbmoney"].ToString());
break;
case "4":
StatisticsRow["汇款退款"] = Convert.ToDouble(StatisticsRow["汇款退款"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["sbmoney"].ToString());
break;
default:
StatisticsRow["其它退款"] = Convert.ToDouble(StatisticsRow["其它退款"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["sbmoney"].ToString());
break;
}
if (i1 == 0)
{
StatisticsRow["记帐退款"] = Convert.ToDouble(StatisticsRow["记帐退款"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["acctsum_mny"].ToString());
StatisticsRow["记帐单记帐"] = Convert.ToDouble(StatisticsRow["记帐单记帐"].ToString().Trim()) + this.dblSbmny(1, has, ref dr);
StatisticsRow["无记帐单记帐"] = Convert.ToDouble(StatisticsRow["无记帐单记帐"].ToString().Trim()) + this.dblSbmny(0, has, ref dr);
}
else
{
if (dtCheckOut.Rows[i1]["chargeno_chr"].ToString().Trim() == dtCheckOut.Rows[i1 - 1]["chargeno_chr"].ToString().Trim())
{
}
else
{
StatisticsRow["记帐退款"] = Convert.ToDouble(StatisticsRow["记帐退款"].ToString().Trim()) + Convert.ToDouble(dtCheckOut.Rows[i1]["acctsum_mny"].ToString());
StatisticsRow["记帐单记帐"] = Convert.ToDouble(StatisticsRow["记帐单记帐"].ToString().Trim()) + this.dblSbmny(1, has, ref dr);
StatisticsRow["无记帐单记帐"] = Convert.ToDouble(StatisticsRow["无记帐单记帐"].ToString().Trim()) + this.dblSbmny(0, has, ref dr);
}
}
}
}
//计算有效票数
int intAvailability = Convert.ToInt32(StatisticsRow["开票数"].ToString().Trim()) - Convert.ToInt32(StatisticsRow["退票数"].ToString().Trim());
//计算有效金额
Double AvailabilityMoney = Convert.ToDouble(StatisticsRow["开票金额"].ToString().Trim()) - Convert.ToDouble(StatisticsRow["退票金额合计"].ToString().Trim());
StatisticsRow["有效票数"] = intAvailability.ToString();
StatisticsRow["实收金额合计"] = AvailabilityMoney.ToString();
dtStatistics.Rows.Add(StatisticsRow);
dtStatistics.AcceptChanges();
#endregion
}