/// <summary>
/// 获取供应商的套餐购买记录统计信息
/// </summary>
/// <param name="StartDate">启用时间</param>
/// <param name="CompanyId">购买公司编号</param>
/// <param name="RateType">业务类型</param>
/// <returns>套餐购买记录统计信息实体</returns>
public virtual EyouSoft.Model.TicketStructure.PackBuyLogStatistics GetPackBuyLog(DateTime?StartDate, string CompanyId, EyouSoft.Model.TicketStructure.RateType?RateType)
{
EyouSoft.Model.TicketStructure.PackBuyLogStatistics model = new EyouSoft.Model.TicketStructure.PackBuyLogStatistics();
#region 查询参数
StringBuilder strWhere = new StringBuilder();
//当前时间
if (StartDate.HasValue)
{
strWhere.AppendFormat(" and datediff(dd,'{0}',startmonth)<=0 and datediff(dd,'{0}',endmonth)>=0 ", StartDate.Value.ToString());
}
if (!string.IsNullOrEmpty(CompanyId))
{
strWhere.AppendFormat(" and CompanyId='{0}' ", CompanyId);
}
if (RateType.HasValue)
{
strWhere.AppendFormat(" and RateType={0} ", (int)RateType.Value);
}
#endregion
DbCommand dc = this._database.GetSqlStringCommand(string.Format(Sql_TicketFreightBuyLog_PackBuyLogStatistics, strWhere.Length > 0 ? strWhere.ToString() : ""));
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
while (dr.Read())
{
if (!dr.IsDBNull(0))
{
switch ((EyouSoft.Model.TicketStructure.PackageTypes) int.Parse(dr[0].ToString()))
{
case EyouSoft.Model.TicketStructure.PackageTypes.常规:
model.GeneralUsedCount = dr.GetInt32(1);
model.GeneralAvailableCount = dr.GetInt32(2);
break;
case EyouSoft.Model.TicketStructure.PackageTypes.促销:
model.SaleUsedCount = dr.GetInt32(1);
model.SaleAvailableCount = dr.GetInt32(2);
break;
case EyouSoft.Model.TicketStructure.PackageTypes.套餐:
model.PackageUsedCount = dr.GetInt32(1);
model.PackageAvailableCount = dr.GetInt32(2);
break;
}
}
}
}
return(model);
}
protected void DataInit()
{
if (CompanyId != "")
{
//初始化当月信息
DateTime dt = DateTime.Now;
EyouSoft.Model.TicketStructure.PackBuyLogStatistics model = EyouSoft.BLL.TicketStructure.FreightBuyLog.CreateInstance().GetPackBuyLog(dt, CompanyId, EyouSoft.Model.TicketStructure.RateType.团队散拼);
if (model != null)
{
//常规可用数 - 已用数
this.frei_lblThisGeneral.Text = model.GeneralAvailableCount.ToString();
this.frei_lblThisGeneralUsed.Text = model.GeneralUsedCount.ToString();
//套餐可用数 - 已用数
this.frei_lblThisPackage.Text = model.PackageAvailableCount.ToString();
this.frei_lblThisPackageUsed.Text = model.PackageUsedCount.ToString();
//促销可用数 - 已用数
this.frei_lblThisPromotions.Text = model.SaleAvailableCount.ToString();
this.frei_lblThisPromotionsUsed.Text = model.SaleUsedCount.ToString();
//总数
this.frei_lblThisAll.Text = (model.GeneralAvailableCount + model.PackageAvailableCount + model.SaleAvailableCount + model.GeneralUsedCount + model.PackageUsedCount + model.SaleUsedCount).ToString();
}
//初始化次月信息
int year = dt.Year;
int month = dt.Month;
if (month == 12)
{
year = year + 1;
month = 1;
}
DateTime dtNext = new DateTime(year, month, 1);
EyouSoft.Model.TicketStructure.PackBuyLogStatistics modelNext = EyouSoft.BLL.TicketStructure.FreightBuyLog.CreateInstance().GetPackBuyLog(dtNext, CompanyId, EyouSoft.Model.TicketStructure.RateType.团队散拼);
//常规可用数 - 已用数
this.frei_lblNextGeneral.Text = modelNext.GeneralAvailableCount.ToString();
this.frei_lblNextGeneralUsed.Text = modelNext.GeneralUsedCount.ToString();
//套餐可用数 - 已用数
this.frei_lblNextPackage.Text = modelNext.PackageAvailableCount.ToString();
this.frei_lblNextPackageUsed.Text = modelNext.PackageUsedCount.ToString();
//促销可用数 - 已用数
this.frei_lblNextPromotions.Text = modelNext.SaleAvailableCount.ToString();
this.frei_lblNextPromotionsUsed.Text = modelNext.SaleUsedCount.ToString();
//总数
this.frei_lblNextAll.Text = (modelNext.GeneralAvailableCount + modelNext.PackageAvailableCount + modelNext.SaleAvailableCount + modelNext.GeneralUsedCount + modelNext.PackageUsedCount + modelNext.SaleUsedCount).ToString();
}
}
