/// <summary>
/// init rpt
/// </summary>
void InitRpt()
{
int recordCount = 0;
pageIndex = UtilsCommons.GetPadingIndex();
var chaXun = GetChaXunInfo();
object[] heJi;
var items = new EyouSoft.BLL.StatStructure.BYuSuanBiao().GetYuSuanBiaos(CurrentUserCompanyID, pageSize, pageIndex, ref recordCount, chaXun, out heJi);
if (items != null && items.Count > 0)
{
rpt.DataSource = items;
rpt.DataBind();
paging.UrlParams = Request.QueryString;
paging.intPageSize = pageSize;
paging.CurrencyPage = pageIndex;
paging.intRecordCount = recordCount;
ltrShiShouRenShu.Text = heJi[0].ToString();
ltrShouRuJinE.Text = ((decimal)heJi[1]).ToString("F2");
ltrZhiChuJinE.Text = ((decimal)heJi[2]).ToString("F2");
ltrMaoLi.Text = ((decimal)heJi[1] - (decimal)heJi[2]).ToString("F2");
}
else
{
phEmpty.Visible = true;
phHeJi.Visible = false;
}
}
/// <summary>
/// init rpt shouru
/// </summary>
void InitRptShouRu()
{
var items = new EyouSoft.BLL.StatStructure.BYuSuanBiao().GetShouRus(TourId);
if (items != null && items.Count > 0)
{
rptShouRu.DataSource = items;
rptShouRu.DataBind();
foreach (var item in items)
{
ShiShouRenShu += item.ShiShouRenShu;
ShouRuJinE += item.JinE;
}
if (items.Count > 1)
{
ltrShiShouRenShu1.Text = ShiShouRenShu.ToString();
ltrShouRuJinE1.Text = ShouRuJinE.ToString("F2");
}
else
{
phHeJiShuRu.Visible = false;
}
}
else
{
phEmptyShouRu.Visible = true;
phHeJiShuRu.Visible = false;
}
}
/// <summary>
/// init rpt zhichu
/// </summary>
void InitRptZhiChu()
{
var items = new EyouSoft.BLL.StatStructure.BYuSuanBiao().GetZhiChus(TourId);
if (items != null && items.Count > 0)
{
rptZhiChu.DataSource = items;
rptZhiChu.DataBind();
foreach (var item in items)
{
ZhiChuJinE += item.JinE;
}
if (items.Count > 1)
{
ltrZhiChuJinE1.Text = ZhiChuJinE.ToString("F2");
}
else
{
phHeJiZhiChu.Visible = false;
}
}
else
{
phEmptyZhiChu.Visible = true;
phHeJiZhiChu.Visible = false;
}
}
/// <summary>
/// init rpt
/// </summary>
void InitRpt()
{
var items = new EyouSoft.BLL.StatStructure.BYuSuanBiao().GetShouRus(TourId);
if (items != null && items.Count > 0)
{
rpt.DataSource = items;
rpt.DataBind();
if (items.Count > 1)
{
int shiShouRenShu = 0;
decimal shouRuJinE = 0;
foreach (var item in items)
{
shiShouRenShu += item.ShiShouRenShu;
shouRuJinE += item.JinE;
}
ltrShiShouRenShu.Text = shiShouRenShu.ToString();
ltrJinE.Text = shouRuJinE.ToString("F2");
}
else
{
phHeJi.Visible = false;
}
}
else
{
phEmpty.Visible = true;
phHeJi.Visible = false;
}
}
/// <summary>
/// to xls
/// </summary>
void ToXls()
{
int toXlsRecordCount = UtilsCommons.GetToXlsRecordCount();
if (toXlsRecordCount < 1)
{
ResponseToXls(string.Empty);
}
int _recordCount = 0;
StringBuilder s = new StringBuilder();
var chaXun = GetChaXunInfo();
object[] heJi;
var items = new EyouSoft.BLL.StatStructure.BYuSuanBiao().GetYuSuanBiaos(CurrentUserCompanyID, toXlsRecordCount, 1, ref _recordCount, chaXun, out heJi);
s.AppendFormat("序号\t团号\t线路名称\t出团日期\t回团日期\t销售员\t计调员\t导游\t团队状态\t人数\t收入\t支出\t毛利\n");
if (items == null && items.Count == 0)
{
ResponseToXls(s.ToString());
}
int i = 1;
foreach (var item in items)
{
s.AppendFormat("{0}\t", i);
s.AppendFormat("{0}\t", item.TourCode);
s.AppendFormat("{0}\t", item.XianLuName);
s.AppendFormat("{0}\t", item.ChuTuanRiQi);
s.AppendFormat("{0}\t", item.HuiTuanRiQi);
s.AppendFormat("{0}\t", item.XiaoShouYuanName);
s.AppendFormat("{0}\t", item.JiDiaoYuanName);
s.AppendFormat("{0}\t", item.DaoYouName);
s.AppendFormat("{0}\t", GetTourStatus(item.TourType, item.TourStatus));
s.AppendFormat("{0}\t", item.ShiShouRenShu);
s.AppendFormat("{0}\t", item.ShouRuJinE);
s.AppendFormat("{0}\t", item.ZhiChuJinE);
s.AppendFormat("{0}\n", item.MaoLi);
i++;
}
ResponseToXls(s.ToString());
}
