public List <TC_OA_UnusualModel> GetTC_OA_UnusualList(TC_OA_UnusualQueryModel QueryModel)
{
List <TC_OA_UnusualModel> models = new List <TC_OA_UnusualModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
if (QueryModel == null)
{
QueryModel = new TC_OA_UnusualQueryModel();
}
models = new TC_OA_UnusualBLL().GetModels(QueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
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);
}
public List <TC_OA_UnusualModel> GetModels(TC_OA_UnusualQueryModel ObjQueryModel, SqlTransaction Transaction)
{
TC_OA_UnusualDAL ldal = new TC_OA_UnusualDAL(Transaction);
return(ldal.Select(ObjQueryModel));
}