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()); }