public bool AnularDB(in_ProvisionIngresosPorOC_Info info)
{
try
{
using (SqlConnection connection = new SqlConnection(ConexionERP.GetConnectionString()))
{
connection.Open();
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "UPDATE [dbo].[in_ProvisionIngresosPorOC]"
+ " SET Estado = 0"
+ " ,[IdUsuarioAnulacion] = '" + info.IdUsuario + "'"
+ " ,[FechaAnulacion] = GETDATE()"
+ " WHERE IdEmpresa = " + info.IdEmpresa.ToString() + " and idprovision = " + info.IdProvision.ToString() + ";";
decimal IdCbteCble_rev = 0;
odatact.ReversoCbteCble(info.IdEmpresa,
info.IdCbteCble,
info.IdTipoCbte,
1,
ref IdCbteCble_rev,
ref MensajeError,
info.IdUsuario,
info.IdUsuario
);
command.ExecuteNonQuery();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public bool AnularDB(in_ProvisionIngresosPorOC_Info info)
{
try
{
return(odata.AnularDB(info));
}
catch (Exception)
{
throw;
}
}
public bool GuardarDB(in_ProvisionIngresosPorOC_Info info)
{
try
{
using (SqlConnection connection = new SqlConnection(ConexionERP.GetConnectionString()))
{
connection.Open();
SqlCommand command = new SqlCommand();
command.Connection = connection;
#region Diario
info.IdCbteCble = odatact.Get_IdCbteCble(info.IdEmpresa, info.IdTipoCbte, ref MensajeError);
command.CommandText = "INSERT INTO [dbo].[ct_cbtecble]([IdEmpresa],[IdTipoCbte],[IdCbteCble],[CodCbteCble],[IdPeriodo],[cb_Fecha],[cb_Valor],[cb_Observacion],[cb_Secuencia],[cb_Estado],[cb_Anio],[cb_mes]"
+ " ,[IdUsuario],[IdUsuarioAnu],[cb_MotivoAnu],[IdUsuarioUltModi],[cb_FechaAnu],[cb_FechaTransac],[cb_FechaUltModi],[cb_Mayorizado],[cb_para_conciliar],[IdSucursal])"
+ " VALUES(" + info.IdEmpresa.ToString() + "," + info.IdTipoCbte.ToString() + "," + info.IdCbteCble.ToString() + ",''," + info.Fecha.ToString("yyyyMM").ToString() + ",DATEFROMPARTS(" + info.Fecha.Year.ToString() + "," + info.Fecha.Month.ToString() + "," + info.Fecha.Day.ToString() + ")," + info.ListaDiario.Where(q => q.dc_Valor > 0).Sum(q => q.dc_Valor).ToString() + ",'" + info.Observacion + "',0,'A'," + info.Fecha.Year.ToString() + "," + info.Fecha.Month.ToString()
+ " ,'" + info.IdUsuario + "',NULL,NULL,NULL,NULL,GETDATE(),NULL,0,0,1);";
command.ExecuteNonQuery();
int Secuencia = 1;
command.CommandText = string.Empty;
foreach (var item in info.ListaDiario)
{
command.CommandText += "INSERT INTO [dbo].[ct_cbtecble_det]"
+ " ([IdEmpresa],[IdTipoCbte],[IdCbteCble],[secuencia],[IdCtaCble],[IdCentroCosto],[IdCentroCosto_sub_centro_costo],[dc_Valor],[dc_Observacion],[dc_Numconciliacion],[dc_EstaConciliado],[IdPunto_cargo],[IdPunto_cargo_grupo],[dc_para_conciliar])"
+ " VALUES(" + info.IdEmpresa.ToString() + "," + info.IdTipoCbte.ToString() + "," + info.IdCbteCble.ToString() + "," + Secuencia.ToString() + ",'" + item.IdCtaCble + "'," + (string.IsNullOrEmpty(item.IdCentroCosto) ? "NULL" : "'" + item.IdCentroCosto + "'") + "," + (string.IsNullOrEmpty(item.IdCentroCosto_sub_centro_costo) ? "NULL" : "'" + item.IdCentroCosto_sub_centro_costo + "'") + "," + item.dc_Valor.ToString() + ",'" + item.dc_Observacion + "',NULL,NULL," + (item.IdPunto_cargo == null ? "NULL" : item.IdPunto_cargo.ToString()) + "," + (item.IdPunto_cargo_grupo == null ? "NULL" : item.IdPunto_cargo_grupo.ToString()) + ",NULL);";
Secuencia++;
}
command.ExecuteNonQuery();
#endregion
#region Provision
info.IdProvision = GetID(info.IdEmpresa);
command.CommandText = "INSERT INTO [dbo].[in_ProvisionIngresosPorOC]([IdEmpresa],[IdProvision],[IdCtaCble],[Fecha],[Observacion],[IdTipoCbte],[IdCbteCble],[FechaIni],[FechaFin],[Estado],[IdUsuarioCreacion],[FechaCreacion])"
+ " VALUES(" + info.IdEmpresa.ToString() + "," + info.IdProvision.ToString() + ",'" + info.IdCtaCble + "',DATEFROMPARTS(" + info.Fecha.Year.ToString() + "," + info.Fecha.Month.ToString() + "," + info.Fecha.Day.ToString() + "),'" + info.Observacion + "'," + info.IdTipoCbte.ToString() + "," + info.IdCbteCble.ToString() + ",DATEFROMPARTS(" + info.FechaIni.Year.ToString() + "," + info.FechaIni.Month.ToString() + "," + info.FechaIni.Day.ToString() + "),DATEFROMPARTS(" + info.FechaFin.Year.ToString() + "," + info.FechaFin.Month.ToString() + "," + info.FechaFin.Day.ToString() + "),1,'" + info.IdUsuario + "',GETDATE())";
command.ExecuteNonQuery();
Secuencia = 1;
command.CommandText = string.Empty;
foreach (var item in info.ListaDetalle)
{
command.CommandText += "INSERT INTO [dbo].[in_ProvisionIngresosPorOCDet]([IdEmpresa],[IdProvision],[Secuencia],[IdSucursal],[IdMovi_inven_tipo],[IdNumMovi],[Secuencia_inv],[Costo])"
+ " VALUES(" + info.IdEmpresa.ToString() + "," + info.IdProvision.ToString() + "," + (Secuencia++).ToString() + "," + item.IdSucursal.ToString() + "," + item.IdMovi_inven_tipo.ToString() + "," + item.IdNumMovi.ToString() + "," + item.Secuencia_inv.ToString() + "," + item.Costo.ToString() + ");";
}
command.ExecuteNonQuery();
#endregion
}
return(true);
}
catch (Exception)
{
throw;
}
}
private void GetInfo()
{
info = info ?? new in_ProvisionIngresosPorOC_Info();
info.IdEmpresa = param.IdEmpresa;
info.IdProvision = string.IsNullOrEmpty(txtIdProvision.Text) ? 0 : Convert.ToDecimal(txtIdProvision.Text);
info.IdCtaCble = cmbPlanctaCabecera.EditValue.ToString();
info.IdTipoCbte = Convert.ToInt32(cmbTipoCbte.EditValue);
info.Observacion = txtObservacion.Text;
info.Fecha = deFecha.DateTime;
info.FechaIni = deFechaIni.DateTime;
info.FechaFin = deFechaFin.DateTime;
info.ListaDetalle = new List <in_ProvisionIngresosPorOCDet_Info>(blstDet);
info.ListaDiario = new List <ct_Cbtecble_det_Info>(blstDetCuenta);
}
public FrmIn_ProvisionIngresoOCMant()
{
InitializeComponent();
info = new in_ProvisionIngresosPorOC_Info();
bus = new in_ProvisionIngresosPorOC_Bus();
busDet = new in_ProvisionIngresosPorOCDet_Bus();
busPlancta = new ct_Plancta_Bus();
blstDet = new BindingList <in_ProvisionIngresosPorOCDet_Info>();
param = cl_parametrosGenerales_Bus.Instance;
busTipoCbte = new ct_Cbtecble_tipo_Bus();
busCentroCosto = new ct_Centro_costo_Bus();
busSubcentro = new ct_centro_costo_sub_centro_costo_Bus();
blstDetCuenta = new BindingList <ct_Cbtecble_det_Info>();
busDetConta = new ct_Cbtecble_det_Bus();
event_delegateFrmIn_ProvisionIngresoOCMant_FormClosed += FrmIn_ProvisionIngresoOCMant_event_delegateFrmIn_ProvisionIngresoOCMant_FormClosed;
}
public in_ProvisionIngresosPorOC_Info GetInfo(int IdEmpresa, decimal IdProvision)
{
try
{
in_ProvisionIngresosPorOC_Info info = new in_ProvisionIngresosPorOC_Info();
using (SqlConnection connection = new SqlConnection(ConexionERP.GetConnectionString()))
{
connection.Open();
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "select IdEmpresa,IdProvision,IdCtaCble,Fecha,Observacion,IdTipoCbte,IdCbteCble,FechaIni,FechaFin,Estado "
+ " from in_ProvisionIngresosPorOC"
+ " where IdEmpresa = " + IdEmpresa.ToString() + " and IdProvision = " + IdProvision.ToString();
var ResultValue = command.ExecuteScalar();
if (ResultValue == null)
{
return(null);
}
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
info = new in_ProvisionIngresosPorOC_Info
{
IdEmpresa = Convert.ToInt32(reader["IdEmpresa"]),
IdProvision = Convert.ToDecimal(reader["IdProvision"]),
IdCtaCble = Convert.ToString(reader["IdCtaCble"]),
Fecha = Convert.ToDateTime(reader["Fecha"]),
Observacion = Convert.ToString(reader["Observacion"]),
IdTipoCbte = Convert.ToInt32(reader["IdTipoCbte"]),
IdCbteCble = Convert.ToDecimal(reader["IdCbteCble"]),
FechaIni = Convert.ToDateTime(reader["FechaIni"]),
FechaFin = Convert.ToDateTime(reader["FechaFin"]),
Estado = Convert.ToBoolean(reader["Estado"])
};
}
reader.Close();
}
return(info);
}
catch (Exception)
{
throw;
}
}
private void gvConsulta_RowStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowStyleEventArgs e)
{
in_ProvisionIngresosPorOC_Info row = (in_ProvisionIngresosPorOC_Info)gvConsulta.GetRow(e.RowHandle);
if (row == null)
{
e.Appearance.ForeColor = Color.Black;
return;
}
if (!row.Estado)
{
e.Appearance.ForeColor = Color.Red;
return;
}
else
{
e.Appearance.ForeColor = Color.Black;
return;
}
}
private void SetInfoInControls()
{
if (info != null)
{
info = bus.GetInfo(param.IdEmpresa, info.IdProvision);
if (info != null)
{
txtIdProvision.Text = info.IdProvision.ToString();
cmbPlanctaCabecera.EditValue = info.IdCtaCble;
cmbTipoCbte.EditValue = info.IdTipoCbte;
txtObservacion.Text = info.Observacion;
deFecha.DateTime = info.Fecha;
deFechaIni.DateTime = info.FechaIni;
deFechaFin.DateTime = info.FechaFin;
blstDet = new BindingList <in_ProvisionIngresosPorOCDet_Info>(busDet.GetList(info.IdEmpresa, info.IdProvision));
blstDetCuenta = new BindingList <ct_Cbtecble_det_Info>(busDetConta.Get_list_Cbtecble_det(info.IdEmpresa, info.IdTipoCbte, info.IdCbteCble, ref MensajeError));
gcDet.DataSource = blstDet;
gcDiario.DataSource = blstDetCuenta;
}
}
}
private void LlamarFormulario(Cl_Enumeradores.eTipo_action Accion)
{
in_ProvisionIngresosPorOC_Info row = (in_ProvisionIngresosPorOC_Info)gvConsulta.GetFocusedRow();
if (Accion != Cl_Enumeradores.eTipo_action.grabar)
{
if (row == null)
{
MessageBox.Show("Seleccione un registro", param.Nombre_sistema, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (Accion != Cl_Enumeradores.eTipo_action.consultar && !row.Estado)
{
MessageBox.Show("El registro se encuentra anulado", param.Nombre_sistema, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
}
FrmIn_ProvisionIngresoOCMant frm = new FrmIn_ProvisionIngresoOCMant();
frm.MdiParent = this.MdiParent;
frm.SetInfo(Accion, row ?? new in_ProvisionIngresosPorOC_Info());
frm.event_delegateFrmIn_ProvisionIngresoOCMant_FormClosed += frm_event_delegateFrmIn_ProvisionIngresoOCMant_FormClosed;
frm.Show();
}
public bool ModificarDB(in_ProvisionIngresosPorOC_Info info)
{
try
{
using (SqlConnection connection = new SqlConnection(ConexionERP.GetConnectionString()))
{
connection.Open();
SqlCommand command = new SqlCommand();
command.Connection = connection;
#region Diario
command.CommandText = "UPDATE [dbo].[ct_cbtecble]"
+ " SET [IdPeriodo] = " + info.Fecha.ToString("yyyyMM")
+ " ,[cb_Fecha] = datefromparts(" + info.Fecha.Year.ToString() + "," + info.Fecha.Month.ToString() + "," + info.Fecha.Day.ToString() + ")"
+ " ,[cb_Valor] = " + info.ListaDiario.Sum(q => q.dc_Valor_D).ToString()
+ " ,[cb_Observacion] = '" + info.Observacion + "'"
+ " ,[cb_Anio] = " + info.Fecha.Year.ToString()
+ " ,[cb_mes] = " + info.Fecha.Month.ToString()
+ " ,[IdUsuarioUltModi] = '" + info.IdUsuario + "'"
+ " ,[cb_FechaUltModi] = GETDATE()"
+ " WHERE IdEmpresa = " + info.IdEmpresa.ToString() + " AND IdTipoCbte = " + info.IdTipoCbte.ToString() + " AND IdCbteCble = " + info.IdCbteCble.ToString() + ";";
command.CommandText += "DELETE [dbo].[ct_cbtecble_det] WHERE IdEmpresa = " + info.IdEmpresa.ToString() + " AND IdTipoCbte = " + info.IdTipoCbte.ToString() + " AND IdCbteCble = " + info.IdCbteCble.ToString() + ";";
int Secuencia = 1;
command.CommandText = string.Empty;
foreach (var item in info.ListaDiario)
{
command.CommandText += "INSERT INTO [dbo].[ct_cbtecble_det]"
+ " ([IdEmpresa],[IdTipoCbte],[IdCbteCble],[secuencia],[IdCtaCble],[IdCentroCosto],[IdCentroCosto_sub_centro_costo],[dc_Valor],[dc_Observacion],[dc_Numconciliacion],[dc_EstaConciliado],[IdPunto_cargo],[IdPunto_cargo_grupo],[dc_para_conciliar])"
+ " VALUES(" + info.IdEmpresa.ToString() + "," + info.IdTipoCbte.ToString() + "," + info.IdCbteCble.ToString() + "," + Secuencia.ToString() + ",'" + item.IdCtaCble + "'," + (string.IsNullOrEmpty(item.IdCentroCosto) ? "NULL" : "'" + item.IdCentroCosto + "'") + "," + (string.IsNullOrEmpty(item.IdCentroCosto_sub_centro_costo) ? "NULL" : "'" + item.IdCentroCosto_sub_centro_costo + "'") + "," + item.dc_Valor.ToString() + ",'" + item.dc_Observacion + "',NULL,NULL," + (item.IdPunto_cargo == null ? "NULL" : item.IdPunto_cargo.ToString()) + "," + (item.IdPunto_cargo_grupo == null ? "NULL" : item.IdPunto_cargo_grupo.ToString()) + ",NULL);";
Secuencia++;
}
#endregion
#region Provision
command.CommandText += "UPDATE [dbo].[in_ProvisionIngresosPorOC]"
+ " SET [IdCtaCble] = '" + info.IdCtaCble + "'"
+ " [Fecha] = DATEFROMPARTS(" + info.Fecha.Year.ToString() + "," + info.Fecha.Month.ToString() + "," + info.Fecha.Day.ToString() + ")"
+ " ,[Observacion] = '" + info.Observacion + "'"
+ " ,[FechaIni] = DATEFROMPARTS(" + info.FechaIni.Year.ToString() + "," + info.FechaIni.Month.ToString() + "," + info.FechaIni.Day.ToString() + ")"
+ " ,[FechaFin] = DATEFROMPARTS(" + info.FechaFin.Year.ToString() + "," + info.FechaFin.Month.ToString() + "," + info.FechaFin.Day.ToString() + ")"
+ " ,[IdUsuarioMod] = '" + info.IdUsuario + "'"
+ " ,[FechaModificacion] = GETDATE()"
+ " WHERE IdEmpresa = " + info.IdEmpresa.ToString() + " and idprovision = " + info.IdProvision.ToString() + ";";
Secuencia = 1;
command.CommandText = string.Empty;
command.CommandText += "DELETE [dbo].[in_ProvisionIngresosPorOCDet] WHERE IdEmpresa = " + info.IdEmpresa.ToString() + " and idprovision = " + info.IdProvision.ToString() + ";";
foreach (var item in info.ListaDetalle)
{
command.CommandText += "INSERT INTO [dbo].[in_ProvisionIngresosPorOCDet]([IdEmpresa],[IdProvision],[Secuencia],[IdSucursal],[IdMovi_inven_tipo],[IdNumMovi],[Secuencia_inv],[Costo])"
+ " VALUES(" + info.IdEmpresa.ToString() + "," + info.IdProvision.ToString() + "," + (Secuencia++).ToString() + "," + item.IdSucursal.ToString() + "," + item.IdMovi_inven_tipo.ToString() + "," + item.IdNumMovi.ToString() + "," + item.Secuencia_inv.ToString() + "," + item.Costo.ToString() + ");";
}
command.ExecuteNonQuery();
#endregion
}
return(true);
}
catch (Exception)
{
throw;
}
}
public void SetInfo(Cl_Enumeradores.eTipo_action _Accion, in_ProvisionIngresosPorOC_Info _info)
{
Accion = _Accion;
info = _info;
}
