private void CheckNoGlobalOrExternal(DataDivision node) { if (node == null) { return; // no DATA DIVISION } foreach (var section in node.Children()) // "storage" sections { foreach (var child in section.Children) { var data = child.CodeElement as DataDescriptionEntry; if (data == null) { continue; } if (data.IsGlobal) // TCRFUN_DECLARATION_NO_GLOBAL { DiagnosticUtils.AddError(data, "Illegal GLOBAL clause in function data item."); } if (data.IsExternal) // TCRFUN_DECLARATION_NO_EXTERNAL { DiagnosticUtils.AddError(data, "Illegal EXTERNAL clause in function data item."); } } } }
public int GetDivisionEdit(DataDivision datadivision) { try { //DataDivision division = new DataDivision(); using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("Facturacion.spu_COMP_InsCambiosClientes", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@sClienteRFC", SqlDbType.NVarChar).Value = datadivision.Rfc.ToString().Trim(); cmd.Parameters.AddWithValue("@sClienteNew", SqlDbType.Char).Value = datadivision.Cliente.ToString().Trim(); cmd.Parameters.AddWithValue("@DivisionNew", SqlDbType.Char).Value = datadivision.Division.ToString().Trim(); cmd.Parameters.AddWithValue("@sUsuario", SqlDbType.Char).Value = datadivision.Usuario.ToString().Trim(); con.Open(); //cmd.ExecuteNonQuery(); //con.Close(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { datadivision.Idcambio = Convert.ToInt32(rdr["idCambio"]); } foreach (FacturasRFC item in datadivision.Selectedrows) { SqlCommand command = new SqlCommand("Facturacion.spu_COMP_cambiosCliente", con); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@idCambio", SqlDbType.Int).Value = datadivision.Idcambio; command.Parameters.AddWithValue("@filial", SqlDbType.Char).Value = datadivision.Filial.ToString().Trim(); command.Parameters.AddWithValue("@suc", SqlDbType.Char).Value = datadivision.Sucursal.ToString().Trim(); command.Parameters.AddWithValue("@division", SqlDbType.Char).Value = datadivision.Division.ToString().Trim(); command.Parameters.AddWithValue("@cliente", SqlDbType.Char).Value = datadivision.Cliente.ToString().Trim(); command.Parameters.AddWithValue("@cteAnterior", SqlDbType.Char).Value = item.Cliente.ToString().Trim(); command.Parameters.AddWithValue("@Factura", SqlDbType.Char).Value = item.Factura.ToString().Trim(); command.Parameters.AddWithValue("@Usuario", SqlDbType.Char).Value = datadivision.Usuario.ToString().Trim(); command.ExecuteNonQuery(); } con.Close(); } return(1); } catch (Exception) { throw; } }
private void CheckNoGlobalOrExternal(DataDivision node) { if (node == null) return; // no DATA DIVISION foreach(var section in node.Children()) { // "storage" sections foreach(var child in section.Children()) { var data = child.CodeElement as DataDescriptionEntry; if (data == null) continue; if (data.IsGlobal) // TCRFUN_DECLARATION_NO_GLOBAL DiagnosticUtils.AddError(data, "Illegal GLOBAL clause in function data item."); if (data.IsExternal) // TCRFUN_DECLARATION_NO_EXTERNAL DiagnosticUtils.AddError(data, "Illegal EXTERNAL clause in function data item."); } } }
public int Editar([FromBody] DataDivision datadivision) { return(objfacturas.GetDivisionEdit(datadivision)); }
public virtual bool Visit(DataDivision dataDivision) { return(true); }