protected void Grabar()
{
string cleanMessage = string.Empty;
if (txtValor.Text == string.Empty)
{
cleanMessage = "Ingresar Valor";
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true);
}
else
{
BE_LOG_SOLPED oBESol = new BE_LOG_SOLPED();
oBESol = f_CapturarDatosCabecera();
DataTable dtrpta = new DataTable();
dtrpta = new BL_LOG_SOLPED().Mant_Insert_LOG_SOLPED(oBESol);
if (dtrpta.Rows.Count > 0)
{
cleanMessage = "Registro Exitoso";
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true);
ListarCodigos();
ddlCodigo.SelectedValue = dtrpta.Rows[0]["COD_PEDIDO"].ToString();
lblId.Text = dtrpta.Rows[0]["IDE_SOLICITUD"].ToString();
PanelPedidos.Visible = true;
ListarPedido();
}
else
{
}
}
}
public DataTable Mant_Insert_LOG_SOLPED(BE_LOG_SOLPED oBESOl)
{
try
{
return(new DA_LOG_SOLPED().Mant_Insert_LOG_SOLPED(oBESOl));
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable Mant_Insert_LOG_SOLPED(BE_LOG_SOLPED oBESOl)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IDE_SOLICITUD, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.COD_PEDIDO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IMPUTACION, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.SOCIEDAD, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.OBRA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FECHA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.VALOR, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.MONEDA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.CENTRO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.GR_COMPRA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.CENTRO_COSTE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.SOLICITANTE, tgSQLFieldType.TEXT),
};
return(new Util().EjecutaDatatable("uspINS_LOG_SOLPED", Parametros));
}
private BE_LOG_SOLPED f_CapturarDatosCabecera()
{
BE_LOG_SOLPED oBESol = new BE_LOG_SOLPED();
oBESol.IDE_SOLICITUD = Convert.ToInt32(string.IsNullOrEmpty(lblId.Text) ? "0" : lblId.Text);;
oBESol.COD_PEDIDO = ddlCodigo.SelectedValue.ToString();
oBESol.IMPUTACION = ddlImputacion.SelectedValue;
oBESol.SOCIEDAD = ddlSociedad.SelectedValue;
oBESol.OBRA = ddlObra.SelectedValue;
oBESol.FECHA = txtFecha.Text;
oBESol.VALOR = Convert.ToDecimal(string.IsNullOrEmpty(txtValor.Text) ? "0" : txtValor.Text);
oBESol.MONEDA = ddlMoneda.SelectedValue;
oBESol.CENTRO = ddlCentro.SelectedValue;
oBESol.GR_COMPRA = ddlGpoCompra.SelectedValue;
oBESol.CENTRO_COSTE = ddlCoste.SelectedValue;
oBESol.SOLICITANTE = Session["IDE_USUARIO"].ToString();
return(oBESol);
}
