//public EspackFileDataContainer FdcData { get; set; } = new EspackFileDataContainer();
public fDocumentControl()
{
InitializeComponent();
//try
//{
//CTLM definitions
CTLM.Conn = Values.gDatos;
CTLM.sSPAdd = "pDocumentsCabAdd";
CTLM.DBTable = "vDocumentControl";
//var txtFileName = (EspackTextBox)fsFileData;
var FdcData = new EspackFileDataContainer();
//file containers
fsFileData.FileData = FdcData;
fsFileData.PDFFileData = FdcPDFData;
//Header
CTLM.AddItem(txtDocumentCode, "DocumentCode", CTLMControlTypes.NoAddPK);
CTLM.AddItem(txtTypeCode, "TypeCode", CTLMControlTypes.AddSearch);
CTLM.AddItem(txtSubtype, "SubTypeCode", CTLMControlTypes.AddSearch);
CTLM.AddItem(txtSection, "SectionCode", CTLMControlTypes.AddSearch);
CTLM.AddItem(txtTitle, "Title", CTLMControlTypes.AddSearch);
CTLM.AddItem(fsFileData, "DocumentFileName", CTLMControlTypes.AddSearch);
CTLM.AddItem(FdcData, "DATA", CTLMControlTypes.AddNoSearch);
CTLM.AddItem(FdcPDFData, "PDFDATA", CTLMControlTypes.AddNoSearch);
CTLM.AddItem(txtEdition, "Edition", CTLMControlTypes.Search);
CTLM.AddItem(txtStatus, "Status", CTLMControlTypes.Search);
CTLM.AddItem(lstFlags, "flags", CTLMControlTypes.AddSearch);
//Fields
lstFlags.Source("Select codigo,DescFlagEng from flags where Tabla='DocumentsCab'");
fsFileData.Click += BtnSearch_Click;
VS.Conn = Values.gDatos;
VS.SQL = "Select TypeCode,SectionCode,Title from DocumentsCab ";
VS.Start();
//Resize += FDocumentControl_Resize;
VS.UpdateEspackControl();
//CTLM.AddItem(VS);
//start
CTLM.ReQuery = true;
CTLM.AddDefaultStatusStrip();
CTLM.Start();
//VS.AddFilterCell(EspackCellTypes.WILDCARDTEXT, 0, "Select distinct TypeCode from DocumentsCab order by TypeCode");
this.Load += FDocumentControl_Load;
var c = VS.DataCellCollection;
//AcroPDFLib.AcroPDF acroPDF = new AcroPDFLib.AcroPDFClass();
//} catch (Exception ex)
//{
// CommonToolsWin.CTWin.MsgError(String.Format("Error 1: {0}\nError 2: {1}",ex.Message, ex.InnerException?.Message?? ""));
//}
}
public Form1()
{
InitializeComponent();
CTLM.Conn = new cAccesoDatosNet("DB01", "SISTEMAS", "sa", "5380");
txtUserCode.AutoCompleteMode = AutoCompleteMode.Suggest;
txtUserCode.AutoCompleteSource = AutoCompleteSource.CustomSource;
//txtUserCode.TextBox.Multiline = false;
var autoCompleteCustomSource = new AutoCompleteStringCollection();
txtText.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtText.AutoCompleteSource = AutoCompleteSource.CustomSource;
using (DynamicRS rs = new DynamicRS("Select UserCode from Users", CTLM.Conn))
{
rs.Open();
rs.ToList().ForEach(r => autoCompleteCustomSource.Add(r[0].ToString()));
}
txtUserCode.AutoCompleteCustomSource = autoCompleteCustomSource;
txtText.AutoCompleteCustomSource = autoCompleteCustomSource;
CTLM.DBTable = "vUsers";
CTLM.AddItem(txtUserCode, "UserCode", CTLMControlTypes.Search);
CTLM.AddItem(txtUserNumber, "UserNumber", CTLMControlTypes.Search);
CTLM.AddItem(txtPwdExp, "PasswordEXP", CTLMControlTypes.NoSearch);
CTLM.AddItem(cboMainCOD3, "MainCOD3", CTLMControlTypes.Search);
CTLM.AddItem(lstCOD3, "COD3", CTLMControlTypes.Search);
CTLM.AddItem(txtDesCod3, "desCOD3", CTLMControlTypes.NoSearch);
lstCOD3.Source("select n.COD3,Descripcion=n.cod3 from NetworkSedes n inner join general..sedes g on g.cod3=n.COD3 order by n.Cod3");
cboMainCOD3.Source("select n.COD3,g.Descripcion from NetworkSedes n inner join general..sedes g on g.cod3=n.COD3 order by n.Cod3", txtDesCod3);
CTLM.Start();
VS.Conn = CTLM.Conn;
VS.SQL = "Select UserCode, Area, COD3 from Users where usercode!='' order by UserCode";
VS.Start();
VS.UpdateEspackControl();
//VS.FilterRowEnabled = true;
}