/// <summary>
/// 获取指定日期内的金额
/// </summary>
internal void m_mthGetAllMoney()
{
m_objViewer.m_lblBuyInMoney.Text = string.Empty;
m_objViewer.m_lblRetailMoney.Text = string.Empty;
DateTime dtmBegin = Convert.ToDateTime(Convert.ToDateTime(m_objViewer.m_dtpBeginDatePage1.Text).ToString("yyyy-MM-dd 00:00:00"));
DateTime dtmEnd = Convert.ToDateTime(Convert.ToDateTime(m_objViewer.m_dtpEndDatePage1.Text).ToString("yyyy-MM-dd 23:59:59"));
clsDcl_OutStorage objOSDomain = new clsDcl_OutStorage();
if (m_objViewer.m_dtbAllMoney == null)
{
long lngRes = objOSDomain.m_lngGetAllInMoney(dtmBegin, dtmEnd, m_objViewer.m_strStorageID, 4, out m_objViewer.m_dtbAllMoney);
}
if (m_objViewer.m_dtbAllMoney != null && m_objViewer.m_dtbAllMoney.Rows.Count == 0)
{
m_objViewer.m_dtbAllMoney = null;
}
if (m_objViewer.m_dtbAllMoney != null && m_objViewer.m_dtvCurrentMainVienPage1 != null)
{
//StringBuilder stbFilter = new StringBuilder(100);
//int intRowsCount = m_objViewer.m_dtvCurrentMainVienPage1.Count;
//for (int iRow = 0; iRow < intRowsCount; iRow++)
//{
// stbFilter.Append(" seriesid_int =");
// stbFilter.Append(m_objViewer.m_dtvCurrentMainVienPage1[iRow]["SERIESID_INT"].ToString());
// if (iRow < intRowsCount - 1)
// {
// stbFilter.Append(" or ");
// }
//}
string strFilterResult = m_strMainFilter();
//if (!string.IsNullOrEmpty(strFilterResult))
//{
DataRow[] drAllMoney = m_objViewer.m_dtbAllMoney.Select(strFilterResult);
if (drAllMoney != null && drAllMoney.Length > 0)
{
decimal dcmBuyIn = 0m;
decimal dcmRetailSale = 0m;
for (int iM = 0; iM < drAllMoney.Length; iM++)
{
dcmBuyIn += Convert.ToDecimal(drAllMoney[iM]["BuyInMoney"]);
dcmRetailSale += Convert.ToDecimal(drAllMoney[iM]["RetailPrice"]);
}
m_objViewer.m_lblBuyInMoney.Text = dcmBuyIn.ToString("0.0000");
m_objViewer.m_lblRetailMoney.Text = dcmRetailSale.ToString("0.0000");
}
//}
}
}
/// <summary>
/// 获取指定日期内的金额
/// </summary>
internal void m_mthGetAllMoney()
{
m_objViewer.m_lblBuyInMoney.Text = string.Empty;
m_objViewer.m_lblRetailMoney.Text = string.Empty;
DateTime dtmBegin = Convert.ToDateTime(Convert.ToDateTime(m_objViewer.m_dtpSearchBeginDate.Text).ToString("yyyy-MM-dd 00:00:00"));
DateTime dtmEnd = Convert.ToDateTime(Convert.ToDateTime(m_objViewer.m_dtpSearchEndDate.Text).ToString("yyyy-MM-dd 23:59:59"));
clsDcl_OutStorage objOSDomain = new clsDcl_OutStorage();
if (m_objViewer.m_dtbAllMoney == null)
{
long lngRes = objOSDomain.m_lngGetAllInMoney(dtmBegin, dtmEnd, m_objViewer.m_strStorageID, 2, out m_objViewer.m_dtbAllMoney);
}
if (m_objViewer.m_dtbAllMoney != null && m_objViewer.m_dtbAllMoney.Rows.Count == 0)
{
m_objViewer.m_dtbAllMoney = null;
}
if (m_objViewer.m_dtbAllMoney != null && m_objViewer.m_dtvCurrentMainView != null)
{
//StringBuilder stbFilter = new StringBuilder(100);
int intRowsCount = m_objViewer.m_dtvCurrentMainView.Count;
System.Collections.Hashtable hstMedicine = new System.Collections.Hashtable();
for (int iRow = 0; iRow < intRowsCount; iRow++)
{
hstMedicine.Add(Convert.ToInt64(m_objViewer.m_dtvCurrentMainView[iRow]["seriesid_int"]), m_objViewer.m_dtvCurrentMainView[iRow]["outstorageid_vchr"].ToString());
}
string strFilterResult = m_strMainFilter();
//if (!string.IsNullOrEmpty(strFilterResult))
//{
DataRow[] drAllMoney = m_objViewer.m_dtbAllMoney.Select(strFilterResult);
if (drAllMoney != null && drAllMoney.Length > 0)
{
decimal dcmBuyIn = 0m;
decimal dcmRetailSale = 0m;
for (int iM = 0; iM < drAllMoney.Length; iM++)
{
if (!hstMedicine.Contains(Convert.ToInt64(drAllMoney[iM]["seriesid_int"])))
{
continue;
}
dcmBuyIn += Convert.ToDecimal(drAllMoney[iM]["BuyInMoney"]);
dcmRetailSale += Convert.ToDecimal(drAllMoney[iM]["RetailPrice"]);
}
m_objViewer.m_lblBuyInMoney.Text = dcmBuyIn.ToString("0.0000");
m_objViewer.m_lblRetailMoney.Text = dcmRetailSale.ToString("0.0000");
}
//}
}
}