public int uspINS_valorizar_equipoMenor(BE_valorizar_equipoMenor oBESOl)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IDE_VAL, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.MES, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.ANIO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.Requ_Numero, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.Reqd_CodLinea, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.Reqs_Correlativo, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.Proy_Codigo, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.Prov_RUC, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FECHA_INICIO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FECHA_FIN, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IDE_MONEDA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.PRECIO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.DIA_TRABAJO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.DIA_DSCTO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.TOTAL, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.DESCUENTO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FLG_FASES, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.USER_VALORIZA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.ide_valor, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.OBSERVA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.HES, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.PERIODO_INICIO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.PERIODO_FIN, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.UNIDAD_TARIFA, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new UtilCareMenor().ExecuteScalar("uspINS_valorizar_equipoMenor", Parametros)));
}
public int uspINS_valorizar_equipoMenor(BE_valorizar_equipoMenor oBESOl)
{
try
{
return(new DA_TBL_RequerimientoSubDetalle().uspINS_valorizar_equipoMenor(oBESOl));
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnGuardar_Click(object sender, ImageClickEventArgs e)
{
int registroUpdate = 0;
string cleanMessage = string.Empty;
BL_TBL_RequerimientoSubDetalle obj = new BL_TBL_RequerimientoSubDetalle();
DataTable dtResultado = new DataTable();
if (GridView1.Rows.Count == 0)
{
cleanMessage = "No existe registros";
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true);
}
else
{
string Reqs_Correlativo;
string Requ_Numero;
string Reqd_CodLinea;
string ide_valor, Proy_Codigo, D_Prov_RUC, FLG_FASES;
foreach (GridViewRow row in GridView1.Rows)
{
Requ_Numero = GridView1.DataKeys[row.RowIndex].Values[0].ToString(); // extrae key
Reqd_CodLinea = GridView1.DataKeys[row.RowIndex].Values[1].ToString(); // extrae key
Reqs_Correlativo = GridView1.DataKeys[row.RowIndex].Values[2].ToString(); // extrae key
ide_valor = GridView1.DataKeys[row.RowIndex].Values[3].ToString(); // extrae key
Proy_Codigo = GridView1.DataKeys[row.RowIndex].Values[4].ToString(); // extrae key
D_Prov_RUC = GridView1.DataKeys[row.RowIndex].Values[5].ToString(); // extrae key
FLG_FASES = GridView1.DataKeys[row.RowIndex].Values[6].ToString(); // extrae key
if (Convert.ToInt32(FLG_FASES) < 3) // MIGRADO
{
if (D_Prov_RUC == string.Empty)
{
cleanMessage = "Falta definir proveedor para el Req. " + Requ_Numero;
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true);
}
else
{
//TextBox txtInicio = row.FindControl("txtInicio") as TextBox;
//TextBox txtTarifaDia = row.FindControl("txtTarifaDia") as TextBox;
TextBox txtObservacion = row.FindControl("txtObservacion") as TextBox;
TextBox txtDescuentoDia = row.FindControl("txtDescuentoDia") as TextBox;
TextBox txtDescuentoFinal = row.FindControl("txtDescuentoFinal") as TextBox;
TextBox txtHES = row.FindControl("txtHES") as TextBox;
Label lblDIAS_TRABAJO = row.FindControl("lblDIAS_TRABAJO") as Label;
Label lblTarifa_unidad = row.FindControl("lblTarifa_unidad") as Label;
Label lblTARIFA_DIA = row.FindControl("lblTARIFA_DIA") as Label;
Label lblV_FECHA_INICIO_VAL = row.FindControl("lblV_FECHA_INICIO_VAL") as Label;
Label lblV_FECHA_FIN_VAL = row.FindControl("lblV_FECHA_FIN_VAL") as Label;
Label lbl_ideMoneda = row.FindControl("lbl_ideMoneda") as Label;
TextBox txtInicioVal = row.FindControl("txtInicioVal") as TextBox;
TextBox txtFinVal = row.FindControl("txtFinVal") as TextBox;
if (lblTARIFA_DIA.Text == string.Empty)
{
cleanMessage = "Falta ingresar tarifa para el Req. " + Requ_Numero + "." + Reqd_CodLinea + "-" + Reqs_Correlativo;
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true);
}
else
{
//lblDIAS_TRABAJO.Text = ObtenerDias(Convert.ToDateTime(txtInicioVal.Text), Convert.ToDateTime(txtFinVal.Text));
BE_valorizar_equipoMenor oBESol = new BE_valorizar_equipoMenor();
oBESol.IDE_VAL = 0;//Convert.ToInt32(string.IsNullOrEmpty(lblcodigo.Text) ? "0" : lblcodigo.Text);
oBESol.MES = Convert.ToInt32(ddlMes.SelectedValue);
oBESol.ANIO = Convert.ToInt32(ddlanio.SelectedValue);
oBESol.Requ_Numero = Requ_Numero;
oBESol.Reqd_CodLinea = Reqd_CodLinea;
oBESol.Reqs_Correlativo = Reqs_Correlativo;
oBESol.Proy_Codigo = Proy_Codigo;
oBESol.Prov_RUC = D_Prov_RUC;
oBESol.FECHA_INICIO = lblV_FECHA_INICIO_VAL.Text;
oBESol.FECHA_FIN = lblV_FECHA_FIN_VAL.Text;
oBESol.IDE_MONEDA = Convert.ToInt32(lbl_ideMoneda.Text);
oBESol.PRECIO = Convert.ToDecimal(lblTARIFA_DIA.Text);
oBESol.DIA_TRABAJO = Convert.ToInt32(string.IsNullOrEmpty(lblDIAS_TRABAJO.Text) ? "0" : lblDIAS_TRABAJO.Text);
oBESol.DIA_DSCTO = Convert.ToInt32(txtDescuentoDia.Text);
oBESol.TOTAL = 0;
oBESol.DESCUENTO = Convert.ToInt32(txtDescuentoFinal.Text);
oBESol.FLG_FASES = Convert.ToInt32(FLG_FASES);
oBESol.USER_VALORIZA = Session["IDE_USUARIO"].ToString();
oBESol.ide_valor = ide_valor;
oBESol.OBSERVA = txtObservacion.Text;
oBESol.HES = txtHES.Text;
oBESol.PERIODO_INICIO = txtInicioVal.Text;
oBESol.PERIODO_FIN = txtFinVal.Text;
oBESol.UNIDAD_TARIFA = lblTarifa_unidad.Text;
int rpta;
rpta = new BL_TBL_RequerimientoSubDetalle().uspINS_valorizar_equipoMenor(oBESol);
if (rpta > 0)
{
registroUpdate++;
}
}
}
}
////fin
}
if (registroUpdate > 0)
{
cleanMessage = "Se actualización satisfactoria";
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true);
Listar("", "", "");
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "myScript", "gridviewScroll();", true);
}
}
}
