public List <FileTemplateTypeModel> GetFileTemplateTypeList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, string FileTemplateTypeNameEqual, int ParentCodeEqual, string FullIDEqual, int DeepEqual, int OrderByIDEqual)
{
List <FileTemplateTypeModel> models = new List <FileTemplateTypeModel>();
FileTemplateTypeQueryModel objQueryModel = new FileTemplateTypeQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.FileTemplateTypeNameEqual = FileTemplateTypeNameEqual;
objQueryModel.ParentCodeEqual = ParentCodeEqual;
objQueryModel.FullIDEqual = FullIDEqual;
objQueryModel.DeepEqual = DeepEqual;
objQueryModel.OrderByIDEqual = OrderByIDEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new FileTemplateTypeBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <FileTemplateTypeModel> GetChildrenFileTemplateType(int ParentCode)
{
FileTemplateTypeQueryModel queryModel = new FileTemplateTypeQueryModel();
queryModel.ParentCodeEqual = ParentCode;
queryModel.SortColumns = "Code";
return(this.GetFileTemplateTypeList(queryModel));
}
public List <FileTemplateTypeModel> GetChildrenFileTemplateTypePart(string CodeStr, int ParentCode)
{
FileTemplateTypeQueryModel queryModel = new FileTemplateTypeQueryModel();
queryModel.CodeEqual = int.Parse(CodeStr);
queryModel.ParentCodeEqual = ParentCode;
queryModel.SortColumns = "Code";
return(this.GetFileTemplateTypeList(queryModel));
}
private List <FileTemplateTypeModel> _Select(FileTemplateTypeQueryModel qmObj)
{
List <FileTemplateTypeModel> list = new List <FileTemplateTypeModel>();
StringBuilder builder = new StringBuilder();
builder.Append("select * from FileTemplateType ");
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)))
{
FileTemplateTypeModel model = new FileTemplateTypeModel();
this.Initialize(sqlDataReader, model);
list.Add(model);
}
num++;
}
}
catch (SqlException exception)
{
throw exception;
}
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
}
return(list);
}
public string[] GetNodeBrother(int parentCode, int code, out bool hasMore)
{
int index;
string[] textArray = new string[2];
string[] array = new string[30];
int[] numArray = new int[30];
int num = 0;
FileTemplateTypeQueryModel queryModel = new FileTemplateTypeQueryModel();
queryModel.ParentCodeEqual = parentCode;
List <FileTemplateTypeModel> fileTemplateTypeList = new List <FileTemplateTypeModel>();
fileTemplateTypeList = this.GetFileTemplateTypeList(queryModel);
if (fileTemplateTypeList.Count == 1)
{
hasMore = false;
textArray[0] = "";
textArray[1] = "";
return(textArray);
}
hasMore = true;
for (index = 0; index < fileTemplateTypeList.Count; index++)
{
numArray[index] = fileTemplateTypeList[index].Code;
array[index] = fileTemplateTypeList[index].FileTemplateTypeName;
}
for (index = 0; index < numArray.Length; index++)
{
if (numArray[index] == code)
{
num = index;
break;
}
}
this.Swap <int>(ref numArray[0], ref numArray[num]);
this.Swap <string>(ref array[0], ref array[num]);
textArray[0] = this.ChangeCodeArrayToString(numArray);
textArray[1] = this.ChangeNameArrayToString(array);
return(textArray);
}
public List <FileTemplateTypeModel> GetRecursionFileTemplateTypeChildNodeByNodeCode(int NodeCode)
{
FileTemplateTypeQueryModel queryModel = new FileTemplateTypeQueryModel();
queryModel.ParentCodeEqual = NodeCode;
List <FileTemplateTypeModel> fileTemplateTypeList = this.GetFileTemplateTypeList(queryModel);
List <FileTemplateTypeModel> list2 = new List <FileTemplateTypeModel>();
foreach (FileTemplateTypeModel model2 in fileTemplateTypeList)
{
FileTemplateTypeModel item = new FileTemplateTypeModel();
item.Code = model2.Code;
list2.Add(item);
List <FileTemplateTypeModel> recursionFileTemplateTypeChildNodeByNodeCode = this.GetRecursionFileTemplateTypeChildNodeByNodeCode(model2.Code);
foreach (FileTemplateTypeModel model4 in recursionFileTemplateTypeChildNodeByNodeCode)
{
FileTemplateTypeModel model5 = new FileTemplateTypeModel();
model5.Code = model4.Code;
list2.Add(model5);
}
}
return(list2);
}
public List <FileTemplateTypeModel> GetFileTemplateTypeList(FileTemplateTypeQueryModel QueryModel)
{
List <FileTemplateTypeModel> models = new List <FileTemplateTypeModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
if (QueryModel == null)
{
QueryModel = new FileTemplateTypeQueryModel();
}
models = new FileTemplateTypeBLL().GetModels(QueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <FileTemplateTypeModel> GetModels(FileTemplateTypeQueryModel ObjQueryModel, SqlTransaction Transaction)
{
FileTemplateTypeDAL edal = new FileTemplateTypeDAL(Transaction);
return(edal.Select(ObjQueryModel));
}
public List <FileTemplateTypeModel> Select(FileTemplateTypeQueryModel qmObj)
{
return(this._Select(qmObj));
}
public List <FileTemplateTypeModel> Select()
{
FileTemplateTypeQueryModel qmObj = new FileTemplateTypeQueryModel();
return(this._Select(qmObj));
}
