public DataSet GetAll(string empresaid, tb_co_tabla03_banco BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCoTabla03Banco_SEARCH", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@codigoid", string.IsNullOrEmpty(BE.codigoid) ? (object)DBNull.Value : BE.codigoid);
cmd.Parameters.AddWithValue("@descripcion", string.IsNullOrEmpty(BE.descripcion) ? (object)DBNull.Value : BE.descripcion);
cmd.Parameters.AddWithValue("@sigla", string.IsNullOrEmpty(BE.sigla) ? (object)DBNull.Value : BE.sigla);
cmd.Parameters.AddWithValue("@usuar", string.IsNullOrEmpty(BE.usuar) ? (object)DBNull.Value : BE.usuar);
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
Sql_Error = ex.Message;
throw new Exception(ex.Message);
}
}
}
}
public bool Update(string empresaid, tb_co_tabla03_banco BE)
{
//return tablaDA.Update(empresaid, BE);
bool zreturn = tablaDA.Update(empresaid, BE);
Sql_Error = tablaDA.Sql_Error;
return zreturn;
}
public bool Delete(string empresaid, tb_co_tabla03_banco BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCoTabla03Banco_DELETE", cnx))
{
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@codigoid", SqlDbType.Char, 2).Value = BE.codigoid;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
Sql_Error = ex.Message;
throw new Exception(ex.Message);
}
}
}
}
public DataSet GetAllMaxCodigo(string empresaid, tb_co_tabla03_banco BE)
{
//return tablaDA.GetAllMaxRubro(empresaid, BE);
DataSet xreturn = null;
xreturn = tablaDA.GetAllMaxCodigo(empresaid, BE);
Sql_Error = tablaDA.Sql_Error;
return xreturn;
}
private BindingSource NewMethoBcoC()
{
var BL = new tb_co_tabla03_bancoBL();
var BE = new tb_co_tabla03_banco();
var table = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
var rows = table.Rows;
object[] cell;
var dic = new Dictionary<string, string>();
var binding = new BindingSource();
foreach (DataRow item in rows)
{
cell = item.ItemArray;
dic.Add(cell[0].ToString(), cell[0].ToString() + " - " + cell[1].ToString());
cell = null;
}
binding.DataSource = dic;
return binding;
}
public DataSet GetAllMaxCodigo(string empresaid, tb_co_tabla03_banco BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCoTabla03Banco_MAXCODIGO", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
Sql_Error = ex.Message;
throw new Exception(ex.Message);
}
}
}
}
public bool Insert(string empresaid, tb_co_tabla03_banco BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCoTabla03Banco_INSERT", cnx))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@codigoid", SqlDbType.Char, 2).Value = BE.codigoid;
cmd.Parameters.Add("@descripcion", SqlDbType.VarChar, 100).Value = BE.descripcion;
cmd.Parameters.Add("@sigla", SqlDbType.Char, 3).Value = BE.sigla;
cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar;
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
Sql_Error = ex.Message;
throw new Exception(ex.Message);
}
}
}
}
private void Accion(int naccion)
{
switch (naccion)
{
case 1:
u_n_opsel = 1;
U_RefrescaControles();
Blanquear();
var BL = new tb_co_tabla03_bancoBL();
var BE = new tb_co_tabla03_banco();
txtcodigo.Text = BL.GetAllMaxCodigo(VariablesPublicas.EmpresaID, BE).Tables[0].Rows[0]["maximo_codigo"].ToString();
if (Examinar.CurrentRow != null)
{
Examinar.CurrentRow.Selected = false;
}
break;
case 2:
POnedatos();
u_n_opsel = 2;
U_RefrescaControles();
Examinar.CurrentRow.Selected = true;
break;
case 3:
xnomcampo = "";
if (xnomcampo.Length == 0)
{
if (MessageBox.Show("Desea Eliminar Registro ..?", "Mensaje del Sistema", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
var BLCO = new tb_co_tabla03_bancoBL();
var BECO = new tb_co_tabla03_banco();
BECO.codigoid = Examinar.Rows[Examinar.CurrentRow.Index].Cells["codigoid"].Value.ToString();
tmpcursor = BLCO.GetAll(VariablesPublicas.EmpresaID, BECO).Tables[0];
if (BLCO.Sql_Error.Length == 0)
{
if (BLCO.Delete(VariablesPublicas.EmpresaID, BECO))
{
for (lc_cont = 0; lc_cont <= Tabla.Rows.Count - 1; lc_cont++)
{
if (Tabla.Rows[lc_cont]["codigoid"] == Examinar.Rows[Examinar.CurrentRow.Index].Cells["codigoid"].Value)
{
Tabla.Rows[lc_cont].Delete();
Tabla.AcceptChanges();
break;
}
}
Examinar.Refresh();
}
else
{
Frm_Class.ShowError(BLCO.Sql_Error, this);
}
}
else
{
Frm_Class.ShowError(BLCO.Sql_Error, this);
}
}
}
else
{
MessageBox.Show(xnomcampo, "Imposible Eliminar Registro");
}
break;
}
}
private void save()
{
if (u_Validate())
{
tmpcursor = null;
var BL = new tb_co_tabla03_bancoBL();
var BE = new tb_co_tabla03_banco();
BE.codigoid = txtcodigo.Text.Trim();
if (u_n_opsel == 1)
{
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID, BE).Tables[0];
if (tmptabla.Rows.Count > 0)
{
txtcodigo.Text = BL.GetAllMaxCodigo(VariablesPublicas.EmpresaID, BE).Tables[0].Rows[0]["maximo_codigo"].ToString();
}
BE.codigoid = txtcodigo.Text.Trim();
BE.descripcion = txtDescripcion.Text.Trim();
BE.sigla = txtSigla.Text.Trim();
BE.usuar = VariablesPublicas.Usuar.Trim();
if (BL.Insert(VariablesPublicas.EmpresaID, BE))
{
U_CancelarEdicion(0);
}
else
{
Frm_Class.ShowError(BL.Sql_Error, this);
}
}
else
{
BE.codigoid = txtcodigo.Text.Trim();
BE.descripcion = txtDescripcion.Text.Trim();
BE.sigla = txtSigla.Text.Trim();
BE.usuar = VariablesPublicas.Usuar.Trim();
if (BL.Update(VariablesPublicas.EmpresaID, BE))
{
U_CancelarEdicion(0);
}
else
{
Frm_Class.ShowError(BL.Sql_Error, this);
}
}
}
}
private void CargaDatos()
{
var sorted = default(SortOrder);
var xnomcolumna = string.Empty;
if (Examinar.SortedColumn != null)
{
xnomcolumna = Examinar.Columns[Examinar.SortedColumn.Index].Name;
sorted = Examinar.SortOrder;
}
var BL = new tb_co_tabla03_bancoBL();
var BE = new tb_co_tabla03_banco();
BE.descripcion = txtBuscar.Text.Trim();
Tabla = BL.GetAll(VariablesPublicas.EmpresaID, BE).Tables[0];
Examinar.AutoGenerateColumns = false;
Examinar.DataSource = Tabla;
VariablesPublicas.PintaEncabezados(Examinar);
if (xnomcolumna.Trim().Length > 0)
{
if (sorted == SortOrder.Ascending)
{
Examinar.Sort(Examinar.Columns[xnomcolumna], System.ComponentModel.ListSortDirection.Ascending);
}
else
{
Examinar.Sort(Examinar.Columns[xnomcolumna], System.ComponentModel.ListSortDirection.Descending);
}
}
else
{
Examinar.Sort(Examinar.Columns["codigoid"], System.ComponentModel.ListSortDirection.Ascending);
}
}
public void U_CargaDatos()
{
var xpalabra1 = string.Empty;
var xpalabra2 = string.Empty;
var xpalabra3 = string.Empty;
if (txtFilter.Enabled)
{
xpalabra1 = VariablesPublicas.Palabras(txtFilter.Text.Trim(), 1);
xpalabra2 = VariablesPublicas.Palabras(txtFilter.Text.Trim(), 2);
xpalabra3 = VariablesPublicas.Palabras(txtFilter.Text.Trim(), 3);
}
try
{
var BL = new tb_co_tabla03_bancoBL();
var BE = new tb_co_tabla03_banco();
switch (cboFiltro.SelectedItem.ToString())
{
case "Nombre":
BE.descripcion = txtFilter.Text.Trim().ToUpper();
break;
case "Código":
BE.codigoid = txtFilter.Text.Trim().ToUpper();
break;
default:
BE.codigoid = txtFilter.Text.Trim().ToUpper();
break;
}
tabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
btnBuscar.Enabled = true;
var sorted = default(SortOrder);
var xnomcolumna = string.Empty;
if ((gridExaminar.SortedColumn != null))
{
xnomcolumna = gridExaminar.Columns[gridExaminar.SortedColumn.Index].Name;
sorted = gridExaminar.SortOrder;
}
gridExaminar.AutoGenerateColumns = false;
gridExaminar.DataSource = tabla;
gridExaminar.AllowUserToResizeRows = false;
if (xnomcolumna.Trim().Length > 0)
{
if (sorted == SortOrder.Ascending)
{
gridExaminar.Sort(gridExaminar.Columns[xnomcolumna], System.ComponentModel.ListSortDirection.Ascending);
}
else
{
gridExaminar.Sort(gridExaminar.Columns[xnomcolumna], System.ComponentModel.ListSortDirection.Descending);
}
}
else
{
gridExaminar.Sort(gridExaminar.Columns["codigoid"], System.ComponentModel.ListSortDirection.Ascending);
}
if (gridExaminar.Rows.Count > 0)
{
gridExaminar.CurrentCell = gridExaminar.Rows[0].Cells["descripcion"];
gridExaminar.Focus();
gridExaminar.BeginEdit(true);
}
}
internal void ValidaBancos()
{
Int16 lc_cont;
var zhallado = false;
var VMNROITEM = gridBancos.Rows[gridBancos.CurrentRow.Index].Cells["bancoid"].Value.ToString();
var xcodartic = "..";
if (!(gridBancos.Rows[gridBancos.CurrentRow.Index].Cells["bancoid"].Value == DBNull.Value))
{
xcodartic = gridBancos.Rows[gridBancos.CurrentRow.Index].Cells["bancoid"].Value.ToString();
}
if (xcodartic.Trim().Length == 0)
{
zhallado = true;
}
else
{
var BL = new tb_co_tabla03_bancoBL();
var BE = new tb_co_tabla03_banco();
BE.codigoid = xcodartic;
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
for (lc_cont = 0; lc_cont < TablaBancos.Rows.Count; lc_cont++)
{
if (TablaBancos.Rows[lc_cont]["bancoid"].ToString() == VMNROITEM)
{
if (tmptabla.Rows.Count > 0)
{
TablaBancos.Rows[lc_cont]["bancoid"] = tmptabla.Rows[0]["codigoid"];
TablaBancos.Rows[lc_cont]["banconame"] = tmptabla.Rows[0]["descripcion"];
zhallado = true;
break;
}
}
}
}
if (!zhallado)
{
gridBancos.Rows[gridBancos.CurrentRow.Index].Cells["bancoid"].Value = j_CodBanco;
}
gridBancos.Refresh();
}
