private void AyudaProducto(String lpdescrlike) { try { var modd = string.Empty; var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); var dt = new DataTable(); BE.dominioid = dominioiddes.Trim(); BE.moduloid = moduloid; dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2) { modd = dt.Rows[0]["moduloshort"].ToString().Trim(); var frmayuda = new Ayudas.Form_help_requerimiento(); frmayuda.tipoo = "sql"; frmayuda.titulo = "<< AYUDA TABLA PRODUCTOS >>"; frmayuda.sqlquery = "SELECT tb1.productid, tb1.productname, tb2.stock, tb1.unmedenvase as unmedenvase ,tb2.costoultimo FROM tb_" + modd + "_productos AS tb1 "; frmayuda.sqlinner = "inner join tb_" + modd + "_local_stock as tb2 on tb1.productid = tb2.productid "; frmayuda.sqlwhere = "where "; frmayuda.sqland = string.Empty; frmayuda.criteriosbusqueda = new string[] { "PRODUCTO", "CODIGO" }; frmayuda.columbusqueda = "tb1.productname,tb1.productid"; frmayuda.returndatos = "0,1,2,3"; frmayuda.Owner = this; frmayuda.PasaProveedor = RecibeProducto; frmayuda.ShowDialog(); } } } catch (Exception ex) { throw ex; } }
private void data_cbo_moduloiddes() { try { var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); BE.dominioid = "60"; BE.status = "0"; var dt = new DataTable(); dt = BL.GetAll(VariablesPublicas.EmpresaID, BE).Tables[0]; cbo_modulo.DataSource = dt; cbo_modulo.ValueMember = "moduloid"; cbo_modulo.DisplayMember = "moduloname"; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void AyudaProducto(String lpdescrlike) { try { var modd = string.Empty; var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); var dt = new DataTable(); BE.dominioid = dominio.Trim(); BE.moduloid = modulo.Trim(); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2) { modd = dt.Rows[0]["moduloshort"].ToString().Trim(); var frmayuda = new Ayudas.Frm_help_general(); frmayuda.nameform = string.Empty; frmayuda.tipoo = "sql"; frmayuda.titulo = "<< AYUDA TABLA PRODUCTOS >>"; frmayuda.sqlquery = "SELECT tb1.productid, tb1.productname,tb2.lineaname,tb3.gruponame FROM tb_" + modd + "_productos AS tb1 "; frmayuda.sqlinner = "inner join tb_" + modd + "_linea as tb2 on tb1.lineaid = tb2.lineaid " + "inner join tb_" + modd + "_grupo as tb3 on tb1.grupoid = tb3.grupoid"; frmayuda.sqlwhere = "where"; frmayuda.sqland = string.Empty; frmayuda.criteriosbusqueda = new string[] { "PRODUCTO", "CODIGO", "LINEA", "GRUPO" }; frmayuda.columbusqueda = "tb1.productname,tb1.productid,tb2.lineaname,tb3.gruponame"; frmayuda.returndatos = "0,1"; frmayuda.Owner = this; frmayuda.PasaProveedor = RecibeProducto; frmayuda.ShowDialog(); } } } catch (Exception ex) { } }
private void AyudaGrupo(String lpdescrlike) { try { var modd = string.Empty; var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); var dt = new DataTable(); BE.dominioid = dominio; BE.moduloid = cbo_almacenes.SelectedValue.ToString(); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2) { modd = dt.Rows[0]["moduloshort"].ToString().Trim(); var frmayuda = new Ayudas.Frm_help_general(); frmayuda.tipoo = "sql"; frmayuda.titulo = "<< AYUDA TABLA GRUPOS >>"; frmayuda.sqlquery = " SELECT ctacte, ctactename FROM tb_cliente "; frmayuda.sqlinner = string.Empty; frmayuda.sqlwhere = " where "; frmayuda.sqland = string.Empty; frmayuda.criteriosbusqueda = new string[] { "PROVEEDOR", "CODIGO" }; frmayuda.columbusqueda = "ctactename,ctacte"; frmayuda.returndatos = "0,1"; frmayuda.Owner = this; frmayuda.PasaProveedor = RecibeGrupo; frmayuda.ShowDialog(); } } } catch (Exception ex) { } }
private void AyudaCliente(String lpdescrlike) { try { String modd = ""; sys_moduloBL BL = new sys_moduloBL(); tb_sys_modulo BE = new tb_sys_modulo(); DataTable dt = new DataTable(); BE.dominioid = dominioid.Text.ToString(); BE.moduloid = moduloid.Text.ToString(); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2) { modd = dt.Rows[0]["moduloshort"].ToString().Trim(); Ayudas.Frm_help_general frmayuda = new Ayudas.Frm_help_general(); frmayuda.tipoo = "sql"; //sql,tabla frmayuda.titulo = "<< AYUDA TABLA GRUPOS >>"; frmayuda.sqlquery = " SELECT ctacte, ctactename ,nmruc FROM tb_cliente "; frmayuda.sqlinner = ""; //inner frmayuda.sqlwhere = " where "; //where frmayuda.sqland = "";//and frmayuda.criteriosbusqueda = new string[] { "PROVEEDOR", "CODIGO" }; frmayuda.columbusqueda = "ctactename,ctacte"; frmayuda.returndatos = "0,1,2"; frmayuda.Owner = this; frmayuda.PasaProveedor = RecibeCliente; frmayuda.ShowDialog(); } } } catch (Exception ex) { } }
private void AyudaColor(String lpdescrlike) { try { String modd = ""; sys_moduloBL BL = new sys_moduloBL(); tb_sys_modulo BE = new tb_sys_modulo(); DataTable dt = new DataTable(); BE.dominioid = dominio; BE.moduloid = modulo; dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2) { modd = dt.Rows[0]["moduloshort"].ToString().Trim(); Ayudas.Frm_help_general frmayuda = new Ayudas.Frm_help_general(); frmayuda.tipoo = "sql"; //sql,tabla,all frmayuda.titulo = "Ayuda Color"; frmayuda.sqlquery = "select colorid, colorname from tb_" + modd + "_color"; frmayuda.sqlinner = ""; //inner frmayuda.sqlwhere = "where"; //where frmayuda.sqland = "";//and frmayuda.criteriosbusqueda = new string[] { "COLOR", "CÓDIGO" }; frmayuda.columbusqueda = "colorname,colorid"; frmayuda.returndatos = "0,1"; frmayuda.Owner = this; frmayuda.PasaProveedor = RecibeColor; frmayuda.ShowDialog(); } } } catch (Exception ex) { } }
private void Ayudasubgrupo(String lpdescrlike) { try { String modd = ""; sys_moduloBL BL = new sys_moduloBL(); tb_sys_modulo BE = new tb_sys_modulo(); DataTable dt = new DataTable(); BE.dominioid = dominio; BE.moduloid = modulo; dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2) { modd = dt.Rows[0]["moduloshort"].ToString().Trim(); Ayudas.Frm_help_general frmayuda = new Ayudas.Frm_help_general(); frmayuda.tipoo = "sql"; //sql,tabla frmayuda.titulo = "<< AYUDA TABLA ARTICULO >>"; frmayuda.sqlquery = "SELECT (lineaid + gr.grupoid + subgrupoid) as Codigo,lineaid,gr.grupoid,g.gruponame,subgrupoid,subgruponame,g.ctacte FROM tb_" + modd + "_subgrupo gr "; if (modd == "sm") {frmayuda.sqlinner = " Inner Join tb_" + modd + "_grupo g on gr.grupoid = g.grupoid and gr.status = '0' ";} else { frmayuda.sqlinner = " Inner Join tb_" + modd + "_grupo g on gr.grupoid = g.grupoid and gr.status = '0' "; } if (lineaid.Text.Trim().Length > 0 && grupoid.Text.Trim().Length > 0) { frmayuda.sqlwhere = "WHERE lineaid = " + lineaid.Text + " and gr.grupoid = " + grupoid.Text + " "; //where frmayuda.sqland = "and";//and } else if (lineaid.Text.Trim().Length > 0) { frmayuda.sqlwhere = "WHERE lineaid = " + lineaid.Text + " "; //where frmayuda.sqland = "and";//and } else if (grupoid.Text.Trim().Length > 0) { frmayuda.sqlwhere = "WHERE gr.grupoid = " + grupoid.Text + " "; //where frmayuda.sqland = "and";//and } else { frmayuda.sqlwhere = "where"; //where frmayuda.sqland = "";//and } frmayuda.criteriosbusqueda = new string[] {"ARTICULO", "CODIGO" }; frmayuda.columbusqueda = "subgruponame,lineaid + gr.grupoid + subgrupoid"; frmayuda.returndatos = "1,2,4,6"; frmayuda.Owner = this; frmayuda.PasaProveedor = RecibeSubgrupo; frmayuda.ShowDialog(); } } } catch (Exception ex) { } }
private void ValidaModulo() { if (moduloid.Text.Trim().Length > 0) { sys_moduloBL BL = new sys_moduloBL(); tb_sys_modulo BE = new tb_sys_modulo(); DataTable dt = new DataTable(); BE.dominioid = "60"; BE.moduloid = moduloid.Text.Trim(); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { moduloid.Text = dt.Rows[0]["moduloid"].ToString().Trim(); moduloname.Text = dt.Rows[0]["moduloname"].ToString().Trim(); form_bloqueado(true); moduloid.Enabled = false; btn_cancelar.Enabled = true; btn_grabar.Enabled = true; btn_log.Enabled = true; mottrasladointname.Focus(); } else { moduloid.Text = ""; moduloname.Text = ""; } } else { moduloid.Text = ""; moduloname.Text = ""; } }
private void AyudaProducto(String lpdescrlike) { try { griddetallemov.CurrentCell = griddetallemov.Rows[griddetallemov.RowCount - 1].Cells["productname"]; var prod = Convert.ToString(griddetallemov.Rows[griddetallemov.CurrentCell.RowIndex].Cells["productid"].Value); var modd = string.Empty; var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); var dt = new DataTable(); BE.dominioid = dominio; BE.moduloid = modulo; dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2) { modd = dt.Rows[0]["moduloshort"].ToString().Trim(); var frmayuda = new Ayudas.Form_help_stockinventario(); frmayuda.tipoo = "sql"; frmayuda.titulo = "<< Ayuda Producto Inventariado >>"; frmayuda.sqlquery = " select li.productid," + " p.productname," + " li.stocklibros," + " li.stockfisico," + " li.diferencia," + " li.costopromlibros," + " li.costopromfisico " + " from tb_" + modd + "_local_stock_inventario li "; frmayuda.sqlinner = " left join tb_" + modd + "_productos p on li.productid = p.productid "; frmayuda.sqlwhere = "where"; frmayuda.criteriosbusqueda = new string[] { "PRODUCTO", "CODIGO" }; frmayuda.columbusqueda = "p.productname,li.productid"; frmayuda.returndatos = "0,1"; frmayuda.Owner = this; frmayuda.PasaProveedor = RecibeProductoRollo; if (prod == string.Empty) { prod = "_"; } frmayuda.txt_busqueda.Text = prod; frmayuda.btnbuscar.PerformClick(); frmayuda.ShowDialog(); } } } catch (Exception ex) { throw ex; } }
private void get_cbo_modulo() { var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); var dt = new DataTable(); BE.dominioid = dominio.Trim(); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { cbo_moduloides.DataSource = dt; cbo_moduloides.ValueMember = "moduloid"; cbo_moduloides.DisplayMember = "moduloname"; } }
private void Update() { try { if (dominioid.Text.Trim().Length != 2) { MessageBox.Show("Ingrese Código de Dominio", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (moduloid.Text.Trim().Length != 4) { MessageBox.Show("Ingrese Código de modulo", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { if (moduloname.Text.Trim().Length == 0) { MessageBox.Show("Ingrese nombre de modulo", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); BE.dominioid = dominioid.Text.Trim(); BE.moduloid = moduloid.Text.Trim(); BE.moduloname = moduloname.Text.Trim(); BE.moduloshort = moduloshort.Text.Trim(); if (BL.Update(EmpresaID, BE)) { SEGURIDAD_LOG("M"); MessageBox.Show("Datos modificado correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information); procesado = true; } } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Ayudasubgrupo(String lpdescrlike) { try { var modd = string.Empty; var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); var dt = new DataTable(); BE.dominioid = "60"; BE.moduloid = moduloiddes.SelectedValue.ToString(); if (moduloiddes.SelectedValue.ToString() == "0000") { MessageBox.Show("Seleccione Almacen", "Information"); return; } dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2) { modd = dt.Rows[0]["moduloshort"].ToString().Trim(); var frmayuda = new Ayudas.Frm_help_general(); frmayuda.tipoo = "sql"; frmayuda.titulo = "<< AYUDA TABLA ARTICULO >>"; frmayuda.sqlquery = "SELECT (lineaid + gr.grupoid + subgrupoid) as Codigo,lineaid,gr.grupoid,g.gruponame,subgrupoid,subgruponame,g.ctacte FROM tb_" + modd + "_subgrupo gr "; if (modd == "sm") { frmayuda.sqlinner = " Inner Join tb_" + modd + "_grupo g on gr.grupoid = g.grupoid and gr.status = '0' "; } else { frmayuda.sqlinner = " Inner Join tb_" + modd + "_grupo g on gr.grupoid = g.grupoid and gr.status = '0' "; } //if (txt_lineaid.Text.Trim().Length > 0 && txt_grupoid.Text.Trim().Length > 0) //{ // frmayuda.sqlwhere = "where lineaid = " + txt_lineaid.Text + " and g.grupoid = " + txt_grupoid.Text + " "; // frmayuda.sqland = "and"; //} //else //{ // if (txt_lineaid.Text.Trim().Length > 0) // { // frmayuda.sqlwhere = "where lineaid = " + txt_lineaid.Text + " "; // frmayuda.sqland = "and"; // } // else // { // if (txt_grupoid.Text.Trim().Length > 0) // { // frmayuda.sqlwhere = "where g.grupoid = " + txt_grupoid.Text + " "; // frmayuda.sqland = "and"; // } // else // { frmayuda.sqlwhere = "where"; frmayuda.sqland = string.Empty; // } //} //} frmayuda.criteriosbusqueda = new string[] { "ARTICULO", "CODIGO" }; frmayuda.columbusqueda = "subgruponame,subgrupoid"; frmayuda.returndatos = "1,2,4,6"; frmayuda.Owner = this; frmayuda.PasaProveedor = RecibeSubgrupo; frmayuda.ShowDialog(); } } } catch (Exception ex) { } }
private void Ayudasubgrupo(String lpdescrlike) { try { var modd = string.Empty; var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); var dt = new DataTable(); BE.dominioid = dominio; BE.moduloid = modulo; dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2) { modd = dt.Rows[0]["moduloshort"].ToString().Trim(); var frmayuda = new Ayudas.Frm_help_general(); frmayuda.tipoo = "sql"; frmayuda.titulo = "<< AYUDA TABLA ARTICULO >>"; frmayuda.sqlquery = "SELECT subgrupoid, subgruponame, lineaid, grupoid FROM tb_me_subgrupo "; frmayuda.sqlinner = string.Empty; if (lineaid.Text.Trim().Length > 0 && grupoid.Text.Trim().Length > 0) { frmayuda.sqlwhere = "where lineaid = " + lineaid.Text + " and grupoid = " + grupoid.Text + " "; frmayuda.sqland = "and"; } else { if (lineaid.Text.Trim().Length > 0) { frmayuda.sqlwhere = "where lineaid = " + lineaid.Text + " "; frmayuda.sqland = "and"; } else { if (grupoid.Text.Trim().Length > 0) { frmayuda.sqlwhere = "where grupoid = " + grupoid.Text + " "; frmayuda.sqland = "and"; } else { frmayuda.sqlwhere = "where"; frmayuda.sqland = string.Empty; } } } frmayuda.criteriosbusqueda = new string[] { "ARTICULO", "CODIGO" }; frmayuda.columbusqueda = "subgruponame,subgrupoid"; frmayuda.returndatos = "0,2,3"; frmayuda.Owner = this; frmayuda.PasaProveedor = RecibeSubgrupo; frmayuda.ShowDialog(); } } } catch (Exception ex) { } }
private void data_Tablamodulo() { try { if (Tablamodulo != null) { Tablamodulo.Rows.Clear(); var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); BE.dominioid = dominioid.Text.Trim(); Tablamodulo = BL.GetAll(EmpresaID, BE).Tables[0]; } if (Tablamodulo.Rows.Count > 0) { btn_imprimir.Enabled = true; gridmodulo.DataSource = Tablamodulo; gridmodulo.Rows[0].Selected = false; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void AyudaLinea(String lpdescrlike) { try { var modd = string.Empty; var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); var dt = new DataTable(); BE.dominioid = dominioiddes; BE.moduloid = moduloiddes.SelectedValue.ToString(); if (moduloiddes.SelectedValue.ToString() == "0000") { MessageBox.Show("Seleccione Almacen", "Information"); return; } dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2) { modd = dt.Rows[0]["moduloshort"].ToString().Trim(); var frmayuda = new Ayudas.Frm_help_general(); frmayuda.tipoo = "sql"; frmayuda.titulo = "<< AYUDA TABLA LINEA >>"; frmayuda.sqlquery = " SELECT sg.lineaid,li.lineaname "+ " FROM tb_" + modd + "_subgrupo sg " + " LEFT JOIN tb_" + modd + "_linea li on sg.lineaid = li.lineaid "; frmayuda.sqlinner = string.Empty; frmayuda.sqlwhere = "WHERE sg.subgrupoid = '"+txt_subgrupoid.Text+"' and grupoid = '"+txt_grupoid.Text+"' "; frmayuda.sqland = "AND"; frmayuda.criteriosbusqueda = new string[] { "LINEA", "CODIGO" }; frmayuda.columbusqueda = "lineaname,lineaid"; frmayuda.returndatos = "0,1"; frmayuda.Owner = this; frmayuda.PasaProveedor = RecibeLinea; frmayuda.ShowDialog(); } } } catch (Exception ex) { } }
private void AyudaProducto(String lpdescrlike) { try { var modd = string.Empty; var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); var dt = new DataTable(); BE.dominioid = "60"; BE.moduloid = cboModuloID.SelectedValue.ToString(); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2) { modd = dt.Rows[0]["moduloshort"].ToString().Trim(); var frmayuda = new Ayudas.Form_help_gridproducto(); frmayuda.xfamiliaid = familiaid.Text; frmayuda.xmoduloid = modulo.ToString(); frmayuda.tipoo = "sql"; frmayuda.titulo = "<< AYUDA TABLA PRODUCTOS >>"; frmayuda.sqlquery = "select tb1.productid, tb1.productname,tb1.unmed,tb2.stock, tb2.costoultimo as precventa, tb2.[local] from tb_" + modd + "_productos tb1 "; frmayuda.sqlinner = "left join tb_" + modd + "_local_stock tb2 on tb1.moduloid=tb2.moduloid and tb1.productid=tb2.productid"; frmayuda.sqlwhere = "where local ='" + local + "' and tb1.status = '0' "; frmayuda.sqland = "and"; frmayuda.criteriosbusqueda = new string[] { "PRODUCTO", "CODIGO" }; frmayuda.columbusqueda = "tb1.productname,tb1.productid"; frmayuda.returndatos = "0,1"; frmayuda.Owner = this; frmayuda.PasaProveedor = RecibeProductos; frmayuda.ShowDialog(); } } } catch (Exception ex) { } }
private void AyudaFamilia(String lpdescrlike) { try { var modd = string.Empty; var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); var dt = new DataTable(); BE.dominioid = "60"; BE.moduloid = cboModuloID.SelectedValue.ToString(); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2) { modd = dt.Rows[0]["moduloshort"].ToString().Trim(); var frmayuda = new Ayudas.Frm_help_general(); frmayuda.nameform = "color"; frmayuda.tipoo = "sql"; frmayuda.titulo = "<< AYUDA TABLA FAMILIA - TELA >>"; frmayuda.sqlquery = " SELECT es.estructuraid,te.lineaid,te.familiatelaid,(es.estructuraname+'-'+li.lineaname+'-'+te.familiatelaname)familia " + " FROM tb_" + modd + "_familiatela te "; frmayuda.sqlinner = " LEFT JOIN tb_" + modd + "_linea li ON te.lineaid = li.lineaid " + " LEFT JOIN tb_" + modd + "_estructura es ON es.estructuraid = li.estructuraid "; frmayuda.sqlwhere = " where"; frmayuda.criteriosbusqueda = new string[] { "FAMILIA", "CODIGO" }; frmayuda.columbusqueda = "te.familiatelaname,te.familiatelaid"; frmayuda.returndatos = "0,1,2,3"; frmayuda.Owner = this; frmayuda.PasaProveedor = RecibeFamilia; frmayuda.ShowDialog(); } } } catch (Exception ex) { } }
private void Validamodulo_nuevo() { if (dominioid.Text.Trim().Length == 2) { var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); var dt = new DataTable(); BE.dominioid = dominioid.Text.Trim(); BE.moduloid = moduloid.Text.Trim(); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count == 0) { mensaje.Text = "VALIDO"; mensaje.ForeColor = Color.Green; form_bloqueado(true); moduloname.Focus(); btn_cancelar.Enabled = true; btn_grabar.Enabled = true; } else { mensaje.Text = "YA EXISTE"; mensaje.ForeColor = Color.Red; moduloid.Focus(); } } }
private void ValidaModulo() { if (dominioid.Text.Trim().Length > 0) { sys_moduloBL BL = new sys_moduloBL(); tb_sys_modulo BE = new tb_sys_modulo(); DataTable dt = new DataTable(); BE.moduloid = moduloid.Text.Trim(); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { moduloid.Text = dt.Rows[0]["moduloid"].ToString().Trim(); moduloname.Text = dt.Rows[0]["moduloname"].ToString().Trim(); } else { moduloid.Text = ""; moduloname.Text = ""; } } else { moduloid.Text = ""; moduloname.Text = ""; } }
private void AyudaGrupo(String lpdescrlike) { try { var modd = string.Empty; var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); var dt = new DataTable(); BE.dominioid = dominioiddes; BE.moduloid = moduloiddes.SelectedValue.ToString(); if (moduloiddes.SelectedValue.ToString() == "0000") { MessageBox.Show("Seleccione Almacen", "Information"); return; } dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2) { modd = dt.Rows[0]["moduloshort"].ToString().Trim(); var frmayuda = new Ayudas.Frm_help_general(); frmayuda.tipoo = "sql"; frmayuda.titulo = "<< AYUDA TABLA GRUPOS >>"; frmayuda.sqlquery = "SELECT grupoid, gruponame FROM tb_" + modd + "_grupo g "; frmayuda.sqlinner = string.Empty; frmayuda.sqlwhere = "where g.status != '9' "; frmayuda.sqland = "and"; frmayuda.criteriosbusqueda = new string[] { "GRUPO", "CODIGO" }; frmayuda.columbusqueda = "gruponame,grupoid"; frmayuda.returndatos = "0,1"; frmayuda.Owner = this; frmayuda.PasaProveedor = RecibeGrupo; frmayuda.ShowDialog(); } } } catch (Exception ex) { } }
private void form_cargar_datos(String posicion) { try { sys_moduloBL BL = new sys_moduloBL(); tb_sys_modulo BE = new tb_sys_modulo(); DataTable dt = new DataTable(); BE.dominioid = dominioid.Text.Trim(); BE.moduloid = item.Text.Trim(); BE.posicion = posicion.Trim(); dt = BL.GetAll_paginacion(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { ssModo = "EDIT"; limpiar_documento(); dominioid.Text = dt.Rows[0]["dominioid"].ToString().Trim(); dominioname.Text = dt.Rows[0]["dominioname"].ToString().Trim(); item.Text = dt.Rows[0]["moduloid"].ToString().Trim(); localname.Text = dt.Rows[0]["moduloname"].ToString().Trim(); //moduloshort.Text = dt.Rows[0]["moduloshort"].ToString().Trim(); btn_editar.Enabled = true; btn_eliminar.Enabled = true; btn_imprimir.Enabled = true; btn_primero.Enabled = true; btn_anterior.Enabled = true; btn_siguiente.Enabled = true; btn_ultimo.Enabled = true; btn_log.Enabled = true; btn_salir.Enabled = true; } else { limpiar_documento(); btn_editar.Enabled = false; btn_eliminar.Enabled = false; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void AyudaLinea(String lpdescrlike) { try { var modd = string.Empty; var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); var dt = new DataTable(); BE.dominioid = dominio; BE.moduloid = modulo; dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2) { modd = dt.Rows[0]["moduloshort"].ToString().Trim(); var frmayuda = new Ayudas.Frm_help_general(); frmayuda.tipoo = "sql"; frmayuda.titulo = "<< AYUDA TABLA LINEA >>"; frmayuda.sqlquery = "SELECT lineaid, lineaname FROM tb_" + modd + "_linea "; frmayuda.sqlinner = string.Empty; frmayuda.sqlwhere = "where"; frmayuda.sqland = string.Empty; frmayuda.criteriosbusqueda = new string[] { "LINEA", "CODIGO" }; frmayuda.columbusqueda = "lineaname,lineaid"; frmayuda.returndatos = "0,1"; frmayuda.Owner = this; frmayuda.PasaProveedor = RecibeLinea; frmayuda.ShowDialog(); } } } catch (Exception ex) { } }
private void AyudaProducto(String lpdescrlike) { try { var modd = string.Empty; var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); var dt = new DataTable(); BE.dominioid = dominio; BE.moduloid = modulo; dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2) { modd = dt.Rows[0]["moduloshort"].ToString().Trim(); var frmayuda = new Ayudas.Frm_help_general(); frmayuda.tipoo = "sql"; frmayuda.titulo = "<< AYUDA TABLA PRODUCTOS >>"; frmayuda.sqlquery = "SELECT tb1.productid, tb1.productname, tb2.stock,tb2.costoultimo FROM tb_me_productos AS tb1 "; frmayuda.sqlinner = "INNER JOIN tb_me_local_stock as tb2 on tb1.productid = tb2.productid "; frmayuda.sqlwhere = "WHERE tb1.moduloid = '" + modulo + "' AND local = '" + local + "' "; frmayuda.sqland = "AND"; frmayuda.criteriosbusqueda = new string[] { "PRODUCTO", "CODIGO" }; frmayuda.columbusqueda = "tb1.productname,tb1.productid"; frmayuda.returndatos = "0,1"; frmayuda.Owner = this; frmayuda.PasaProveedor = RecibeProducto; frmayuda.ShowDialog(); } } } catch (Exception ex) { } }
private void Delete() { try { if (dominioid.Text.Trim().Length != 2) { MessageBox.Show("Ingrese Código de Dominio", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (moduloid.Text.Trim().Length != 4) { MessageBox.Show("Ingrese Código de modulo", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); BE.dominioid = dominioid.Text.Trim(); BE.moduloid = moduloid.Text.Trim(); if (BL.Delete(EmpresaID, BE)) { SEGURIDAD_LOG("E"); MessageBox.Show("Datos Eliminado correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information); NIVEL_FORMS(); data_Tablamodulo(); limpiar_documento(); form_bloqueado(false); btn_nuevo.Enabled = true; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void data_cbo_moduloiddes() { try { sys_moduloBL BL = new sys_moduloBL(); tb_sys_modulo BE = new tb_sys_modulo(); BE.dominioid = dominioiddes.Trim(); BE.status = "0"; moduloiddes.DataSource = BL.GetAll(EmpresaID, BE).Tables[0]; moduloiddes.ValueMember = "moduloid"; moduloiddes.DisplayMember = "moduloname"; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btn_precios_Click(object sender, EventArgs e) { try { var modd = string.Empty; var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); var dt = new DataTable(); BE.dominioid = dominioid; //VariablesPublicas.Dominioid; BE.moduloid = moduloid; //VariablesPublicas.Moduloid; dt = BL.GetAll(VariablesPublicas.EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2) { modd = dt.Rows[0]["moduloshort"].ToString().Trim(); var frmayuda = new Ayudas.Form_help_productoprecio(); frmayuda.tipoo = "sql"; frmayuda.titulo = " << *** Ayudas *** >>"; frmayuda.sqlquery = "SELECT tb1.productid " + ", tb2.productname " + ", tb1.stock " + ", tb1.costopromed " + ", tb1.valoractual as StockValor " + ", tb1.costoultimo as CostoSoles " + ", tb3.compra as Tcamb" + ", cast(tb1.costoultimo/cast(tb3.compra as decimal(10,4)) as decimal (10,4))as CostoDolar " + " FROM tb_" + modd + "_local_stock as tb1 "; frmayuda.sqlinner = "INNER JOIN tb_" + modd + "_productos as tb2 ON tb1.productid = tb2.productid " + "INNER JOIN tb_tipocambio as tb3 ON tb3.fecha = CONVERT(date, GETDATE(), 103) "; frmayuda.sqlwhere = "Where " + //"tb1.local = '" + VariablesPublicas.Local + "'" + "tb1.local = '" + local + "'" + "and tb2.status= 0 "; frmayuda.sqland = "and"; frmayuda.criteriosbusqueda = new string[] { "PRODUCTO", "CODIGO" }; frmayuda.columbusqueda = "tb2.productname,tb1.productid"; frmayuda.returndatos = "0,1"; frmayuda.Owner = this; frmayuda.ShowDialog(); } } } catch (Exception ex) { throw ex; } }
private void AyudaGrupo(String lpdescrlike) { try { var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); var dt = new DataTable(); BE.dominioid = dominio; BE.moduloid = modulo; dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { var frmayuda = new Ayudas.Frm_help_general(); frmayuda.tipoo = "sql"; frmayuda.titulo = "<< AYUDA TABLA GRUPOS >>"; frmayuda.sqlquery = "SELECT grupoid, gruponame FROM tb_me_grupo "; frmayuda.sqlinner = string.Empty; frmayuda.sqlwhere = "where moduloid=" + modulo; frmayuda.sqland = "and "; frmayuda.criteriosbusqueda = new string[] { "GRUPO", "CODIGO" }; frmayuda.columbusqueda = "gruponame,grupoid"; frmayuda.returndatos = "0,1"; frmayuda.Owner = this; frmayuda.PasaProveedor = RecibeGrupo; frmayuda.ShowDialog(); } } catch (Exception ex) { } }
private void AyudaProducto(String lpdescrlike) { try { var modd = string.Empty; var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); var dt = new DataTable(); BE.dominioid = "60"; BE.moduloid = cbomodulo.SelectedValue.ToString(); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2) { modd = dt.Rows[0]["moduloshort"].ToString().Trim(); var frmayuda = new Ayudas.Frm_help_general(); frmayuda.tipoo = "sql"; frmayuda.titulo = "<< AYUDA TABLA PRODUCTOS >>"; frmayuda.sqlquery = " SELECT tb1.productid,tb1.productidold, tb1.productname,"+ " SUM(IIF(mdet.almacaccionid = '10',mdet.cantidad * 1,mdet.cantidad *-1)) AS stock, " + " tb2.costoultimo FROM tb_" + modd + "_productos AS tb1 "; frmayuda.sqlinner = " INNER JOIN tb_" + modd + "_local_stock as tb2 on tb1.productid = tb2.productid "+ " LEFT JOIN tb_" + modd + "_movimientosdet mdet ON tb1.productid = mdet.productid "; frmayuda.sqlwhere = " WHERE "; frmayuda.sqland = string.Empty; frmayuda.sqlgroupby = " GROUP BY tb1.productid,tb1.productidold, tb1.productname,tb2.costoultimo "; frmayuda.criteriosbusqueda = new string[] { "PRODUCTO", "CODIGO", "CODIGO_ANT" }; frmayuda.columbusqueda = "tb1.productname,tb1.productid,tb1.productidold"; frmayuda.returndatos = "0,2"; frmayuda.Owner = this; frmayuda.PasaProveedor = RecibeProducto; frmayuda.ShowDialog(); } } } catch (Exception ex) { } }
private void AyudaProducto(String lpdescrlike) { try { var modd = string.Empty; var BL = new sys_moduloBL(); var BE = new tb_sys_modulo(); var dt = new DataTable(); BE.dominioid = dominio; BE.moduloid = modulo; dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2) { modd = dt.Rows[0]["moduloshort"].ToString().Trim(); var frmayuda = new Ayudas.Form_help_gridproducto(); frmayuda.tipoo = "sql"; frmayuda.titulo = "<< AYUDA PRODUCTO >>"; if (modulo == "0500") { // CAMBIAMOS COSTO ULTIMO X COSTO PROMEDIO frmayuda.sqlquery = " select tb1.productid, tb1.productname,tb1.unmed, "+ " SUM(IIF(mdet.almacaccionid = '10',mdet.cantidad * 1,mdet.cantidad *-1)) AS stock, " + " tb2.costopromed as precventa, tb2.[local],tb1.nserie from tb_" + modd + "_productos tb1 "; } else { //frmayuda.sqlquery = " select tb1.productid, tb1.productname,tb1.unmed, "+ // " SUM(IIF(mdet.almacaccionid = '10',mdet.cantidad * 1,mdet.cantidad *-1)) AS stock, " + // " tb2.costoultimo as precventa, tb2.[local] from tb_" + modd + "_productos tb1 "; frmayuda.sqlquery = " select tb1.productid, tb1.productname,tb1.unmed, " + " tb2.stock, " + " tb2.costopromed as precventa, tb2.[local] from tb_" + modd + "_productos tb1 "; } if (modulo == "0500") { frmayuda.sqlinner = " LEFT JOIN tb_" + modd + "_local_stock tb2 on tb1.moduloid = tb2.moduloid " + " AND tb1.productid = tb2.productid "+ " LEFT JOIN tb_" + modd + "_movimientosdet mdet ON tb1.productid = mdet.productid " + " AND tb2.local = mdet.local "; } else { frmayuda.sqlinner = " LEFT JOIN tb_" + modd + "_local_stock tb2 on tb1.moduloid = tb2.moduloid " + " AND tb1.productid = tb2.productid "; //+" LEFT JOIN tb_" + modd + "_movimientosdet mdet ON tb1.productid = mdet.productid "+ //" AND tb2.local = mdet.local "; } if (modulo == "0500") { frmayuda.sqlwhere = "where tb2.[local] ='" + local + "' "; } else { frmayuda.sqlwhere = "where tb2.[local] ='" + local + "' and tb1.status = '0' "; } frmayuda.sqland = "and"; if (modulo == "0500") { frmayuda.sqlgroupby = " GROUP BY tb1.productid " + ", tb1.productname " + ", tb1.unmed " + ", tb2.costopromed " + ", tb2.local " + ", tb1.nserie "; //frmayuda.sqlgroupby = ""; } else { //frmayuda.sqlgroupby = " GROUP BY tb1.productid " + // ", tb1.productname " + // ", tb1.unmed " + // ", tb2.costopromed " + // ", tb2.[local] "; frmayuda.sqlgroupby = ""; } frmayuda.criteriosbusqueda = new string[] { "PRODUCTO", "CODIGO" }; frmayuda.columbusqueda = "tb1.productname,tb1.productid"; frmayuda.returndatos = "0,1,2,6"; frmayuda.Owner = this; frmayuda.PasaProveedor = RecibeProductoRollo; frmayuda.ShowDialog(); } } } catch (Exception ex) { throw ex; } }
private void btn_precios_Click(object sender, EventArgs e) { try { String modd = ""; sys_moduloBL BL = new sys_moduloBL(); tb_sys_modulo BE = new tb_sys_modulo(); DataTable dt = new DataTable(); BE.dominioid = _dominioid; BE.moduloid = _moduloid; dt = BL.GetAll(VariablesPublicas.EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2) { modd = dt.Rows[0]["moduloshort"].ToString().Trim(); Ayudas.Form_help_productoprecio frmayuda = new Ayudas.Form_help_productoprecio(); frmayuda.tipoo = "sql"; //sql,tabla frmayuda.titulo = " << *** Ayudas *** >>"; frmayuda.sqlquery = "SELECT tb1.productid "+ ", tb2.productname "+ ", SUM(IIF(mdet.almacaccionid = '10',mdet.cantidad * 1,mdet.cantidad *-1)) AS stock " + ", tb1.costopromed " + ", tb1.valoractual as StockValor " + ", tb1.costoultimo as CostoSoles " + ", tb3.compra as Tcamb" + ", cast(tb1.costoultimo/cast(tb3.compra as decimal(10,4)) as decimal (10,4))as CostoDolar "+ " FROM tb_" + modd + "_local_stock as tb1 "; frmayuda.sqlinner = "INNER JOIN tb_" + modd + "_productos as tb2 ON tb1.productid = tb2.productid " + "INNER JOIN tb_tipocambio as tb3 ON tb3.fecha = CONVERT(date, GETDATE(), 103) " + "LEFT JOIN tb_" + modd + "_movimientosdet mdet ON tb2.productid = mdet.productid "; frmayuda.sqlwhere = "WHERE " + " tb1.local = '" + _local + "'" + " and tb2.status= 0 "; frmayuda.sqland = " and "; frmayuda.sqlgroupby = " GROUP BY tb1.productid " + ", tb2.productname " + ", tb1.costopromed " + ", tb1.valoractual " + ", tb1.costoultimo " + ", tb3.compra " + ", tb1.costoultimo "; frmayuda.criteriosbusqueda = new string[] { "PRODUCTO", "CODIGO" }; frmayuda.columbusqueda = "tb2.productname,tb1.productid"; frmayuda.returndatos = "0,1"; frmayuda.Owner = this; frmayuda.ShowDialog(); } } } catch (Exception ex) { throw ex; } }