public string Excluir(TRegistro_CadImposto val) { Hashtable hs = new Hashtable(1); hs.Add("@P_CD_IMPOSTO", val.Cd_imposto); return(executarProc("EXCLUI_FIS_IMPOSTO", hs)); }
public string Gravar(TRegistro_CadImposto val) { Hashtable hs = new Hashtable(14); hs.Add("@P_CD_IMPOSTO", val.Cd_imposto); hs.Add("@P_DS_IMPOSTO", val.ds_imposto); hs.Add("@P_SIGLA", val.Sigla); hs.Add("@P_ST_REGISTRO", val.st_registro); hs.Add("@P_ST_PIS", val.St_PIS); hs.Add("@P_ST_COFINS", val.St_Cofins); hs.Add("@P_ST_ICMS", val.St_ICMS); hs.Add("@P_ST_ISSQN", val.St_ISSQN); hs.Add("@P_ST_CSLL", val.St_CSLL); hs.Add("@P_ST_IRRF", val.St_IRRF); hs.Add("@P_ST_INSS", val.St_INSS); hs.Add("@P_ST_IPI", val.St_IPI); hs.Add("@P_ST_II", val.St_II); hs.Add("@P_ST_FUNRURAL", val.St_Funrural); hs.Add("@P_ST_SENAR", val.St_Senar); return(executarProc("IA_FIS_IMPOSTO", hs)); }
public TList_CadImposto Select(TpBusca[] vBusca, Int32 vTop, string vNM_Campo) { TList_CadImposto lista = new TList_CadImposto(); SqlDataReader reader = null; bool podeFecharBco = false; if (Banco_Dados == null) { podeFecharBco = this.CriarBanco_Dados(false); } try { reader = this.ExecutarBusca(this.SqlCodeBusca(vBusca, Convert.ToInt16(vTop), vNM_Campo)); while (reader.Read()) { TRegistro_CadImposto reg = new TRegistro_CadImposto(); if (!(reader.IsDBNull(reader.GetOrdinal("CD_Imposto")))) { reg.Cd_imposto = reader.GetDecimal(reader.GetOrdinal("CD_Imposto")); } if (!(reader.IsDBNull(reader.GetOrdinal("DS_Imposto")))) { reg.ds_imposto = reader.GetString(reader.GetOrdinal("DS_Imposto")); } if (!reader.IsDBNull(reader.GetOrdinal("sigla"))) { reg.Sigla = reader.GetString(reader.GetOrdinal("sigla")); } if (!(reader.IsDBNull(reader.GetOrdinal("ST_Registro")))) { reg.st_registro = reader.GetString(reader.GetOrdinal("ST_Registro")); } if (!reader.IsDBNull(reader.GetOrdinal("st_pis"))) { reg.St_PIS = reader.GetBoolean(reader.GetOrdinal("st_pis")); } if (!reader.IsDBNull(reader.GetOrdinal("st_cofins"))) { reg.St_Cofins = reader.GetBoolean(reader.GetOrdinal("st_cofins")); } if (!reader.IsDBNull(reader.GetOrdinal("st_icms"))) { reg.St_ICMS = reader.GetBoolean(reader.GetOrdinal("st_icms")); } if (!reader.IsDBNull(reader.GetOrdinal("st_issqn"))) { reg.St_ISSQN = reader.GetBoolean(reader.GetOrdinal("st_issqn")); } if (!reader.IsDBNull(reader.GetOrdinal("st_csll"))) { reg.St_CSLL = reader.GetBoolean(reader.GetOrdinal("st_csll")); } if (!reader.IsDBNull(reader.GetOrdinal("st_irrf"))) { reg.St_IRRF = reader.GetBoolean(reader.GetOrdinal("st_irrf")); } if (!reader.IsDBNull(reader.GetOrdinal("st_inss"))) { reg.St_INSS = reader.GetBoolean(reader.GetOrdinal("st_inss")); } if (!reader.IsDBNull(reader.GetOrdinal("st_funrural"))) { reg.St_Funrural = reader.GetBoolean(reader.GetOrdinal("st_funrural")); } if (!reader.IsDBNull(reader.GetOrdinal("st_senar"))) { reg.St_Senar = reader.GetBoolean(reader.GetOrdinal("st_senar")); } if (!reader.IsDBNull(reader.GetOrdinal("ST_IPI"))) { reg.St_IPI = reader.GetBoolean(reader.GetOrdinal("ST_IPI")); } if (!reader.IsDBNull(reader.GetOrdinal("ST_II"))) { reg.St_II = reader.GetBoolean(reader.GetOrdinal("ST_II")); } lista.Add(reg); } } finally { reader.Close(); reader.Dispose(); if (podeFecharBco) { deletarBanco_Dados(); } } return(lista); }