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); }