/// <summary> /// Fills a single instance with data based on its primary key values. /// </summary> public virtual void Fill(DataInformation datainformation, System.Int64 loanApplicationId) { // create the connection to use SqlConnection cnn = new SqlConnection(DataInformation.GetConnectionString()); try { // discover the sql parameters SqlParameterHash sqlparams = SqlHelperParameterCache.GetSpParameterSet(DataInformation.GetConnectionString(), "gsp_SelectDataInformation"); using (cnn) { // open the connection cnn.Open(); // set the parameters sqlparams["@loanApplicationId"].Value = loanApplicationId; // create an instance of the reader to fill. SqlDataReader datareader = SqlHelper.ExecuteReader(cnn, "gsp_SelectDataInformation", sqlparams); if (datareader.Read()) { datainformation.SetMembers(ref datareader); } cnn.Close(); // close the connection } // nullify the connection var cnn = null; } catch (SqlException sqlex) { throw sqlex; } }
/// <summary> /// Fill method for populating a collection by LOAN_APPLICATION /// </summary> public void FillByLoanApplication(DataInformationCollection dataInformationCollection, System.Int64 id) { // create the connection to use SqlConnection cnn = new SqlConnection(DataInformation.GetConnectionString()); try { // discover the sql parameters SqlParameterHash sqlparams = SqlHelperParameterCache.GetSpParameterSet(DataInformation.GetConnectionString(), "gsp_SelectDataInformationCollectionByLoanApplication"); using (cnn) { // open the connection cnn.Open(); // set the parameters sqlparams["@loanApplicationId"].Value = id; // create an instance of the reader to fill. SqlDataReader datareader = SqlHelper.ExecuteReader(cnn, "gsp_SelectDataInformationCollectionByLoanApplication", sqlparams); // Send the collection and data to the object factory. CreateObjectsFromData(dataInformationCollection, datareader); // close the connection cnn.Close(); } // nullify the connection cnn = null; } catch (SqlException sqlex) { throw sqlex; } }
private List <int> m_nodeFlag = new List <int>(); //控制划分子图,-1为噪声点,0为待划分的点,1为已划分的点 public ASCDT(DataInformation dataInfo, bool bLocal) { m_dataInfo = dataInfo; m_bLocal = bLocal; }
private DataInformation m_dataInfo; //相关信息 public DBSCAN(DataInformation dataInfo, double eps, int minPts) { m_dataInfo = dataInfo; m_dEps = eps; m_nMinPts = minPts; }
internal DataInformation SaveDataInformation(DataInformation DataInformation) { try { SetService(); return SerClient.SaveDataInformation(DataInformation); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
internal void DeleteDataInformation(DataInformation DataInformation) { try { SetService(); SerClient.DeleteDataInformation(DataInformation); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
private void OnSaveDetails(object sender, EventArgs e) { //Validacion si no existen datos para guardar if (View.Model.ListRecords.Rows.Count == 0) return; //Variables Auxiliares DataInformation DataInformationSerial; DataDefinitionByBin DataDefinitionControlIsRequired; Object ChildrenValue, ChildrenLabel; ShowData DetailDataSave; string XmlData; bool ControlIsRequired; try { try { foreach (DataRow DataRow in View.Model.ListRecords.Rows) { //Inicializo la lista de los datos a convertir en Xml View.Model.ListDetailsDataSave = new List<ShowData>(); //Obtengo los datos de cada campo con su nombre foreach (DataColumn c in View.Model.ListRecords.Columns) { //Obtengo el label y el valor digitado ChildrenLabel = c.ColumnName; ChildrenValue = DataRow[c.ColumnName].ToString(); //Evaluo si el campo es obligatorio ControlIsRequired = true; DataDefinitionControlIsRequired = (View.Model.CamposDetails.Where(f => f.DataDefinition.Code == ChildrenLabel).Count() > 0) ? View.Model.CamposDetails.Where(f => f.DataDefinition.Code == ChildrenLabel).First() : null; if (DataDefinitionControlIsRequired != null) { if (DataDefinitionControlIsRequired.DataDefinition.IsRequired == true && String.IsNullOrEmpty(ChildrenValue.ToString())) ControlIsRequired = false; else ControlIsRequired = true; } //Evaluo si puedo continuar dependiendo de si el dato era requerido y fue digitado o no if (ControlIsRequired) { //Creo el ShowData con los datos de ChildrenLabel y ChildrenValue DetailDataSave = new ShowData { DataKey = ChildrenLabel.ToString(), DataValue = ChildrenValue.ToString() }; //Adiciono cada dato a la lista View.Model.ListDetailsDataSave.Add(DetailDataSave); } else { Util.ShowError("El campo " + ChildrenLabel.ToString() + " no puede ser vacio."); return; } //Cargo el dato para la variable de ultimos procesados View.Model.UltimosProcesados = View.Model.UltimosProcesados + ChildrenValue.ToString() + " \t "; } //Convierto el listado de datos a un Xml XmlData = Util.XmlSerializerWF(View.Model.ListDetailsDataSave); //Creo el DataInformation del Serial para el Xml DataInformationSerial = new DataInformation { Entity = new ClassEntity { ClassEntityID = 20 }, EntityRowID = Int32.Parse(DataRow[0].ToString()), XmlData = XmlData, CreationDate = DateTime.Now, CreatedBy = App.curUser.UserName, ModDate = DateTime.Now }; //Guardo el Xml en la tabla DataInformation DataInformationSerial = service.SaveDataInformation(DataInformationSerial); //Ejecuto el proceso para cargar los datos a las tablas CargarDatosXML(DataInformationSerial); View.Model.UltimosProcesados = View.Model.UltimosProcesados + "\n"; } } catch (Exception ex) { Util.ShowError(ex.Message); } //COMPLETAR DOCUMENTO service.CreatePurchaseReceipt(View.Model.HeaderDocument); WindowInfo confirm = new WindowInfo(); confirm.Txt_Mensaje.Text = View.Model.UltimosProcesados; confirm.ShowDialog(); //Mensaje de confirmacion Util.ShowMessage("Datos Guardados exitosamente."); #region Nuevo Codigo DocumentoConsultado = service.GetDocument(new Document { DocNumber = View.NumeroDelDocumento.Text }).Where(f => f.DocNumber == View.NumeroDelDocumento.Text).ToList().First(); View.Model.ListaSerialesNoCargados = service.GetLabel(new WMSBusinessService.Label { Node = new Node { NodeID = NodeType.PreLabeled }, CreTerminal = View.Model.RecordCliente.LocationID.ToString(), ReceivingDocument = DocumentoConsultado }).Where(f => f.Node.NodeID == 1 && f.ReceivingDocument == DocumentoConsultado).ToList(); Util.ShowMessage("Los equipos cargados fueron guardados satisfactoriamente. \n" + "Equipos cargados: " + View.Model.ListRecords.Rows.Count + " \n" + "Equipos No cargador por error en la comunicacion con el servidor principal: " + View.Model.ListaSerialesNoCargados.Count); #endregion //Inicializo los campos de ingreso LimpiarDatosIngresoSeriales(); } catch (Exception Ex) { Util.ShowError("Hubo un error guardando los datos, por favor vuelva a intentarlo: " + Ex.Message); } }
public void CargarDatosXML(DataInformation Registro) { //Variables Auxiliares Document Document; WMSBusinessService.Label Label; string NombreTabla = ""; string updQuery = ""; IList<ShowData> metaData; try { if (Registro.Entity.ClassEntityID == EntityID.Document) { //Obtengo los datos del documento para tener el nombre de la bodega Document = service.GetDocument(new Document { DocID = Registro.EntityRowID }).First(); //Obtengo el nombre de la bodega que pertenece el registro y creo el nombre de la tabla NombreTabla = "Datos_" + Document.Location.ErpCode; } else if (Registro.Entity.ClassEntityID == EntityID.Label) { //Obtengo los datos del label para tener el nombre de la bodega Label = service.GetLabel(new WMSBusinessService.Label { LabelID = Registro.EntityRowID }).First(); try { Location location = service.GetLocation(new Location { LocationID = int.Parse(Label.CreTerminal) }).First(); NombreTabla = "Datos_" + location.ErpCode; } catch { //Obtengo el nombre de la bodega que pertenece el registro y creo el nombre de la tabla NombreTabla = "Datos_" + Label.Bin.Location.ErpCode; } } //Parte incial del update updQuery = "UPDATE dbo." + NombreTabla + " SET ModDate = GETDATE(), RowID = " + Registro.EntityRowID.ToString() + " "; //Obtiene la lista de campos a actualizar segun la bodega //Es decir los codgios de campos que son tus nombres de columna metaData = Util.DeserializeMetaDataWF(Registro.XmlData); if (metaData.Count == 0) { //Registro.ModTerminal = null; //service.UpdateDataInformation(Registro); return; } //Crear el Update //Aqui va contacenando nombre columna y valor para el update List<string> sColumns = new List<string>(); for (int i = 0; i < metaData.Count; i++) { if (metaData[i].DataKey.ToLower().Equals("id")) continue; if (metaData[i].DataKey.ToLower().Equals("productid")) continue; if (metaData[i].DataKey.ToLower().Equals("producto")) continue; if (metaData[i].DataKey.ToLower().Equals("cantidad")) continue; if (!sColumns.Contains(metaData[i].DataKey)) { updQuery += "," + metaData[i].DataKey + " = '" + metaData[i].DataValue + "' \n"; sColumns.Add(metaData[i].DataKey); } } //parte final del update updQuery += " WHERE InstanceID = " + Registro.RowID.ToString(); //Intenta crear el ID por si no existe //Esto lo hace por si el registro que vpy a actualizar no existe, entonces ///primero se crea un registro en blano en la tabla para que el update funcione ///el ID del registro deberia ser el LabelID para elc aso de los labels y el docuemntid en los docuemntos try { service.DirectSQLNonQuery("EXEC dbo.spAdminDynamicData 2, " + Registro.RowID.ToString() + ",'" + NombreTabla + "'," + Registro.Entity.ClassEntityID.ToString(), Local); } catch { } //Ejecutando el query service.DirectSQLNonQuery(updQuery, Local); //POniendo la entidad como actualizada /*Registro.ModTerminal = null; Factory.DaoDataInformation().Update(di); Console.WriteLine("OK => " + di.EntityRowID + ". " + di.RowID);*/ } catch (Exception ex) { //report the mistake. /*ExceptionMngr.WriteEvent("Routines: ", ListValues.EventType.Fatal, ex, null, ListValues.ErrorCategory.Business); Console.WriteLine(" ERR => " + di.EntityRowID + ". " + di.RowID + ". " + ex.Message);*/ } }
public Boolean Delete(DataInformation data) { return(base.Delete(data)); }
public DataInformation SelectById(DataInformation data) { return((DataInformation )base.SelectById(data)); }
public Boolean Update(DataInformation data) { return(base.Update(data)); }
public DataInformation Save(DataInformation data) { return((DataInformation )base.Save(data)); }
public void SetValues(IMapControl3 mapControl, DataInformation dataInfo) { m_mapControl = mapControl; m_dataInfo = dataInfo; AddLayerNames(); }
public InputAndOutput() { InitializeComponent(); m_dataInfo = new DataInformation(); }
public DataInformation ObterSelect(string ValTabela, string ValTexto1) { DataInformation Dt = null; Dt = new DataInformation(); Dt.ValDataTable = new DataTable(); var command = new SqlCommand(); command.Connection = Conexao.connection; int ValColuna = 0; try { if (ValTabela == "DROP CATEGORIA") { command.CommandText = "SELECT DISTINCT CAT.CATE FROM DBCATEGORIA CAT, DBANUNCIOS ANU, DBPRODUTO PRO, DBCIDADE CID, DBFORNECEDOR FRN WHERE CAT.SCAT='A' AND ANU.SANU='A' AND PRO.SPRD='A' AND CAT.CAT_ID=PRO.CAT_ID AND ANU.PRD_ID=PRO.PRD_ID AND ANU.DINI<=GETDATE() AND DATEADD(D,1,ANU.DFIM)>=GETDATE() AND FRN.CIDA=CID.CIDA AND FRN.ESTA=CID.ESTA AND ANU.FRN_ID=FRN.FRN_ID AND FRN.SFOR='A' AND CID.SCID='A' ORDER BY CAT.CATE"; Dt.ValDataTable.Columns.Add(new DataColumn("Categoria", typeof(string))); DataRow Dr = Dt.ValDataTable.NewRow(); Dr[0] = "Categorias"; Dt.ValDataTable.Rows.Add(Dr); ValColuna = 1; } if (ValTabela == "DROP LOJA") { command.CommandText = "SELECT DISTINCT FRN.FORN FROM DBCATEGORIA CAT, DBANUNCIOS ANU, DBPRODUTO PRO, DBCIDADE CID, DBFORNECEDOR FRN WHERE CAT.SCAT='A' AND ANU.SANU='A' AND PRO.SPRD='A' AND CAT.CAT_ID=PRO.CAT_ID AND ANU.PRD_ID=PRO.PRD_ID AND ANU.DINI<=GETDATE() AND DATEADD(D,1,ANU.DFIM)>=GETDATE() AND FRN.CIDA=CID.CIDA AND FRN.ESTA=CID.ESTA AND ANU.FRN_ID=FRN.FRN_ID AND FRN.SFOR='A' AND CID.SCID='A' ORDER BY FRN.FORN"; Dt.ValDataTable.Columns.Add(new DataColumn("Loja", typeof(string))); DataRow Dr = Dt.ValDataTable.NewRow(); Dr[0] = "Lojas"; Dt.ValDataTable.Rows.Add(Dr); ValColuna = 1; } if (ValTabela == "DROP CIDADE") { command.CommandText = "SELECT DISTINCT CID.CIDA FROM DBCATEGORIA CAT, DBANUNCIOS ANU, DBPRODUTO PRO, DBCIDADE CID, DBFORNECEDOR FRN WHERE CAT.SCAT='A' AND ANU.SANU='A' AND PRO.SPRD='A' AND CAT.CAT_ID=PRO.CAT_ID AND ANU.PRD_ID=PRO.PRD_ID AND ANU.DINI<=GETDATE() AND DATEADD(D,1,ANU.DFIM)>=GETDATE() AND FRN.CIDA=CID.CIDA AND FRN.ESTA=CID.ESTA AND ANU.FRN_ID=FRN.FRN_ID AND FRN.SFOR='A' AND CID.SCID='A' ORDER BY CID.CIDA"; Dt.ValDataTable.Columns.Add(new DataColumn("Cidade", typeof(string))); DataRow Dr = Dt.ValDataTable.NewRow(); Dr[0] = "Cidades"; Dt.ValDataTable.Rows.Add(Dr); ValColuna = 1; } else if (ValTabela == "ANUNCIO") { if (ValTexto1.ToUpper() == "ADMIN") { command.CommandText = "SELECT CAT.CATE, CAT.CPAI, CONVERT(VARCHAR(10), ANU.DINI, 103) AS DINI, CONVERT(VARCHAR(10), ANU.DFIM, 103) AS DFIM, PRO.PROD, ANU.PREC, FRN.FORN, FRN.LOJA, ANU.TIPO, ANU.LINK, ANU.ANU_ID FROM DBANUNCIOS ANU, DBFORNECEDOR FRN, DBPRODUTO PRO, DBCATEGORIA CAT WHERE ANU.FRN_ID = FRN.FRN_ID AND ANU.PRD_ID = PRO.PRD_ID AND PRO.CAT_ID = CAT.CAT_ID AND DATEADD(D,1,ANU.DFIM)>GETDATE() AND SANU = 'A' ORDER BY FRN.FORN, FRN.LOJA, ANU.TIPO, PRO.PROD"; } else { command.CommandText = "SELECT CAT.CATE, CAT.CPAI, CONVERT(VARCHAR(10), ANU.DINI, 103) AS DINI, CONVERT(VARCHAR(10), ANU.DFIM, 103) AS DFIM, PRO.PROD, ANU.PREC, FRN.FORN, FRN.LOJA, ANU.TIPO, ANU.LINK, ANU.ANU_ID FROM DBANUNCIOS ANU, DBFORNECEDOR FRN, DBPRODUTO PRO, DBCATEGORIA CAT, DBUSUARIO USU WHERE ANU.FRN_ID = FRN.FRN_ID AND ANU.PRD_ID = PRO.PRD_ID AND PRO.CAT_ID = CAT.CAT_ID AND DATEADD(D,1,ANU.DFIM)>GETDATE() AND ANU.SANU = 'A' AND FRN.FRN_ID = USU.FRN_ID AND USU.NUSU=UPPER('" + ValTexto1 + "') ORDER BY FRN.FORN, FRN.LOJA, ANU.TIPO, PRO.PROD"; } Dt.ValDataTable.Columns.Add(new DataColumn("0", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("1", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("2", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("3", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("4", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("5", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("6", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("7", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("8", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("9", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("10", typeof(string))); ValColuna = 11; } else if (ValTabela == "DROP FORNECEDOR CAD") { command.CommandText = "SELECT FORN+'-'+CAST(LOJA AS VARCHAR(4)) AS LOJA, FRN_ID FROM DBFORNECEDOR WHERE SFOR='A' ORDER BY FORN, LOJA"; Dt.ValDataTable.Columns.Add(new DataColumn("Loja Des", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("Loja Val", typeof(string))); DataRow Dr = Dt.ValDataTable.NewRow(); Dr[0] = "Lojas"; Dt.ValDataTable.Rows.Add(Dr); ValColuna = 2; } else if (ValTabela == "DROP TIPO") { command.CommandText = "SELECT TIPO + ' (R$ ' + CAST(CUST AS VARCHAR(6)) + ' /' + PERI + ')' AS TDES, PERI+TIPO FROM DBTIPO WHERE CONT=(SELECT CONT FROM DBFORNECEDOR WHERE FRN_ID=" + ValTexto1 + ") AND TIPO<>'PAINEL' ORDER BY CASE TIPO WHEN 'VERDE' THEN 1 WHEN 'VERMELHO' THEN 2 WHEN 'AZUL' THEN 3 ELSE 4 END, PERI"; Dt.ValDataTable.Columns.Add(new DataColumn("Tipo Des", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("Tipo Val", typeof(string))); DataRow Dr = Dt.ValDataTable.NewRow(); Dr[0] = "Tipo"; Dt.ValDataTable.Rows.Add(Dr); ValColuna = 2; } else if (ValTabela == "DROP CATEGORIA PAI") { command.CommandText = "SELECT DISTINCT CPAI FROM DBCATEGORIA WHERE CATE NOT IN (SELECT CPAI FROM DBCATEGORIA) AND SCAT = 'A' ORDER BY CPAI"; Dt.ValDataTable.Columns.Add(new DataColumn("Categoria", typeof(string))); DataRow Dr = Dt.ValDataTable.NewRow(); Dr[0] = "Categorias"; Dt.ValDataTable.Rows.Add(Dr); ValColuna = 1; } else if (ValTabela == "DROP CATEGORIA FILHO") { command.CommandText = "SELECT CATE, CAT_ID FROM DBCATEGORIA WHERE SCAT = 'A' AND CPAI = '" + ValTexto1 + "' ORDER BY CATE"; Dt.ValDataTable.Columns.Add(new DataColumn("Categoria Des", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("Categoria Val", typeof(string))); DataRow Dr = Dt.ValDataTable.NewRow(); Dr[0] = "Categorias"; Dt.ValDataTable.Rows.Add(Dr); ValColuna = 2; } else if (ValTabela == "DROP PRODUTO") { command.CommandText = "SELECT PROD, PRD_ID FROM DBPRODUTO WHERE CAT_ID = " + ValTexto1; Dt.ValDataTable.Columns.Add(new DataColumn("Produto Des", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("Produto Val", typeof(string))); DataRow Dr = Dt.ValDataTable.NewRow(); Dr[0] = "Produtos"; Dt.ValDataTable.Rows.Add(Dr); ValColuna = 2; } else if (ValTabela == "DROP ID ANUNCIO") { command.CommandText = "SELECT PRO.PROD+'-'+CAST(ANU.ANU_ID AS CHAR), ANU.ANU_ID FROM DBANUNCIOS ANU, DBPRODUTO PRO WHERE ANU.PRD_ID=PRO.PRD_ID AND ANU.SANU='A' AND PRO.SPRD='A' AND ANU.DFIM>=GETDATE() ORDER BY 1"; Dt.ValDataTable.Columns.Add(new DataColumn("ID Des", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("ID Val", typeof(string))); DataRow Dr = Dt.ValDataTable.NewRow(); Dr[0] = "ID"; Dt.ValDataTable.Rows.Add(Dr); ValColuna = 2; } else if (ValTabela == "PAINEL") { command.CommandText = "SELECT CONVERT(VARCHAR(10),PNL.DINI,103), CONVERT(VARCHAR(10),PNL.DFIM,103), FRN.FORN, FRN.LOJA, PNL.DPNL, PNL.LINK, PNL.PNL_ID FROM DBPAINEL PNL, DBFORNECEDOR FRN WHERE PNL.SPNL='A' AND DATEADD(D,1,PNL.DFIM) >= GETDATE() AND PNL.FRN_ID = FRN.FRN_ID AND FRN.SFOR='A' ORDER BY FRN.FORN, FRN.LOJA, PNL.DPNL"; Dt.ValDataTable.Columns.Add(new DataColumn("DATA INÍCIO", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("DATA FIM", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("NOME LOJA", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("NUM LOJA", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("DESCRIÇÃO", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("LINK", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("ID", typeof(string))); ValColuna = 7; } else if (ValTabela == "DROP TIPO PAINEL") { command.CommandText = "SELECT TIPO + ' (R$ ' + CAST(CUST AS VARCHAR(6)) + ' /' + PERI + ')' AS TDES, PERI+TIPO FROM DBTIPO WHERE CONT=(SELECT CONT FROM DBFORNECEDOR WHERE FRN_ID=" + ValTexto1 + ") AND TIPO='PAINEL' ORDER BY CASE TIPO WHEN 'VERDE' THEN 1 WHEN 'VERMELHO' THEN 2 WHEN 'AZUL' THEN 3 ELSE 4 END, PERI"; Dt.ValDataTable.Columns.Add(new DataColumn("Tipo Des", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("Tipo Val", typeof(string))); DataRow Dr = Dt.ValDataTable.NewRow(); Dr[0] = "Tipo"; Dt.ValDataTable.Rows.Add(Dr); ValColuna = 2; } else if (ValTabela == "PRODUTO") { command.CommandText = "SELECT CAT.CPAI, CAT.CATE, PRO.PROD, PRO.PDES, PRO.SPRD, PRO.PRD_ID FROM DBPRODUTO PRO, DBCATEGORIA CAT WHERE PRO.CAT_ID = CAT.CAT_ID ORDER BY PROD"; Dt.ValDataTable.Columns.Add(new DataColumn("0", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("1", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("2", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("3", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("4", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("5", typeof(string))); ValColuna = 6; } else if (ValTabela == "FORNECEDOR") { command.CommandText = "SELECT GRUP, FORN, LOJA, CNPJ, RAZA, NCEP, RUAV, NUME, BAIR, CIDA, ESTA, LINK, SFOR, FRN_ID FROM DBFORNECEDOR ORDER BY FORN, LOJA"; Dt.ValDataTable.Columns.Add(new DataColumn("0", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("1", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("2", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("3", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("4", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("5", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("6", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("7", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("8", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("9", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("10", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("11", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("12", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("13", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("14", typeof(string))); ValColuna = 15; } else if (ValTabela == "DROP ESTADO") { command.CommandText = "SELECT DISTINCT ESTA FROM DBCIDADE WHERE SCID = 'A' ORDER BY ESTA"; Dt.ValDataTable.Columns.Add(new DataColumn("Estados", typeof(string))); DataRow Dr = Dt.ValDataTable.NewRow(); Dr[0] = "Estado"; Dt.ValDataTable.Rows.Add(Dr); ValColuna = 1; } else if (ValTabela == "DROP CIDADE CAD") { command.CommandText = "SELECT CIDA FROM DBCIDADE WHERE SCID = 'A' AND ESTA = '" + ValTexto1 + "' ORDER BY CIDA"; Dt.ValDataTable.Columns.Add(new DataColumn("Cidades", typeof(string))); DataRow Dr = Dt.ValDataTable.NewRow(); Dr[0] = "Cidade"; Dt.ValDataTable.Rows.Add(Dr); ValColuna = 1; } else if (ValTabela == "CATEGORIA") { command.CommandText = "SELECT CPAI, CATE, SCAT, CAT_ID FROM DBCATEGORIA ORDER BY CPAI, CATE"; Dt.ValDataTable.Columns.Add(new DataColumn("CATEGORIA PAI", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("CATEGORIA FILHO", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("STATUS", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("ID", typeof(string))); ValColuna = 4; } else if (ValTabela == "CIDADE") { command.CommandText = "SELECT CIDA, ESTA, SCID, CID_ID FROM DBCIDADE ORDER BY CIDA"; Dt.ValDataTable.Columns.Add(new DataColumn("CIDADES", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("ESTADO", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("STATUS", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("ID", typeof(string))); ValColuna = 4; } else if (ValTabela == "USUARIOS") { command.CommandText = "SELECT FRN.FORN, FRN.LOJA, USU.NUSU, USU.SENH, USU.SUSU FROM DBUSUARIO USU, DBFORNECEDOR FRN WHERE USU.FRN_ID=FRN.FRN_ID AND USU.NVL_ID=0 ORDER BY 1, 2, 3"; Dt.ValDataTable.Columns.Add(new DataColumn("0", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("1", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("2", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("3", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("4", typeof(string))); ValColuna = 5; } else if (ValTabela == "EMPRESA") { command.CommandText = "SELECT FRN.FORN+'-'+CAST(FRN.LOJA AS VARCHAR(2)), FRN.FORN FROM DBUSUARIO USU, DBFORNECEDOR FRN WHERE USU.FRN_ID=FRN.FRN_ID AND USU.NUSU=UPPER('" + ValTexto1 + "');"; Dt.ValDataTable.Columns.Add(new DataColumn("0", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("1", typeof(string))); ValColuna = 2; } else if (ValTabela == "PRODUTO UNIT") { command.CommandText = "SELECT PROD, PDES, FOTO FROM DBPRODUTO WHERE PRD_ID=" + ValTexto1 + ";"; Dt.ValDataTable.Columns.Add(new DataColumn("0", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("1", typeof(string))); Dt.ValDataTable.Columns.Add(new DataColumn("2", typeof(string))); ValColuna = 3; } Conexao.Conectar(); var reader = command.ExecuteReader(); while (reader.Read()) { DataRow Dr = Dt.ValDataTable.NewRow(); if (ValColuna == 1) { Dr[0] = reader[0].ToString(); } else if (ValColuna == 2) { Dr[0] = reader[0].ToString(); Dr[1] = reader[1].ToString(); } else if (ValColuna == 3) { Dr[0] = reader[0].ToString(); Dr[1] = reader[1].ToString(); Dr[2] = reader[2].ToString(); } else if (ValColuna == 4) { Dr[0] = reader[0].ToString(); Dr[1] = reader[1].ToString(); Dr[2] = reader[2].ToString(); Dr[3] = reader[3].ToString(); } else if (ValColuna == 5) { Dr[0] = reader[0].ToString(); Dr[1] = reader[1].ToString(); Dr[2] = reader[2].ToString(); Dr[3] = reader[3].ToString(); Dr[4] = reader[4].ToString(); } else if (ValColuna == 6) { Dr[0] = reader[0].ToString(); Dr[1] = reader[1].ToString(); Dr[2] = reader[2].ToString(); Dr[3] = reader[3].ToString(); Dr[4] = reader[4].ToString(); Dr[5] = reader[5].ToString(); } else if (ValColuna == 7) { Dr[0] = reader[0].ToString(); Dr[1] = reader[1].ToString(); Dr[2] = reader[2].ToString(); Dr[3] = reader[3].ToString(); Dr[4] = reader[4].ToString(); Dr[5] = reader[5].ToString(); Dr[6] = reader[6].ToString(); } /*else if (ValColuna == 8) * { * Dr[0] = reader[0].ToString(); * Dr[1] = reader[1].ToString(); * Dr[2] = reader[2].ToString(); * Dr[3] = reader[3].ToString(); * Dr[4] = reader[4].ToString(); * Dr[5] = reader[5].ToString(); * Dr[6] = reader[6].ToString(); * Dr[7] = reader[7].ToString(); * } * else if (ValColuna == 9) * { * Dr[0] = reader[0].ToString(); * Dr[1] = reader[1].ToString(); * Dr[2] = reader[2].ToString(); * Dr[3] = reader[3].ToString(); * Dr[4] = reader[4].ToString(); * Dr[5] = reader[5].ToString(); * Dr[6] = reader[6].ToString(); * Dr[7] = reader[7].ToString(); * Dr[8] = reader[8].ToString(); * } * else if (ValColuna == 10) * { * Dr[0] = reader[0].ToString(); * Dr[1] = reader[1].ToString(); * Dr[2] = reader[2].ToString(); * Dr[3] = reader[3].ToString(); * Dr[4] = reader[4].ToString(); * Dr[5] = reader[5].ToString(); * Dr[6] = reader[6].ToString(); * Dr[7] = reader[7].ToString(); * Dr[8] = reader[8].ToString(); * Dr[9] = reader[9].ToString(); * }*/ else if (ValColuna == 11) { Dr[0] = reader[0].ToString(); Dr[1] = reader[1].ToString(); Dr[2] = reader[2].ToString(); Dr[3] = reader[3].ToString(); Dr[4] = reader[4].ToString(); Dr[5] = reader[5].ToString(); Dr[6] = reader[6].ToString(); Dr[7] = reader[7].ToString(); Dr[8] = reader[8].ToString(); Dr[9] = reader[9].ToString(); Dr[10] = reader[10].ToString(); } /*else if (ValColuna == 12) * { * Dr[0] = reader[0].ToString(); * Dr[1] = reader[1].ToString(); * Dr[2] = reader[2].ToString(); * Dr[3] = reader[3].ToString(); * Dr[4] = reader[4].ToString(); * Dr[5] = reader[5].ToString(); * Dr[6] = reader[6].ToString(); * Dr[7] = reader[7].ToString(); * Dr[8] = reader[8].ToString(); * Dr[9] = reader[9].ToString(); * Dr[10] = reader[10].ToString(); * Dr[11] = reader[11].ToString(); * } * else if (ValColuna == 13) * { * Dr[0] = reader[0].ToString(); * Dr[1] = reader[1].ToString(); * Dr[2] = reader[2].ToString(); * Dr[3] = reader[3].ToString(); * Dr[4] = reader[4].ToString(); * Dr[5] = reader[5].ToString(); * Dr[6] = reader[6].ToString(); * Dr[7] = reader[7].ToString(); * Dr[8] = reader[8].ToString(); * Dr[9] = reader[9].ToString(); * Dr[10] = reader[10].ToString(); * Dr[11] = reader[11].ToString(); * Dr[12] = reader[12].ToString(); * } * else if (ValColuna == 14) * { * Dr[0] = reader[0].ToString(); * Dr[1] = reader[1].ToString(); * Dr[2] = reader[2].ToString(); * Dr[3] = reader[3].ToString(); * Dr[4] = reader[4].ToString(); * Dr[5] = reader[5].ToString(); * Dr[6] = reader[6].ToString(); * Dr[7] = reader[7].ToString(); * Dr[8] = reader[8].ToString(); * Dr[9] = reader[9].ToString(); * Dr[10] = reader[10].ToString(); * Dr[11] = reader[11].ToString(); * Dr[12] = reader[12].ToString(); * Dr[13] = reader[13].ToString(); * }*/ else if (ValColuna == 15) { Dr[0] = reader[0].ToString(); Dr[1] = reader[1].ToString(); Dr[2] = reader[2].ToString(); Dr[3] = reader[3].ToString(); Dr[4] = reader[4].ToString(); Dr[5] = reader[5].ToString(); Dr[6] = reader[6].ToString(); Dr[7] = reader[7].ToString(); Dr[8] = reader[8].ToString(); Dr[9] = reader[9].ToString(); Dr[10] = reader[10].ToString(); Dr[11] = reader[11].ToString(); Dr[12] = reader[12].ToString(); Dr[13] = reader[13].ToString(); Dr[14] = reader[13].ToString(); } Dt.ValDataTable.Rows.Add(Dr); } reader.Close(); return(Dt); } catch { if (Dt != null) { return(Dt); } else { return(null); } } finally { Conexao.Desconectar(); } }