protected void grdOSMaterial_RowCommand(object sender, GridViewCommandEventArgs e)
{
tblOSMaterial table = null;
try
{
switch (e.CommandName.ToLower().Trim())
{
case "excluir":
table = new tblOSMaterial();
table.cmpIdOsMaterial = e.CommandArgument.ToString();
table.cmpNoUsuario = ((HzLibGeneral.Util.HzLogin)Session["login"]).cmpNoUsuario;
if (table.ExcluirOSMaterial(Global.GetConnection()))
{
TotalizaMaterialOS();
loadMaterial();
LimpaCampos();
}
break;
}
}
catch (Exception ex)
{
Global.ShowError(Global.Title, ex);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
tblOSMaterial table = null;
try
{
if (ValidarAlteracaoMaterial())
{
table = new tblOSMaterial();
table.cmpIdOsMaterial = ViewState["cmpIdOSMaterial"].ToString();
table.cmpCoObraGrupoMaterial = ViewState["cmpCoObraGrupoMaterial"].ToString();
table.cmpQtMaterial = (txtQuantiMaterial.Text.Length < 4 ? "0." + txtQuantiMaterial.Text : txtQuantiMaterial.Text);
table.cmpVlMaterial = txtVlMat.Text.Replace(",", ".");
table.cmpInControle = chkControle2.Checked == true ? "1" : "0";
table.cmpNoUsuario = ((HzLibGeneral.Util.HzLogin)Session["login"]).cmpNoUsuario.TrimEnd();
if ((table.AlterarOSMaterial(Global.GetConnection())))
{
loadMaterial();
TotalizaMaterialOS();
this.ModalPopupExtender2.Hide();
}
}
}
catch (Exception ex)
{
Global.ShowError(Global.Title, ex);
}
}
/// <summary>
/// Grava dados da OS na tblOS.
/// </summary>
private bool GravarOSMaterial()
{
bool retval = false;
try
{
if (ValidarInclusaoMaterial())
{
tblOSMaterial table = null;
table = new tblOSMaterial();
table.cmpIdOsMaterial = ViewState["cmpIdOSMaterial"].ToString();
table.cmpIdOs = ViewState["cmpIdOs"].ToString();
table.cmpCoObraGrupoMaterial = ViewState["cmpCoObraGrupoMaterial"].ToString();
table.cmpQtMaterial = (txtQtMaterial.Text.Length < 4 ? "0." + txtQtMaterial.Text : txtQtMaterial.Text);
table.cmpVlMaterial = txtValorMaterial.Text.Replace(",", ".");
table.cmpInControle = chkControle.Checked == true ? "1" : "0";
table.cmpNoUsuario = ((HzLibGeneral.Util.HzLogin)Session["login"]).cmpNoUsuario;
if ((retval = table.GravarOSMaterial(Global.GetConnection())))
{
loadMaterial();
LimpaCampos();
txtItemMaterial.Focus();
}
}
return(retval);
}
catch (Exception ex)
{
Global.ShowError(Global.Title, ex);
return(false);
}
}
/// <summary>
/// Gravar total do material na Ordem de serviço.
/// /// </summary>
private void TotalizaMaterialOS()
{
tblOSMaterial table = new tblOSMaterial();
table.cmpIdOs = ViewState["cmpIdOs"].ToString();
table.cmpNoUsuario = ((HzLibGeneral.Util.HzLogin)Session["login"]).cmpNoUsuario;
table.TotalizaMaterialOS(Global.GetConnection());
}
