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