void AddReportParamOrderToDate(ReportUIParameter reportUIParameter, decimal reportFileId)
{
ReportParameter parameter1 = new ReportParameter
{
ReportUIParameter = reportUIParameter,
Name = "@Order",
ReportFile = new ReportFile()
{
ID = reportFileId
}
};
this.bReportParameter.InsertReportParameter(parameter1);
ReportParameter parameter2 = new ReportParameter
{
ReportUIParameter = reportUIParameter,
Name = "@ToDate",
ReportFile = new ReportFile()
{
ID = reportFileId
}
};
this.bReportParameter.InsertReportParameter(parameter2);
}
void AddReportParamFromDateToDateStationIDClockID(ReportUIParameter reportUIParameter, decimal reportFileId)
{
ReportParameter parameter1 = new ReportParameter()
{
ReportUIParameter = reportUIParameter,
Name = "@fromDate",
ReportFile = new ReportFile()
{
ID = reportFileId
}
};
this.bReportParameter.InsertReportParameter(parameter1);
ReportParameter parameter2 = new ReportParameter()
{
ReportUIParameter = reportUIParameter,
Name = "@toDate",
ReportFile = new ReportFile()
{
ID = reportFileId
}
};
this.bReportParameter.InsertReportParameter(parameter2);
ReportParameter parameter3 = new ReportParameter()
{
ReportUIParameter = reportUIParameter,
Name = "@stationID",
ReportFile = new ReportFile()
{
ID = reportFileId
}
};
this.bReportParameter.InsertReportParameter(parameter3);
ReportParameter parameter4 = new ReportParameter()
{
ReportUIParameter = reportUIParameter,
Name = "@ClockID",
ReportFile = new ReportFile()
{
ID = reportFileId
}
};
this.bReportParameter.InsertReportParameter(parameter4);
}
void AddReportParamtoDate(ReportUIParameter reportUIParameter, decimal reportFileId)
{
ReportParameter parameter1 = new ReportParameter()
{
ReportUIParameter = reportUIParameter,
Name = "@toDate",
ReportFile = new ReportFile()
{
ID = reportFileId
}
};
this.bReportParameter.InsertReportParameter(parameter1);
}
/// <summary>
/// پارامتر های یک گزارش را برمیگرداند
/// </summary>
/// <param name="reportId">شناسه گزارش</param>
/// <returns></returns>
public IList <ReportUIParameter> GetUIReportParameters(decimal reportFileId)
{
try
{
IList <ReportUIParameter> resultList = new List <ReportUIParameter>();
IList <ReportParameter> list = ReportParamRep.GetByCriteria(new CriteriaStruct(Utility.GetPropertyName(() => new ReportParameter().ReportFile), new ReportFile()
{
ID = reportFileId
}));
var a = from o in list
select o.ReportUIParameter;
var result = from y in a
group y by y;
foreach (var found in result)
{
ReportUIParameter parameter = found.Key;
if (BLanguage.CurrentLocalLanguage == LanguagesName.Parsi)
{
parameter.ParameterTitle = parameter.fnName;
}
else
{
parameter.ParameterTitle = parameter.EnName;
}
resultList.Add(parameter);
}
return(resultList);
}
catch (Exception ex)
{
BaseBusiness <ReportParameter> .LogException(ex, "BReportParameter", "GetReportParameter");
throw ex;
}
}
