/// <summary>
/// 获取项目总增长
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public List <HCQ2_Model.APPModel.ResultApiModel.ChartProject> GetProjectAllGrow(HCQ2_Model.APPModel.ParamModel.DebtAllGrantModel model)
{
sb?.Clear();
sb.Append(string.Format(@"SELECT COUNT(UnitID) FROM dbo.B01 WHERE ISNULL(B0183,'')<>'' AND CONVERT(varchar(7),B0183,120)<=@date"));
string[] start = model.startDate.Split('-');
string[] end = model.endDate.Split('-');
int startYear = Helper.ToInt(start[0]);
int endYear = Helper.ToInt(end[0]);
int startMonth = Helper.ToInt(start[1]);
int endMonth = Helper.ToInt(end[1]);
if ((startYear * 12 + startMonth) > (endYear * 12 + endMonth))
{
return(null);
}
List <HCQ2_Model.APPModel.ResultApiModel.ChartProject> list = new List <HCQ2_Model.APPModel.ResultApiModel.ChartProject>();
while (startYear + "-" + (startMonth > 9?startMonth.ToString(): "0" + startMonth.ToString()) != model.endDate)
{
_param?.Clear();
_param.Add("@date", startYear + "-" + (startMonth > 9 ? startMonth.ToString() : "0" + startMonth.ToString()));
int count = Helper.ToInt(SqlHelper.ExecuteScalar(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param)));
if (count > 0)
{
list.Add(new HCQ2_Model.APPModel.ResultApiModel.ChartProject {
month = startMonth, projectCount = count
});
}
startMonth++;
if (startMonth > 12)
{
startMonth = 1;
startYear++;
}
}
if (startYear + "-" + (startMonth > 9 ? startMonth.ToString() : "0" + startMonth.ToString()) == model.endDate)
{
_param?.Clear();
_param.Add("@date", startYear + "-" + (startMonth > 9 ? startMonth.ToString(): "0" + startMonth.ToString()));
int count = Helper.ToInt(SqlHelper.ExecuteScalar(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param)));
if (count > 0)
{
list.Add(new HCQ2_Model.APPModel.ResultApiModel.ChartProject {
month = startMonth, projectCount = count
});
}
}
return(list);
}
/// <summary>
/// 获取项目月增长
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public List <HCQ2_Model.APPModel.ResultApiModel.ChartProject> GetProjectMonthGrow(HCQ2_Model.APPModel.ParamModel.DebtAllGrantModel model)
{
sb?.Clear();
sb.Append(string.Format(@"SELECT CAST(SUBSTRING(T.createDate,6,2) AS INT) AS month,COUNT(T.UnitID) AS projectCount FROM
(SELECT CONVERT(varchar(7),B0183,120) AS createDate,UnitID FROM dbo.B01 WHERE ISNULL(B0183,'')<>'' AND CONVERT(varchar(7),B0183,120) BETWEEN @startDate AND @endDate )T GROUP BY T.createDate;"));
_param?.Clear();
_param.Add("@startDate", model.startDate);
_param.Add("@endDate", model.endDate);
DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param));
return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <HCQ2_Model.APPModel.ResultApiModel.ChartProject>(dt));
}
/// <summary>
/// 获取人员总增长
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public List <HCQ2_Model.APPModel.ResultApiModel.ChartPerson> GetPersonAllGrow(HCQ2_Model.APPModel.ParamModel.DebtAllGrantModel model)
{
if (null == model)
{
return(null);
}
return(DBSession.IA01DAL.GetPersonAllGrow(model));
}
