/// <summary>
/// 取得标识序列号
/// </summary>
/// <param name="UnitCode"></param>
/// <param name="TemplateCode"></param>
/// <returns></returns>
private string GetTempMarkingSN(string UnitCode, string TemplateCode)
{
string MarkingSNCode = "";
FTVQM.FileTemplateCodeEqual = int.Parse(TemplateCode);
FTVQM.IsAvailabilityEqual = "有效";
IList <FileTemplateVersionModel> VersionList = FTVBFL.GetFileTemplateVersionList(FTVQM);
if (VersionList.Count > 0)
{
string tmpNumber = VersionList[0].MarkingSNRule;
string XX = "";
string YYMM = (DateTime.Today.Year).ToString().Substring(2).ToString() + DateTime.Today.Month.ToString();
DocumentDirectoryQueryModel DDQ = new DocumentDirectoryQueryModel();
DDQ.DepartmentCodeEqual = UnitCode;
DDQ.FileTemplateCodeEqual = int.Parse(TemplateCode);
IList <DocumentDirectoryModel> DirectoryList = DDBFL.GetDocumentDirectoryList(DDQ);
if (DirectoryList.Count > 0)
{
XX = DirectoryList[0].DirectoryNodeCode;
}
//MarkingSNCode = tmpNumber.ToUpper().Replace("XX", XX).Replace("YYMM", YYMM);
MarkingSNCode = tmpNumber.ToUpper().Replace("YYMM", YYMM).Substring(0, 8);
}
return(MarkingSNCode);
}
public List <DocumentDirectoryModel> GetDocumentDirectoryList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, string DirectoryNameEqual, string DirectoryNodeCodeEqual, int FileTemplateCodeEqual, int ParentCodeEqual, string FullIDEqual, int DeepEqual, DateTime CreateDateEqual, int OrderByIDEqual)
{
List <DocumentDirectoryModel> models = new List <DocumentDirectoryModel>();
DocumentDirectoryQueryModel objQueryModel = new DocumentDirectoryQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.DirectoryNameEqual = DirectoryNameEqual;
objQueryModel.DirectoryNodeCodeEqual = DirectoryNodeCodeEqual;
objQueryModel.FileTemplateCodeEqual = FileTemplateCodeEqual;
objQueryModel.ParentCodeEqual = ParentCodeEqual;
objQueryModel.FullIDEqual = FullIDEqual;
objQueryModel.DeepEqual = DeepEqual;
objQueryModel.CreateDateEqual = CreateDateEqual;
objQueryModel.OrderByIDEqual = OrderByIDEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new DocumentDirectoryBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <DocumentFileModel> GetDocumentFileListByCondition(string SortColumns, int StartRecord, int MaxRecords, string NodeCode, string FileCodeEqual, string DoucmentMarkingSNEqual, string SubjectEqual, DateTime ArchiveDateTimeEqualStart, DateTime ArchiveDateTimeEqualEnd)
{
DocumentDirectoryBFL ybfl = new DocumentDirectoryBFL();
DocumentDirectoryQueryModel queryModel = new DocumentDirectoryQueryModel();
DocumentDirectoryModel model2 = new DocumentDirectoryModel();
queryModel.CodeEqual = int.Parse(NodeCode);
List <DocumentDirectoryModel> documentDirectoryList = ybfl.GetDocumentDirectoryList(queryModel);
string departmentCode = "";
int fileTemplateCode = 0;
if (documentDirectoryList.Count > 0)
{
departmentCode = documentDirectoryList[0].DepartmentCode;
fileTemplateCode = documentDirectoryList[0].FileTemplateCode;
}
DocumentFileQueryModel model3 = new DocumentFileQueryModel();
model3.FileTemplateCodeEqual = fileTemplateCode;
model3.ApplyDepartmentCodeEqual = departmentCode;
model3.SortColumns = SortColumns;
model3.StartRecord = StartRecord;
model3.MaxRecords = MaxRecords;
model3.DoucmentMarkingSNEqual = DoucmentMarkingSNEqual;
model3.SubjectEqual = SubjectEqual;
model3.FileCodeEqul = FileCodeEqual;
model3.ArchiveDatetimeEqualStart = ArchiveDateTimeEqualStart;
model3.ArchiveDatetimeEqualEnd = ArchiveDateTimeEqualEnd;
return(this.GetDocumentFileList(model3));
}
public List <DocumentFileModel> GetDocumentFileList(string SortColumns, int StartRecord, int MaxRecords, string NodeCode)
{
DocumentDirectoryBFL ybfl = new DocumentDirectoryBFL();
DocumentDirectoryQueryModel queryModel = new DocumentDirectoryQueryModel();
DocumentDirectoryModel model2 = new DocumentDirectoryModel();
queryModel.CodeEqual = int.Parse(NodeCode);
List <DocumentDirectoryModel> documentDirectoryList = ybfl.GetDocumentDirectoryList(queryModel);
string departmentCode = "";
int fileTemplateCode = 0;
if (documentDirectoryList.Count > 0)
{
departmentCode = documentDirectoryList[0].DepartmentCode;
fileTemplateCode = documentDirectoryList[0].FileTemplateCode;
}
DocumentFileQueryModel model3 = new DocumentFileQueryModel();
model3.FileTemplateCodeEqual = fileTemplateCode;
model3.ApplyDepartmentCodeEqual = departmentCode;
model3.SortColumns = SortColumns;
model3.StartRecord = StartRecord;
model3.MaxRecords = MaxRecords;
return(this.GetDocumentFileList(model3));
}
public List <DocumentDirectoryModel> GetChildrenDocumentDirectory(int ParentCode)
{
DocumentDirectoryQueryModel queryModel = new DocumentDirectoryQueryModel();
queryModel.ParentCodeEqual = ParentCode;
queryModel.SortColumns = "Code";
return(this.GetDocumentDirectoryList(queryModel));
}
private List <DocumentDirectoryModel> _Select(DocumentDirectoryQueryModel qmObj)
{
List <DocumentDirectoryModel> list = new List <DocumentDirectoryModel>();
StringBuilder builder = new StringBuilder();
builder.Append("select * from DocumentDirectory ");
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)))
{
DocumentDirectoryModel model = new DocumentDirectoryModel();
this.Initialize(sqlDataReader, model);
list.Add(model);
}
num++;
}
}
catch (SqlException exception)
{
throw exception;
}
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
}
return(list);
}
public bool HasChild(string code)
{
bool flag = false;
if (!string.IsNullOrEmpty(code))
{
int num = int.Parse(code);
DocumentDirectoryBFL ybfl = new DocumentDirectoryBFL();
DocumentDirectoryQueryModel queryModel = new DocumentDirectoryQueryModel();
queryModel.ParentCodeEqual = num;
List <DocumentDirectoryModel> list = new List <DocumentDirectoryModel>();
if (ybfl.GetDocumentDirectoryList(queryModel).Count > 0)
{
flag = true;
}
}
return(flag);
}
public List <DocumentDirectoryModel> GetDocumentDirectoryList(DocumentDirectoryQueryModel QueryModel)
{
List <DocumentDirectoryModel> models = new List <DocumentDirectoryModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
if (QueryModel == null)
{
QueryModel = new DocumentDirectoryQueryModel();
}
models = new DocumentDirectoryBLL().GetModels(QueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <DocumentDirectoryModel> Select(DocumentDirectoryQueryModel qmObj)
{
return(this._Select(qmObj));
}
public List <DocumentDirectoryModel> Select()
{
DocumentDirectoryQueryModel qmObj = new DocumentDirectoryQueryModel();
return(this._Select(qmObj));
}
public List <DocumentDirectoryModel> GetModels(DocumentDirectoryQueryModel ObjQueryModel, SqlTransaction Transaction)
{
DocumentDirectoryDAL ydal = new DocumentDirectoryDAL(Transaction);
return(ydal.Select(ObjQueryModel));
}
