private void AddExtensionToFileFormatTable(string ext, docDB.FileFormatDataTable ffTable)
{
if (obe == null)
{
obe = AtMng.GetCodeTableBE("FileFormat");
obe.Load();
}
CodesDB.FileFormatRow ffRow = (CodesDB.FileFormatRow)obe.Add(null);
ffRow.AllowEdit = false;
ffRow.AllowPreview = false;
ffRow.AllowSearch = true;
ffRow.AllowUpload = true;
ffRow.FileDescEng = "Lotus Notes Import";
ffRow.FileDescFre = "Lotus Notes Import";
ffRow.FileFormat = ext;
ffRow.IsBinary = false;
ffRow.EndEdit();
atLogic.BusinessProcess bp = AtMng.GetBP();
bp.AddForUpdate(obe);
bp.Update();
ffTable.ImportRow(ffRow);
}
public docDB.FileFormatDataTable Load()
{
this.sqlDa.SelectCommand = sqlSelectAll;
docDB.FileFormatDataTable dt = new docDB.FileFormatDataTable();
Fill(dt);
return(dt);
}
public docDB.FileFormatDataTable Load(string FileFormat)
{
this.sqlDa.SelectCommand = sqlSelect;
this.sqlSelect.Parameters.Clear();
this.sqlSelect.CommandText = "[FileFormatSelectByFileFormat]";
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("@FileFormat", System.Data.SqlDbType.NVarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlSelect.Parameters["@FileFormat"].Value = FileFormat;
docDB.FileFormatDataTable dt = new docDB.FileFormatDataTable();
Fill(dt);
return(dt);
}
