public List <TC_OA_UnusualModel> GetTC_OA_UnusualList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, string ProjectCodeEqual, string ProjectNameEqual, string UserCodeEqual, DateTime ApplayDateEqual, string CoustomTypeEqual, string CoustomNameEqual, string TelephoneEqual, string EmailEqual, string RemarkEqual, string ReasonEqual, string suggestEqual, int AuditingEqual)
{
List <TC_OA_UnusualModel> models = new List <TC_OA_UnusualModel>();
TC_OA_UnusualQueryModel objQueryModel = new TC_OA_UnusualQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.ProjectCodeEqual = ProjectCodeEqual;
objQueryModel.ProjectNameEqual = ProjectNameEqual;
objQueryModel.UserCodeEqual = UserCodeEqual;
objQueryModel.ApplayDateEqual = ApplayDateEqual;
objQueryModel.CoustomTypeEqual = CoustomTypeEqual;
objQueryModel.CoustomNameEqual = CoustomNameEqual;
objQueryModel.TelephoneEqual = TelephoneEqual;
objQueryModel.EmailEqual = EmailEqual;
objQueryModel.RemarkEqual = RemarkEqual;
objQueryModel.ReasonEqual = ReasonEqual;
objQueryModel.suggestEqual = suggestEqual;
objQueryModel.AuditingEqual = AuditingEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new TC_OA_UnusualBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
