private List <GK_OA_MeetSummaryModel> _Select(GK_OA_MeetSummaryQueryModel qmObj)
{
List <GK_OA_MeetSummaryModel> list = new List <GK_OA_MeetSummaryModel>();
StringBuilder builder = new StringBuilder();
builder.Append("select * from GK_OA_MeetSummary ");
builder.Append(qmObj.QueryConditionStr);
if (qmObj.SortColumns.Length == 0)
{
builder.Append(" ORDER BY Code desc");
}
else
{
builder.Append(" ORDER BY " + qmObj.SortColumns);
}
this._DataProcess.CommandText = builder.ToString();
this._DataProcess.SqlParameters = qmObj.Parameters;
SqlDataReader sqlDataReader = null;
int num = 0;
try
{
try
{
sqlDataReader = this._DataProcess.GetSqlDataReader();
while (sqlDataReader.Read())
{
if ((num >= qmObj.StartRecord) && ((list.Count < qmObj.MaxRecords) || (qmObj.MaxRecords == -1)))
{
GK_OA_MeetSummaryModel model = new GK_OA_MeetSummaryModel();
this.Initialize(sqlDataReader, model);
list.Add(model);
}
num++;
}
}
catch (SqlException exception)
{
throw exception;
}
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
}
return(list);
}
public List <GK_OA_MeetSummaryModel> GetGK_OA_MeetSummaryList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, string SortCodeEqual, string CodeRuleEqual, DateTime MeetStartTimeEqual, string PlaceEqual, string TitleEqual, string AttendPersonsEqual, string RecoderEqual, string ContextEqual, string OtherContextEqual, string TypeEqual, string DeptEqual, string StatusEqual, string CharterMemberEqual, string OtherPersonEqual, DateTime MeetEndTimeEqual, string SmallTitleEqual, string SendStatusEqual, string PreLeaveEqual, DateTime SubmitTimeEqual, string SubmiterEqual, DateTime startTime, DateTime endTime)
{
List <GK_OA_MeetSummaryModel> models = new List <GK_OA_MeetSummaryModel>();
GK_OA_MeetSummaryQueryModel objQueryModel = new GK_OA_MeetSummaryQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.SortCodeEqual = SortCodeEqual;
objQueryModel.CodeRuleEqual = CodeRuleEqual;
objQueryModel.MeetStartTimeEqual = MeetStartTimeEqual;
objQueryModel.PlaceEqual = PlaceEqual;
objQueryModel.TitleEqual = TitleEqual;
objQueryModel.AttendPersonsEqual = AttendPersonsEqual;
objQueryModel.RecoderEqual = RecoderEqual;
objQueryModel.ContextEqual = ContextEqual;
objQueryModel.OtherContextEqual = OtherContextEqual;
objQueryModel.TypeEqual = TypeEqual;
objQueryModel.DeptEqual = DeptEqual;
objQueryModel.StatusEqual = StatusEqual;
objQueryModel.CharterMemberEqual = CharterMemberEqual;
objQueryModel.OtherPersonEqual = OtherPersonEqual;
objQueryModel.MeetEndTimeEqual = MeetEndTimeEqual;
objQueryModel.SmallTitleEqual = SmallTitleEqual;
objQueryModel.SendStatusEqual = SendStatusEqual;
objQueryModel.PreLeaveEqual = PreLeaveEqual;
objQueryModel.SubmitTimeEqual = SubmitTimeEqual;
objQueryModel.SubmiterEqual = SubmiterEqual;
objQueryModel.StartTimeEqual = startTime;
objQueryModel.EndTimeEqual = endTime;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new GK_OA_MeetSummaryBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <GK_OA_MeetSummaryModel> GetGK_OA_MeetSummaryList(GK_OA_MeetSummaryQueryModel QueryModel)
{
List <GK_OA_MeetSummaryModel> models = new List <GK_OA_MeetSummaryModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
if (QueryModel == null)
{
QueryModel = new GK_OA_MeetSummaryQueryModel();
}
models = new GK_OA_MeetSummaryBLL().GetModels(QueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <GK_OA_MeetSummaryModel> Select(GK_OA_MeetSummaryQueryModel qmObj)
{
return(this._Select(qmObj));
}
public List <GK_OA_MeetSummaryModel> Select()
{
GK_OA_MeetSummaryQueryModel qmObj = new GK_OA_MeetSummaryQueryModel();
return(this._Select(qmObj));
}
public List <GK_OA_MeetSummaryModel> GetModels(GK_OA_MeetSummaryQueryModel ObjQueryModel, SqlTransaction Transaction)
{
GK_OA_MeetSummaryDAL ydal = new GK_OA_MeetSummaryDAL(Transaction);
return(ydal.Select(ObjQueryModel));
}
