private void FgCli_CellButtonClick(object sender, C1.Win.C1FlexGrid.RowColEventArgs e)
{
if (FgCli.Col == 1)
{
DataTable dtResult = new DataTable();
string c_dato = "";
objPro.mysConec = mysConec;
dtResult = objPro.BuscarCliPro(dtProv, 1, "n_id", "");
if (dtResult != null)
{
if (dtResult.Rows.Count != 0)
{
c_dato = dtResult.Rows[0]["c_nombre"].ToString();
FgCli.SetData(FgCli.Row, 1, c_dato);
c_dato = dtResult.Rows[0]["n_id"].ToString();
FgCli.SetData(FgCli.Row, 2, c_dato);
if (funFunciones.NulosC(FgCli.GetData(FgCli.Rows.Count - 1, 1)) != "")
{
FgCli.Rows.Count = FgCli.Rows.Count + 1;
}
}
}
}
}
void BuscarCLientes()
{
DataTable dtResult = new DataTable();
objClientes.mysConec = mysConec;
dtResult = objClientes.BuscarCliPro(dtClientes, 1, "n_id", "");
if (dtResult != null)
{
if (dtResult.Rows.Count != 0)
{
TxtNumRuc.Text = dtResult.Rows[0]["c_numdoc"].ToString();
LblIdCliente.Text = dtResult.Rows[0]["n_id"].ToString();
TxtNomCli.Text = dtResult.Rows[0]["c_nombre"].ToString();
TxtDireccion.Text = dtResult.Rows[0]["c_dir"].ToString();
//dtPrecios = objVentas.UltimoPrecioCliente(STU_SISTEMA.EMPRESAID, Convert.ToInt32(LblIdCliente.Text));
FgDetalle.Focus();
FgDetalle.Select(1, 1);
}
else
{
TxtNumRuc.Text = "";
LblIdCliente.Text = "";
TxtNomCli.Text = "";
TxtDireccion.Text = "";
}
}
}
private void CmdBusCliPro_Click(object sender, EventArgs e)
{
DataTable dtResult = new DataTable();
o_CliPro.mysConec = mysConec;
dtResult = o_CliPro.BuscarCliPro(dtCliPro, 1, "n_id", "");
if (dtResult != null)
{
if (dtResult.Rows.Count != 0)
{
LblIdCliPro.Text = dtResult.Rows[0]["n_id"].ToString();
LblCliPro.Text = dtResult.Rows[0]["c_nombre"].ToString();
}
else
{
LblIdCliPro.Text = "";
LblCliPro.Text = "";
}
}
}
private void CmdBusCli_Click(object sender, EventArgs e)
{
DataTable dtResult = new DataTable();
objPro.mysConec = mysConec;
dtResult = objPro.BuscarCliPro(dtPro, 2, "n_id", "");
if (dtResult != null)
{
if (dtResult.Rows.Count != 0)
{
TxtNumRuc.Text = dtResult.Rows[0]["c_numdoc"].ToString();
LblIdPro.Text = dtResult.Rows[0]["n_id"].ToString();
TxtPro.Text = dtResult.Rows[0]["c_nombre"].ToString();
}
else
{
TxtNumRuc.Text = "";
LblIdPro.Text = "";
TxtPro.Text = "";
}
}
}
private void FgCliente_CellButtonClick(object sender, C1.Win.C1FlexGrid.RowColEventArgs e)
{
if (FgItems.Col == 1)
{
DataTable dtResul = new DataTable();
string c_dato = "";
dtResul = objCli.BuscarCliPro(dtCli, 1, "n_id", "");
if (dtResul != null)
{
if (dtResul.Rows.Count != 0)
{
c_dato = dtResul.Rows[0]["c_nombre"].ToString(); // MOSTRAMOS LA DESCRIPCION DEL ITEM
FgCliente.SetData(FgCliente.Row, 1, c_dato);
c_dato = dtResul.Rows[0]["n_id"].ToString(); // MOSTRAMOS EL ID DEL ITEM
FgCliente.SetData(FgCliente.Row, 2, c_dato);
FgCliente.Rows.Count = FgCliente.Rows.Count + 1;
}
}
}
}
