private List <WorkFlowProcedureModel> _Select(WorkFlowProcedureQueryModel qmObj)
{
List <WorkFlowProcedureModel> list = new List <WorkFlowProcedureModel>();
StringBuilder builder = new StringBuilder();
builder.Append("select * from WorkFlowProcedure ");
builder.Append(qmObj.QueryConditionStr);
if (qmObj.SortColumns.Length == 0)
{
builder.Append(" ORDER BY ProcedureCode 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)))
{
WorkFlowProcedureModel model = new WorkFlowProcedureModel();
this.Initialize(sqlDataReader, model);
list.Add(model);
}
num++;
}
}
catch (SqlException exception)
{
throw exception;
}
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
}
return(list);
}
public List <WorkFlowProcedureModel> GetWorkFlowProcedureList(string SortColumns, int StartRecord, int MaxRecords, string ProcedureCodeEqual, string ProcedureNameEqual, string DescriptionEqual, string ApplicationPathEqual, string ApplicationInfoPathEqual, int TypeEqual, string RemarkEqual, string SysTypeEqual, string CreatorEqual, decimal VersionNumberEqual, string ProjectCodeEqual, string CreateUserEqual, DateTime CreateDateEqual, string ModifyUserEqual, DateTime ModifyDateEqual, int ActivityEqual, string VersionDescriptionEqual, string ProcedureRemarkEqual)
{
List <WorkFlowProcedureModel> models = new List <WorkFlowProcedureModel>();
WorkFlowProcedureQueryModel objQueryModel = new WorkFlowProcedureQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.ProcedureCodeEqual = ProcedureCodeEqual;
objQueryModel.ProcedureNameEqual = ProcedureNameEqual;
objQueryModel.DescriptionEqual = DescriptionEqual;
objQueryModel.ApplicationPathEqual = ApplicationPathEqual;
objQueryModel.ApplicationInfoPathEqual = ApplicationInfoPathEqual;
objQueryModel.TypeEqual = TypeEqual;
objQueryModel.RemarkEqual = RemarkEqual;
objQueryModel.SysTypeEqual = SysTypeEqual;
objQueryModel.CreatorEqual = CreatorEqual;
objQueryModel.VersionNumberEqual = VersionNumberEqual;
objQueryModel.ProjectCodeEqual = ProjectCodeEqual;
objQueryModel.CreateUserEqual = CreateUserEqual;
objQueryModel.CreateDateEqual = CreateDateEqual;
objQueryModel.ModifyUserEqual = ModifyUserEqual;
objQueryModel.ModifyDateEqual = ModifyDateEqual;
objQueryModel.ActivityEqual = ActivityEqual;
objQueryModel.VersionDescriptionEqual = VersionDescriptionEqual;
objQueryModel.ProcedureRemarkEqual = ProcedureRemarkEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new WorkFlowProcedureBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <WorkFlowProcedureModel> GetWorkFlowProcedureList(WorkFlowProcedureQueryModel QueryModel)
{
List <WorkFlowProcedureModel> models = new List <WorkFlowProcedureModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
if (QueryModel == null)
{
QueryModel = new WorkFlowProcedureQueryModel();
}
models = new WorkFlowProcedureBLL().GetModels(QueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <WorkFlowProcedureModel> Select(WorkFlowProcedureQueryModel qmObj)
{
return(this._Select(qmObj));
}
public List <WorkFlowProcedureModel> Select()
{
WorkFlowProcedureQueryModel qmObj = new WorkFlowProcedureQueryModel();
return(this._Select(qmObj));
}
public List <WorkFlowProcedureModel> GetModels(WorkFlowProcedureQueryModel ObjQueryModel, SqlTransaction Transaction)
{
WorkFlowProcedureDAL edal = new WorkFlowProcedureDAL(Transaction);
return(edal.Select(ObjQueryModel));
}