public docDB.AttachmentDataTable Load()
{
this.sqlDa.SelectCommand = sqlSelectAll;
docDB.AttachmentDataTable dt = new docDB.AttachmentDataTable();
Fill(dt);
return(dt);
}
internal AttachmentBE(DocManager pBEMng)
: base(pBEMng, pBEMng.DB.Attachment)
{
myA = pBEMng;
myAttachmentDT = (docDB.AttachmentDataTable)myDT;
//if (myODAL == null)
// myODAL = myA.AtMng.DALMngr.GetAttachment();
}
public docDB.AttachmentDataTable LoadByAttachmentId(int AttachmentId)
{
this.sqlDa.SelectCommand = sqlSelect;
this.sqlSelect.Parameters.Clear();
this.sqlSelect.CommandText = "[AttachmentSelectByAttachmentId]";
this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@AttachmentId", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlSelect.Parameters["@AttachmentId"].Value = AttachmentId;
docDB.AttachmentDataTable dt = new docDB.AttachmentDataTable();
Fill(dt);
return(dt);
}
public byte[] LoadAll(int docId)
{
atriumDALManager aDAL = (atriumDALManager)this.DAL;
DataSet ds = new DataSet();
// ds.SchemaSerializationMode = SchemaSerializationMode.ExcludeSchema;
ds.RemotingFormat = SerializationFormat.Binary;
ds.Merge(this.Load(docId));
ds.Merge(aDAL.GetRecipient().LoadByDocId(docId));
docDB.AttachmentDataTable atts = aDAL.GetAttachment().LoadByMsgId(docId);
ds.Merge(atts);
foreach (docDB.AttachmentRow att in atts)
{
ds.Merge(this.Load(att.AttachmentId));
ds.Merge(aDAL.GetRecipient().LoadByDocId(att.AttachmentId));
}
FixTZDSIssue(ds);
return(atriumDALManager.CompressData(ds));
}
