/// <summary>
/// Añade un error
/// </summary>
private void AddError(DocumentFileModel objDocument, string strMessage)
{
AddError($"Error: {strMessage}. Estructura: {objDocument.Name} ({objDocument.StructType})");
}
/// <summary>
/// Graba la documentación Nhaml en un archivo
/// </summary>
public void Save(DocumentFileModel document, MLIntermedialBuilder builderML, string fileNameTemplate, string path)
{
Save(GetMLFile(document, ConvertMLNode(builderML)), System.IO.Path.Combine(path, document.GetPathLocal()));
}
public int Update(DocumentFileModel mObj)
{
return(this._Update(mObj));
}
public int Insert(DocumentFileModel mObj)
{
return(this._Insert(mObj));
}
private void Initialize(SqlDataReader reader, DocumentFileModel obj)
{
if (reader.GetValue(0) != DBNull.Value)
{
obj.Code = reader.GetInt32(0);
}
if (reader.GetValue(1) != DBNull.Value)
{
obj.OperationType = reader.GetString(1);
}
if (reader.GetValue(2) != DBNull.Value)
{
obj.ApplyUserCode = reader.GetString(2);
}
if (reader.GetValue(3) != DBNull.Value)
{
obj.ApplyDepartmentCode = reader.GetString(3);
}
if (reader.GetValue(4) != DBNull.Value)
{
obj.ApplyDateTime = reader.GetDateTime(4);
}
if (reader.GetValue(5) != DBNull.Value)
{
obj.FileCode = reader.GetString(5);
}
if (reader.GetValue(6) != DBNull.Value)
{
obj.FileTemplateCode = reader.GetInt32(6);
}
if (reader.GetValue(7) != DBNull.Value)
{
obj.VersionNumber = reader.GetString(7);
}
if (reader.GetValue(8) != DBNull.Value)
{
obj.SortCode = reader.GetString(8);
}
if (reader.GetValue(9) != DBNull.Value)
{
obj.DoucmentMarkingSN = reader.GetString(9);
}
if (reader.GetValue(10) != DBNull.Value)
{
obj.Subject = reader.GetString(10);
}
if (reader.GetValue(11) != DBNull.Value)
{
obj.Content = reader.GetString(11);
}
if (reader.GetValue(12) != DBNull.Value)
{
obj.Remark = reader.GetString(12);
}
if (reader.GetValue(13) != DBNull.Value)
{
obj.ArchiveType = reader.GetString(13);
}
if (reader.GetValue(14) != DBNull.Value)
{
obj.ArchiveState = reader.GetString(14);
}
if (reader.GetValue(15) != DBNull.Value)
{
obj.ArchiveDatetime = reader.GetDateTime(15);
}
if (reader.GetValue(0x10) != DBNull.Value)
{
obj.AuditingState = reader.GetString(0x10);
}
if (reader.GetValue(0x11) != DBNull.Value)
{
obj.AuditingDatetime = reader.GetDateTime(0x11);
}
if (reader.GetValue(0x12) != DBNull.Value)
{
obj.CreateDate = reader.GetDateTime(0x12);
}
if (reader.GetValue(0x13) != DBNull.Value)
{
obj.CreateUserCode = reader.GetString(0x13);
}
if (reader.GetValue(20) != DBNull.Value)
{
obj.LastModifyDatetime = reader.GetDateTime(20);
}
if (reader.GetValue(0x15) != DBNull.Value)
{
obj.LastModifyByUserCode = reader.GetString(0x15);
}
if (reader.GetValue(0x16) != DBNull.Value)
{
obj.DeleteFlag = reader.GetString(0x16);
}
if (reader.GetValue(0x17) != DBNull.Value)
{
obj.Counts = reader.GetInt32(0x17);
}
if (reader.GetValue(0x18) != DBNull.Value)
{
obj.Leaves = reader.GetInt32(0x18);
}
}
public int Delete(DocumentFileModel mObj)
{
return(this._Delete(mObj.Code));
}
private int _Update(DocumentFileModel mObj)
{
StringBuilder builder = new StringBuilder();
builder.Append("update DocumentFile set ");
if (mObj.OperationType != null)
{
builder.Append("OperationType=@OperationType,");
this._DataProcess.ProcessParametersAdd("@OperationType", SqlDbType.VarChar, 50, mObj.OperationType);
}
if (mObj.ApplyUserCode != null)
{
builder.Append("ApplyUserCode=@ApplyUserCode,");
this._DataProcess.ProcessParametersAdd("@ApplyUserCode", SqlDbType.VarChar, 50, mObj.ApplyUserCode);
}
if (mObj.ApplyDepartmentCode != null)
{
builder.Append("ApplyDepartmentCode=@ApplyDepartmentCode,");
this._DataProcess.ProcessParametersAdd("@ApplyDepartmentCode", SqlDbType.VarChar, 50, mObj.ApplyDepartmentCode);
}
if (mObj.ApplyDateTime != DateTime.MinValue)
{
builder.Append("ApplyDateTime=@ApplyDateTime,");
this._DataProcess.ProcessParametersAdd("@ApplyDateTime", SqlDbType.DateTime, 8, mObj.ApplyDateTime);
}
if (mObj.FileTemplateCode != 0)
{
builder.Append("FileTemplateCode=@FileTemplateCode,");
this._DataProcess.ProcessParametersAdd("@FileTemplateCode", SqlDbType.Int, 4, mObj.FileTemplateCode);
}
if (mObj.VersionNumber != null)
{
builder.Append("VersionNumber=@VersionNumber,");
this._DataProcess.ProcessParametersAdd("@VersionNumber", SqlDbType.VarChar, 100, mObj.VersionNumber);
}
if (mObj.SortCode != null)
{
builder.Append("SortCode=@SortCode,");
this._DataProcess.ProcessParametersAdd("@SortCode", SqlDbType.VarChar, 0x3e8, mObj.SortCode);
}
if (mObj.DoucmentMarkingSN != null)
{
builder.Append("DoucmentMarkingSN=@DoucmentMarkingSN,");
this._DataProcess.ProcessParametersAdd("@DoucmentMarkingSN", SqlDbType.VarChar, 100, mObj.DoucmentMarkingSN);
}
if (mObj.Subject != null)
{
builder.Append("Subject=@Subject,");
this._DataProcess.ProcessParametersAdd("@Subject", SqlDbType.VarChar, 100, mObj.Subject);
}
if (mObj.Content != null)
{
builder.Append("Content=@Content,");
this._DataProcess.ProcessParametersAdd("@Content", SqlDbType.VarChar, 0x10, mObj.Content);
}
if (mObj.Remark != null)
{
builder.Append("Remark=@Remark,");
this._DataProcess.ProcessParametersAdd("@Remark", SqlDbType.VarChar, 0x1f40, mObj.Remark);
}
if (mObj.ArchiveType != null)
{
builder.Append("ArchiveType=@ArchiveType,");
this._DataProcess.ProcessParametersAdd("@ArchiveType", SqlDbType.VarChar, 200, mObj.ArchiveType);
}
if (mObj.ArchiveState != null)
{
builder.Append("ArchiveState=@ArchiveState,");
this._DataProcess.ProcessParametersAdd("@ArchiveState", SqlDbType.VarChar, 100, mObj.ArchiveState);
}
if (mObj.ArchiveDatetime != DateTime.MinValue)
{
builder.Append("ArchiveDatetime=@ArchiveDatetime,");
this._DataProcess.ProcessParametersAdd("@ArchiveDatetime", SqlDbType.DateTime, 8, mObj.ArchiveDatetime);
}
if (mObj.AuditingState != null)
{
builder.Append("AuditingState=@AuditingState,");
this._DataProcess.ProcessParametersAdd("@AuditingState", SqlDbType.VarChar, 100, mObj.AuditingState);
}
if (mObj.AuditingDatetime != DateTime.MinValue)
{
builder.Append("AuditingDatetime=@AuditingDatetime,");
this._DataProcess.ProcessParametersAdd("@AuditingDatetime", SqlDbType.DateTime, 8, mObj.AuditingDatetime);
}
if (mObj.CreateDate != DateTime.MinValue)
{
builder.Append("CreateDate=@CreateDate,");
this._DataProcess.ProcessParametersAdd("@CreateDate", SqlDbType.DateTime, 8, mObj.CreateDate);
}
if (mObj.CreateUserCode != null)
{
builder.Append("CreateUserCode=@CreateUserCode,");
this._DataProcess.ProcessParametersAdd("@CreateUserCode", SqlDbType.VarChar, 50, mObj.CreateUserCode);
}
if (mObj.LastModifyDatetime != DateTime.MinValue)
{
builder.Append("LastModifyDatetime=@LastModifyDatetime,");
this._DataProcess.ProcessParametersAdd("@LastModifyDatetime", SqlDbType.DateTime, 8, mObj.LastModifyDatetime);
}
if (mObj.LastModifyByUserCode != null)
{
builder.Append("LastModifyByUserCode=@LastModifyByUserCode,");
this._DataProcess.ProcessParametersAdd("@LastModifyByUserCode", SqlDbType.VarChar, 50, mObj.LastModifyByUserCode);
}
if (mObj.DeleteFlag != null)
{
builder.Append("DeleteFlag=@DeleteFlag,");
this._DataProcess.ProcessParametersAdd("@DeleteFlag", SqlDbType.VarChar, 50, mObj.DeleteFlag);
}
if (mObj.FileCode != null)
{
builder.Append("FileCode=@FileCode,");
this._DataProcess.ProcessParametersAdd("@FileCode", SqlDbType.VarChar, 100, mObj.FileCode);
}
if (mObj.Counts != 0)
{
builder.Append("Counts=@Counts,");
this._DataProcess.ProcessParametersAdd("@Counts", SqlDbType.Int, 4, mObj.Counts);
}
if (mObj.Leaves != 0)
{
builder.Append("Leaves=@Leaves,");
this._DataProcess.ProcessParametersAdd("@Leaves", SqlDbType.Int, 4, mObj.Leaves);
}
builder.Remove(builder.Length - 1, 1);
builder.Append(" where Code=@Code");
this._DataProcess.ProcessParametersAdd("@Code", SqlDbType.Int, 4, mObj.Code);
this._DataProcess.CommandText = builder.ToString();
return(this._DataProcess.RunSql());
}
