public long GuardarBultos(int nid_arrive, string nid_sku, int nid_sku_type, string clocation, int nid_sku_state, int nid_sku_level) { InsertSQL = "INSERT INTO sku_arrivals " + "(nid_arrive, nid_sku, nid_sku_type, clocation, nid_sku_state, nid_sku_level, bloaded) " + "VALUES (@nid_arrive,@nid_sku,@nid_sku_type,@clocation, @nid_sku_state,@nid_sku_level, 0)"; InsertParametros.Add("@nid_arrive", SqlDbType.VarChar, 100).Value = nid_arrive; InsertParametros.Add("@nid_sku", SqlDbType.VarChar, 100).Value = nid_sku; InsertParametros.Add("@nid_sku_type", SqlDbType.VarChar, 100).Value = nid_sku_type; InsertParametros.Add("@clocation", SqlDbType.VarChar, 100).Value = clocation; InsertParametros.Add("@nid_sku_state", SqlDbType.VarChar, 100).Value = nid_sku_state; InsertParametros.Add("@nid_sku_level", SqlDbType.VarChar, 100).Value = nid_sku_level; return(this.insert()); }
public void LogCambioDueno(string nid_skuLog, int nid_userLog, int idCteAnt, int idCteNvo) { //Guarda en el log el cliente que se elimino InsertSQL = "INSERT INTO log_cambiodueno VALUES (@nid_sku, @movimiento, GETDATE(), @nid_user, @idCliente)"; InsertParametros.Add("@nid_sku", SqlDbType.VarChar, 100).Value = nid_skuLog; InsertParametros.Add("@movimiento", SqlDbType.VarChar, 40).Value = "Desasignar Cliente"; InsertParametros.Add("@nid_user", SqlDbType.Int, 4).Value = nid_userLog; InsertParametros.Add("@idCliente", SqlDbType.Int, 4).Value = idCteAnt; insert(); InsertSQL = "INSERT INTO log_cambiodueno VALUES (@nid_sku, @movimiento, GETDATE(), @nid_user, @idCliente)"; InsertParametros.Add("@nid_sku", SqlDbType.VarChar, 100).Value = nid_skuLog; InsertParametros.Add("@movimiento", SqlDbType.VarChar, 40).Value = "Asignar Cliente"; InsertParametros.Add("@nid_user", SqlDbType.Int, 4).Value = nid_userLog; InsertParametros.Add("@idCliente", SqlDbType.Int, 4).Value = idCteNvo; insert(); }