public DataSet GetAll_paginacion(string empresaid, tb_cm_liquidacab BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbCmLiquidacab_SEARCH_paginacion", cnx)) { DataSet ds = new DataSet(); { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid; cmd.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local; cmd.Parameters.Add("@tipdoc", SqlDbType.Char, 2).Value = BE.tipdoc; cmd.Parameters.Add("@serdoc", SqlDbType.Char, 4).Value = BE.serdoc; cmd.Parameters.Add("@numdoc", SqlDbType.Char, 10).Value = BE.numdoc; cmd.Parameters.Add("@status", SqlDbType.Char, 1).Value = BE.status; cmd.Parameters.Add("@posicion", SqlDbType.VarChar, 10).Value = BE.posicion; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public bool Delete(string empresaid, tb_cm_liquidacab BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbCmequivalencia_DELETE", cnx)) { { cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.Add("@Equiv_id", SqlDbType.Char, 2).Value = BE.Equiv_id; } try { cnx.Open(); if (cmd.ExecuteNonQuery() > 0) { return true; } else { return false; } } catch (Exception ex) { throw new Exception(ex.Message); } } } }
private void Insert() { try { var BE = new tb_cm_liquidacab(); var BL = new tb_cm_liquidacabBL(); BE.tipdoc = tipdoc.Text.Trim(); BE.serdoc = moduloiddes.SelectedValue.ToString(); BE.numdoc = serdoc.Text.Trim() + numdoc.Text.Trim(); BE.moduloid = moduloiddes.SelectedValue.ToString(); BE.local = localdes.SelectedValue.ToString(); BE.tipref = tipguia.Text.Trim(); BE.serref = serguia.Text.Trim(); BE.numref = numguia.Text.Trim(); BE.fecre = Convert.ToDateTime(fechdoc.Text); BE.cif = Convert.ToDecimal(cif.Text.Trim()); BE.dua = Convert.ToDecimal(dua.Text.Trim()); BE.gas_impo = Convert.ToDecimal(gas_impo.Text.Trim()); BE.gas_financ = Convert.ToDecimal(gas_financ.Text.Trim()); BE.tot_bimp = Convert.ToDecimal(tot_bimp.Text.Trim()); BE.factorincre = Convert.ToDecimal(factorincre.Text.Trim()); BE.usuar = VariablesPublicas.Usuar.Trim(); BE.status = "0"; if (TablaDetalleImportacion2 != null) { TablaDetalleImportacion2.Clear(); } for (var i = 0; i < dgb_importacion1.RowCount; i++) { row = TablaDetalleImportacion2.NewRow(); row["tipdoc"] = tipdoc.Text.Trim(); row["serdoc"] = moduloiddes.SelectedValue.ToString(); row["numdoc"] = serdoc.Text.Trim() + numdoc.Text.Trim(); row["conceptoid"] = dgb_importacion1.GetRowCellValue(i, "conceptoid").ToString().Trim(); row["ctacte"] = dgb_importacion1.GetRowCellValue(i, "ctacte").ToString().Trim(); row["tipbou"] = dgb_importacion1.GetRowCellValue(i, "tipbou").ToString().Trim(); row["serbou"] = dgb_importacion1.GetRowCellValue(i, "serbou").ToString().Trim(); row["numbou"] = dgb_importacion1.GetRowCellValue(i, "numbou").ToString().Trim(); var fecha = dgb_importacion1.GetRowCellValue(i, "fechbou").ToString().Trim(); if (fecha.ToString().Trim().Length > 0 && fecha.ToString().Trim() != "-") { row["fechbou"] = dgb_importacion1.GetRowCellValue(i, "fechbou").ToString().Trim(); } row["bimp_sunat2"] = dgb_importacion1.GetRowCellValue(i, "bimp_sunat2").ToString().Trim(); row["tipcamb"] = dgb_importacion1.GetRowCellValue(i, "tipcamb").ToString().Trim(); row["bimp_sunat1"] = dgb_importacion1.GetRowCellValue(i, "bimp_sunat1").ToString().Trim(); row["pven"] = dgb_importacion1.GetRowCellValue(i, "pven").ToString().Trim(); row["status"] = "0".ToString().Trim(); row["usuar"] = VariablesPublicas.Usuar.Trim(); TablaDetalleImportacion2.Rows.Add(row); } if (BL.Insert(EmpresaID, BE, TablaDetalleImportacion2)) { MessageBox.Show("Datos Grabados Correctamente !!!", "Información", MessageBoxButtons.OK, MessageBoxIcon.Information); form_bloqueado(false); tipdoc.Enabled = false; btn_nuevo.Enabled = true; btn_imprimir.Enabled = true; btn_primero.Enabled = true; btn_anterior.Enabled = true; btn_siguiente.Enabled = true; btn_ultimo.Enabled = true; btn_salir.Enabled = true; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void form_cargar_datos(String posicion) { try { limpiar_documento(); var BL = new tb_cm_liquidacabBL(); var BE = new tb_cm_liquidacab(); var dt = new DataTable(); BE.moduloid = moduloiddes.SelectedValue.ToString(); BE.local = local.Trim(); BE.tipdoc = tipdoc.Text.Trim(); BE.serdoc = moduloiddes.SelectedValue.ToString(); if (serdoc.Text.Trim().Length == 0) { if (posicion.Trim().Length > 0) { MessageBox.Show("Seleccionar el Tipo de Documento !!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } return; } var n_doc = string.Empty; if (numdoc.Text.Trim().Length > 0) { n_doc = numdoc.Text.Trim().PadLeft(6, '0'); } BE.numdoc = serdoc.Text.ToString().Trim() + n_doc.ToString().Trim(); BE.posicion = posicion.Trim(); dt = BL.GetAll_paginacion(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { activeDoc = false; limpiar_documento(); form_bloqueado(false); ssModo = "EDIT"; var BL2 = new tb_60movimientoscabBL(); var BE2 = new tb_60movimientoscab(); var dt2 = new DataTable(); var n = dt.Rows[0]["numdoc"].ToString().Trim(); serdoc.Text = Equivalencias.Left(n, 4); numdoc.Text = Equivalencias.Right(n, 6); tipguia.Text = dt.Rows[0]["tipref"].ToString().Trim(); serguia.Text = dt.Rows[0]["serref"].ToString().Trim(); numguia.Text = dt.Rows[0]["numref"].ToString().Trim(); cif.Text = dt.Rows[0]["cif"].ToString().Trim(); dua.Text = dt.Rows[0]["dua"].ToString().Trim(); gas_impo.Text = dt.Rows[0]["gas_impo"].ToString().Trim(); gas_financ.Text = dt.Rows[0]["gas_financ"].ToString().Trim(); tot_bimp.Text = dt.Rows[0]["tot_bimp"].ToString().Trim(); factorincre.Text = dt.Rows[0]["factorincre"].ToString().Trim(); moduloiddes.SelectedValue = dt.Rows[0]["moduloid"].ToString().Trim(); data_cbo_localdes(dominioiddes, moduloiddes.SelectedValue.ToString()); localdes.SelectedValue = dt.Rows[0]["local"].ToString().Trim(); BE2.moduloid = moduloiddes.SelectedValue.ToString(); BE2.local = localdes.SelectedValue.ToString(); BE2.tipodoc = tipguia.Text.ToString(); BE2.serdoc = serguia.Text.ToString(); BE2.numdoc = numguia.Text; dt2 = BL2.GetAll2(EmpresaID, BE2).Tables[0]; if (dt2.Rows.Count > 0) { tipfac.Text = dt2.Rows[0]["tipfac"].ToString(); serfac.Text = dt2.Rows[0]["serfac"].ToString(); numfac.Text = dt2.Rows[0]["numfac"].ToString(); tipref.Text = dt2.Rows[0]["tipref"].ToString(); numdococ1.Text = Equivalencias.Left(dt2.Rows[0]["numref"].ToString(), 4); numdococ.Text = Equivalencias.Right(dt2.Rows[0]["numref"].ToString(), 6); ctacte.Text = dt2.Rows[0]["ctacte"].ToString(); ctactename.Text = dt2.Rows[0]["ctactename"].ToString(); } _CargarDetalleImportacion(); if (dt.Rows[0]["status"].ToString().Trim() != "9") { btn_nuevo.Enabled = true; 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_salir.Enabled = true; pictureEdit1.Visible = false; } else { ssModo = "ANULADO"; if (TablaDetalleImportacion2.Rows.Count > 0) { TablaDetalleImportacion2.Clear(); } dgb_importacion2.DataSource = TablaDetalleImportacion2; pictureEdit1.Visible = true; btn_editar.Enabled = false; btn_eliminar.Enabled = false; btn_nuevo.Enabled = true; btn_imprimir.Enabled = true; btn_primero.Enabled = true; btn_anterior.Enabled = true; btn_siguiente.Enabled = true; btn_ultimo.Enabled = true; btn_salir.Enabled = true; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool Update(string empresaid, tb_cm_liquidacab BE, DataTable DatDetalle) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbCmLiquida_UPDATE", cnx)) { cmd.CommandType = CommandType.StoredProcedure; // Parametros de Cabecera cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid; cmd.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local; cmd.Parameters.Add("@tipdoc", SqlDbType.Char, 2).Value = BE.tipdoc; cmd.Parameters.Add("@serdoc", SqlDbType.Char, 4).Value = BE.serdoc; cmd.Parameters.Add("@numdoc", SqlDbType.Char, 10).Value = BE.numdoc; cmd.Parameters.Add("@tipref", SqlDbType.Char, 2).Value = BE.tipref; cmd.Parameters.Add("@serref", SqlDbType.Char, 4).Value = BE.serref; cmd.Parameters.Add("@numref", SqlDbType.Char, 10).Value = BE.numref; cmd.Parameters.Add("@fecre", SqlDbType.DateTime).Value = BE.fecre; cmd.Parameters.Add("@tot_bimp", SqlDbType.Decimal).Value = BE.tot_bimp; cmd.Parameters.Add("@cif", SqlDbType.Decimal).Value = BE.cif; cmd.Parameters.Add("@dua", SqlDbType.Decimal).Value = BE.dua; cmd.Parameters.Add("@gas_impo", SqlDbType.Decimal).Value = BE.gas_impo; cmd.Parameters.Add("@gas_financ", SqlDbType.Decimal).Value = BE.gas_financ; cmd.Parameters.Add("@factorincre", SqlDbType.Decimal).Value = BE.factorincre; cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar; cmd.Parameters.Add("@status", SqlDbType.Char, 1).Value = BE.status; // Detalle cmd.Parameters.AddWithValue("@DetalleImp", DatDetalle); try { cnx.Open(); if (cmd.ExecuteNonQuery() > 0) { return true; } else { return false; } } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public List<tb_cm_liquidacab> Get_xcodigo(string empresaid, tb_cm_liquidacab BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbCmequivalencia_SEARCH", cnx)) { cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@Equiv_id", BE.Equiv_id); List<tb_cm_liquidacab> list = new List<tb_cm_liquidacab>(); try { cnx.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { tb_cm_liquidacab be = new tb_cm_liquidacab(); //be.Equiv_id = Convert.ToInt32(dr["Equiv_id"]); //be.Equiv_name = Convert.ToString(dr["Equiv_name"]); //be.Equivalencia = Convert.ToDecimal(dr["equivalencia"]); //be.Unmed1 = Convert.ToString(dr["unmed1"]); //be.Unmed2 = Convert.ToString(dr["unmed2"]); //be.descripcion1 = Convert.ToString(dr["descripcion1"]); //be.descripcion2 = Convert.ToString(dr["descripcion2"]); list.Add(be); } return list; } } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public List<tb_cm_liquidacab> Get_equivalencia(string empresaid, tb_cm_liquidacab BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbCmequivalencia_SEARCH", cnx)) { //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.Add("@Equiv_id", SqlDbType.Decimal,10).Value = BE.Equiv_id; List<tb_cm_liquidacab> list = new List<tb_cm_liquidacab>().ToList(); try { cnx.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { //tb_cm_liquidacab be = new tb_cm_liquidacab(); //be.Equivalencia = Convert.ToInt32(dr["equivalencia"]); //Int32 a = Convert.ToInt32(dr["equivalencia"]); //list.Add(be); // return BE; } return list; } } catch (Exception ex) { throw new Exception(ex.Message); } } } }